ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   historical price data into excel from msn money (https://www.excelbanter.com/excel-programming/432902-historical-price-data-into-excel-msn-money.html)

thomas donino

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

Matthew Herbert[_3_]

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



All times are GMT +1. The time now is 07:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com