Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
historical price data into excel from msn money
Does anyone know how to download more than just one days quote for a stock on
msn money? I am trying to import the last 300 days of data for each symbol i follow |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
historical price data into excel from msn money
Thomas,
I think that Yahoo! provides a better interface for getting historical pricing data (see http://finance.yahoo.com/q/hp?s=APOL -- where s= is the ticker symbol); however, the link below should do roughly the same thing with MSN. Since I haven't used the MSN link at all, I haven't taken the time to discover all of the arguments. You'll have to play around with the "C#" (where # is a number) arguments to determine how the data is returned for the specified "C#" argument. You probably need to change only the "C#" that follow the "symbol=" parameter. http://data.moneycentral.msn.com/scr...9&C7=6&C8=2009 (symbol= is the ticker symbol) Best, Matthew Herbert "thomas donino" wrote: Does anyone know how to download more than just one days quote for a stock on msn money? I am trying to import the last 300 days of data for each symbol i follow |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Money data into Excel | Excel Programming | |||
How do i get historical stock quotes using MSN Money Stock Quotes | Excel Discussion (Misc queries) | |||
Downloading historical stock data from MSN Money to Excel via VBA | Excel Programming | |||
how do i import excel data into Money 05? | Excel Discussion (Misc queries) | |||
MSN MoneyCentral Stock Quotes support historical price look-ups | Excel Worksheet Functions |