What Tasks Can Be Automated?

  • Thread starter Thread starter John Gregory
  • Start date Start date
J

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?
 
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
 
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.
 
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.
 
Back
Top