What Tasks Can Be Automated?
 

I need to...
1) download 50 + data points each week to a worksheet
2) invert the order of these numbers
3) place then into a worksheet where they can be highlighted with the
cursor so they can be charted (or can this be dome right on the 1st spread
sheet?)
4) graph a chart

Can all of this be done with one macro? IF not, which parts can?

What Tasks Can Be Automated?
 

Download from where?
Probably can all be done in one macro.

tim




"John Gregory" wrote in message
...
I need to...
1) download 50 + data points each week to a worksheet
2) invert the order of these numbers
3) place then into a worksheet where they can be highlighted with
the
cursor so they can be charted (or can this be dome right on the 1st
spread
sheet?)
4) graph a chart

Can all of this be done with one macro? IF not, which parts can?

What Tasks Can Be Automated?
 

Hi John,

2, 3 and 4 can all be done. Where are you downloading the '50+ data points'
from? That's probably also possible but depends where you're getting the
data from. Your best bet is to record a macro and look at the code. You
can then ask questions about how to modify it or experiment yourself.

Regards,
Daniel
-----------------------------------------
Website : http://www.danielklann.com
Favourites Add-in for Microsoft Excel -
http://www.danielklann.com/excel/exc...tes_add-in.htm
-----------------------------------------


"John Gregory" wrote in message
...
I need to...
1) download 50 + data points each week to a worksheet
2) invert the order of these numbers
3) place then into a worksheet where they can be highlighted with the
cursor so they can be charted (or can this be dome right on the 1st spread
sheet?)
4) graph a chart

Can all of this be done with one macro? IF not, which parts can?

What Tasks Can Be Automated?
 

Data will come from the Federal Reserve Bank of St. Louis (sample:
http://research.stlouisfed.org/fred2/series/MZMSL/30 .... the data from the
download area).

What's the function that I should use to invert the downloaded data once
it's in columnar form? If all goes well, I plan to toy with this later
today.

I apprecaiate the help.

"Daniel Klann" wrote in message
...

Hi John,

2, 3 and 4 can all be done. Where are you downloading the '50+ data
points'
from? That's probably also possible but depends where you're getting the
data from. Your best bet is to record a macro and look at the code. You
can then ask questions about how to modify it or experiment yourself.

Regards,
Daniel
-----------------------------------------
Website : http://www.danielklann.com
Favourites Add-in for Microsoft Excel -
http://www.danielklann.com/excel/exc...tes_add-in.htm
-----------------------------------------


"John Gregory" wrote in message
...
I need to...
1) download 50 + data points each week to a worksheet
2) invert the order of these numbers
3) place then into a worksheet where they can be highlighted with the
cursor so they can be charted (or can this be dome right on the 1st
spread
sheet?)
4) graph a chart

Can all of this be done with one macro? IF not, which parts can?

What Tasks Can Be Automated?
 

Results:
Temporarily down for maintenance.

What do you mean by invert? (it might be obvious by looking at the link,
but as I said, the link isn't working right now).

Small sample of what you get and what you want.

--
Regards,
Tom Ogilvy

John Gregory wrote in message
...
Data will come from the Federal Reserve Bank of St. Louis (sample:
http://research.stlouisfed.org/fred2/series/MZMSL/30 .... the data from
the
download area).

What's the function that I should use to invert the downloaded data once
it's in columnar form? If all goes well, I plan to toy with this later
today.

I apprecaiate the help.

"Daniel Klann" wrote in message
...

Hi John,

2, 3 and 4 can all be done. Where are you downloading the '50+ data
points'
from? That's probably also possible but depends where you're getting
the
data from. Your best bet is to record a macro and look at the code.
You
can then ask questions about how to modify it or experiment yourself.

Regards,
Daniel
-----------------------------------------
Website : http://www.danielklann.com
Favourites Add-in for Microsoft Excel -
http://www.danielklann.com/excel/exc...tes_add-in.htm
-----------------------------------------


"John Gregory" wrote in message
...
I need to...
1) download 50 + data points each week to a worksheet
2) invert the order of these numbers
3) place then into a worksheet where they can be highlighted with
the
cursor so they can be charted (or can this be dome right on the 1st
spread
sheet?)
4) graph a chart

Can all of this be done with one macro? IF not, which parts can?

What Tasks Can Be Automated?
 

I got the same earlier this AM, Tom. Here's the site:
http://research.stlouisfed.org/fred2...L/downloaddata . The file is
"MZMSL.xls". A sample of the results:

Title: MZM Money Stock
Series ID: MZMSL
Source: Federal Reserve Bank of St. Louis
Release: Not Applicable
Seasonal Adjustment: Seasonally Adjusted
Frequency: Monthly
Units: Billions of Dollars
Date Range: 1974-01-01 to 2003-12-01
Last Updated: 2004-01-30 9:06 AM CT
Notes: Money Zero Maturity. Further information and
definitions are available
at: http://research.stlouisfed.org/publications/mt/.

DATE VALUE
Jan-74 591.461
Feb-74 593.233
Mar-74 595.637
Apr-74 596.975
May-74 597.584
Jun-74 599.230
Jul-74 601.526
Aug-74 602.772
Sep-74 604.540
Oct-74 607.688
Nov-74 611.355


Now with regard to "invert", there are occasions when I would want to have
this data in reverse order along with the properly associated dates.

"Tom Ogilvy" wrote in message
...
Results:
Temporarily down for maintenance.

What do you mean by invert? (it might be obvious by looking at the link,
but as I said, the link isn't working right now).

Small sample of what you get and what you want.

--
Regards,
Tom Ogilvy

John Gregory wrote in message
...
Data will come from the Federal Reserve Bank of St. Louis (sample:
http://research.stlouisfed.org/fred2/series/MZMSL/30 .... the data from
the
download area).

What's the function that I should use to invert the downloaded data once
it's in columnar form? If all goes well, I plan to toy with this later
today.

I apprecaiate the help.

"Daniel Klann" wrote in message
...

Hi John,

2, 3 and 4 can all be done. Where are you downloading the '50+ data
points'
from? That's probably also possible but depends where you're getting
the
data from. Your best bet is to record a macro and look at the code.
You
can then ask questions about how to modify it or experiment yourself.

Regards,
Daniel
-----------------------------------------
Website : http://www.danielklann.com
Favourites Add-in for Microsoft Excel -
http://www.danielklann.com/excel/exc...tes_add-in.htm
-----------------------------------------


"John Gregory" wrote in message
...
I need to...
1) download 50 + data points each week to a worksheet
2) invert the order of these numbers
3) place then into a worksheet where they can be highlighted with
the
cursor so they can be charted (or can this be dome right on the 1st
spread
sheet?)
4) graph a chart

Can all of this be done with one macro? IF not, which parts can?