What Tasks Can Be Automated?

[John Gregory]

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?

 

[Tim Williams]

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

tim

 

[Daniel Klann]

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

 

[John Gregory]

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.

 

[Tom Ogilvy]

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.

 

[John Gregory]

I got the same earlier this AM, Tom. Here's the site:
http://research.stlouisfed.org/fred2/series/MZMSL/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.