MSN Money Historical Prices by Months
Usage
Excel formula:
=RTD("gartle.rtd",,"MsnMoneyHistoricalMonths","<Ticker>",[<date>],"<Data Field>")
where <date> is a Microsoft Excel date value or a string value as "yyyy-mm-dd".
If <date> is empty or equal to 0 then the last trade date is used by default. It is useful to monitor the last trade
date data.
Example:
=RTD("gartle.rtd",,"MsnMoneyHistoricalMonths","GOOG","2014-12-31","Close")
=RTD("gartle.rtd",,"MsnMoneyHistoricalMonths","GOOG",,"Close")
Use https://www.msn.com/en-us/money to find tickers.
Important Notes
Do not request the MSN Money website frequently. Otherwise, your IP can be banned by the MSN Money website.
Historical data for one ticker symbol is downloaded by one request to a web service. This feature significantly reduces the amount of requests to the MSN Money website.
The amount of data depends on the entire data period that is calculated for all stocks in opened workbooks.
Data Fields and Excel Formulas
| Excel Column | Excel Formula |
|---|---|
| Symbol | |
| Date | |
| Open | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"Open") |
| High | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"High") |
| Low | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"Low") |
| Close | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"Close") |
| Change | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"Change") |
| ChangeInPercent | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"ChangeInPercent") |
| ChangePercent | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"ChangePercent") |
| PercentChange | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"PercentChange") |
| AdjClose | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"AdjClose") |
| AdjChange | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"AdjChange") |
| AdjChangeInPercent | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"AdjChangeInPercent") |
| AdjChangePercent | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"AdjChangePercent") |
| AdjPercentChange | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"AdjPercentChange") |
| Volume | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"Volume") |
| PrevDate | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"PrevDate") |
| PrevOpen | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"PrevOpen") |
| PrevHigh | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"PrevHigh") |
| PrevLow | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"PrevLow") |
| PrevClose | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"PrevClose") |
| PrevAdjClose | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"PrevAdjClose") |
| PrevVolume | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"PrevVolume") |
| rtd_LastError | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"rtd_LastError") |
| rtd_LastMessage | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"rtd_LastMessage") |
| rtd_LastUpdate | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"rtd_LastUpdate") |
| rtd_LastUpdateDate | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"rtd_LastUpdateDate") |
| rtd_LastUpdateTime | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Date],"rtd_LastUpdateTime") |
Fields like AdjClose are added for compatibility with Yahoo! Finance data.
Synonyms: ChangeInPercent, ChangePercent, and PercentChange; AdjChangeInPercent, AdjChangePercent, and AdjPercentChange.
See Copying formulas about inserting formulas into Excel spreadsheets.
Change, ChangeInPercent, AdjChange, and AdjChangeInPercent calculated by RealTimeToExcel.
Aggregate Functions
| Excel Column | Excel Formula |
|---|---|
| Symbol | |
| Day | |
| Day | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Day],"Day") |
| Date | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Day],"Date") |
| AverageVolume | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Day],"AverageVolume") |
| rtd_LastError | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Day],"rtd_LastError") |
| rtd_LastMessage | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Day],"rtd_LastMessage") |
| rtd_LastUpdate | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Day],"rtd_LastUpdate") |
| rtd_LastUpdateDate | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Day],"rtd_LastUpdateDate") |
| rtd_LastUpdateTime | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],[Day],"rtd_LastUpdateTime") |
If the stock history has no required number of months to calculate aggregates then the average volume is not calculated (= 0), and the Day and Date fields contain the last values of the period.
Trading Months
| Excel Column | Excel Formula |
|---|---|
| Symbol | |
| Date | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],"TradingDay",[Day]) |
| rtd_LastError | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],"TradingDay","rtd_LastError") |
| rtd_LastMessage | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],"TradingDay","rtd_LastMessage") |
| rtd_LastUpdate | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],"TradingDay","rtd_LastUpdate") |
| rtd_LastUpdateDate | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],"TradingDay","rtd_LastUpdateDate") |
| rtd_LastUpdateTime | =RTD("gartle.rtd",,"MsnMoneyHistoricalMonths",[Symbol],"TradingDay","rtd_LastUpdateTime") |
All the trading months are loaded from one file, and the functions work very fast.
You can use the only one stock symbol to get the months for other tickers.
Data Provider Settings
The data provider is configured to loading data every 6 hours when the Excel workbook is open.
| Parameter | Value |
|---|---|
| RefreshInterval | 06:00:00, six hours |
| NextRequestDelay | 1000, one second |
| DataStartTime | 00:00:00 -05:00 |
| DataEndTime | 24:00:00 -05:00 |
| LoadEndTime | 24:00:00 -05:00 |
| LoadOnSaturday | 1, loading Friday's data once. |
| LoadOnSunday | 1, loading Friday's data once. |
Data Source
The MSN Money website.
Example:
https://www.msn.com/en-us/money/stockdetails/historical-price/fi-126.1.AAPL.NAS