Yahoo! Finance Historical 1-Minute

Yahoo! Finance Historical 1-Minute

Usage

Excel formula:

=RTD("gartle.rtd",,"YahooFinanceHistorical1min","<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",,"YahooFinanceHistorical1min","YHOO","2014-12-31","Close")
=RTD("gartle.rtd",,"YahooFinanceHistorical1min","YHOO",,"Close")

Use http://finance.yahoo.com/ to find tickers.

Important Notes

Do not request the Yahoo! website frequently. Otherwise, your IP can be banned by the Yahoo! website.

Historical data for one ticker symbol are downloaded by one request to a web service. This feature significantly reduces the amount of requests to the Yahoo! 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 ColumnExcel Formula
Symbol 
Date
Open=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"Open")
High=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"High")
Low=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"Low")
Close=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"Close")
Change=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"Change")
ChangeInPercent=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"ChangeInPercent")
ChangePercent=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"ChangePercent")
PercentChange=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"PercentChange")
AdjClose=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"AdjClose")
AdjChange=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"AdjChange")
AdjChangeInPercent=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"AdjChangeInPercent")
AdjChangePercent=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"AdjChangePercent")
AdjPercentChange=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"AdjPercentChange")
Volume=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"Volume")
PrevDate=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"PrevDate")
PrevOpen=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"PrevOpen")
PrevHigh=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"PrevHigh")
PrevLow=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"PrevLow")
PrevClose=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"PrevClose")
PrevAdjClose=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"PrevAdjClose")
PrevVolume=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"PrevVolume")
rtd_LastError=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"rtd_LastError")
rtd_LastMessage=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"rtd_LastMessage")
rtd_LastUpdate=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"rtd_LastUpdate")
rtd_LastUpdateDate=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"rtd_LastUpdateDate")
rtd_LastUpdateTime=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Date],"rtd_LastUpdateTime")

See Copying formulas about inserting formulas into Excel spreadsheets.

Change, ChangeInPercent, AdjChange, and AdjChangeInPercent calculated by RealTimeToExcel.

Aggregate Functions

Excel ColumnExcel Formula
Symbol 
Day 
Day=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Day],"Day")
Date=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Day],"Date")
AverageVolume=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Day],"AverageVolume")
rtd_LastError=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Day],"rtd_LastError")
rtd_LastMessage=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Day],"rtd_LastMessage")
rtd_LastUpdate=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Day],"rtd_LastUpdate")
rtd_LastUpdateDate=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Day],"rtd_LastUpdateDate")
rtd_LastUpdateTime=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],[Day],"rtd_LastUpdateTime")

If the stock history has no required number of records 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 Days

Excel ColumnExcel Formula
Symbol 
Date=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],"TradingDay",[Day])
rtd_LastError=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],"TradingDay","rtd_LastError")
rtd_LastMessage=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],"TradingDay","rtd_LastMessage")
rtd_LastUpdate=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],"TradingDay","rtd_LastUpdate")
rtd_LastUpdateDate=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],"TradingDay","rtd_LastUpdateDate")
rtd_LastUpdateTime=RTD("gartle.rtd",,"YahooFinanceHistorical1min",[Symbol],"TradingDay","rtd_LastUpdateTime")

All the trading records are loaded from one file, and the functions work very fast.

You may use the only one stock symbol to get the records for other tickers.

Data Provider Settings

The data provider is configured to loading data every 6 hours when the Excel workbook is open.

See Data provider settings.

ParameterValue
RefreshInterval06:00:00, six hours
NextRequestDelay1000, one second
DataStartTime00:00:00 -05:00
DataEndTime24:00:00 -05:00
LoadEndTime24:00:00 -05:00
LoadOnSaturday1, loading Friday's data once.
LoadOnSunday1, loading Friday's data once.

Data Source

The Yahoo! Finance website.

Example:

http://finance.yahoo.com/quote/AAPL?p=AAPL