Yahoo! Finance Currencies
Usage
Excel formula:
=RTD("gartle.rtd",,"YahooFinanceCurrencies","<Ticker>","<Data Field>")
Example:
=RTD("gartle.rtd",,"YahooFinanceCurrencies","EURUSD=X","Last")
Use https://finance.yahoo.com/ to find tickers.
Supported ticker formats, on the EURUSD pair example:
EURUSD, UER/USD, EUR-USD, EUR_USD, EURUSD=X
You can get these codes using the Symbol1 - Symbol5 columns.
Important Notes
The data are loaded from the yahoo.finance.quoteslist table as for stocks.
However, this provider loads data for all currencies in one request.
This feature ensures that the data for all pairs are loaded at the same time.
Due this, you can request the Yahoo! Finance web service more frequently.
For example, for 1-minute requests, it is 24 * 60 = 1440 requests per day for any number of pairs.
Data Fields and Excel Formulas
| Excel Column | Excel Formula |
|---|---|
| Symbol | |
| LastTradeDateTime | =RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"LastTradeDateTime") |
| LastTradeDate | =RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"LastTradeDate") |
| LastTradeTime | =RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"LastTradeTime") |
| Bid | =RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Bid") |
| Ask | =RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Ask") |
| Last | =RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Last") |
| Change | =RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Change") |
| ChangeInPercent | =RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"ChangeInPercent") |
| ChangePercent | =RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"ChangePercent") |
| PercentChange | =RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"PercentChange") |
| Open | =RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Open") |
| High | =RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"High") |
| Low | =RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Low") |
| Symbol1 | =RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Symbol1") |
| Symbol2 | =RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Symbol2") |
| Symbol3 | =RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Symbol3") |
| Symbol4 | =RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Symbol4") |
| Symbol5 | =RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Symbol5") |
| rtd_LastError | =RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"rtd_LastError") |
| rtd_LastMessage | =RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"rtd_LastMessage") |
| rtd_LastUpdate | =RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"rtd_LastUpdate") |
| rtd_LastUpdateDate | =RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"rtd_LastUpdateDate") |
| rtd_LastUpdateTime | =RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"rtd_LastUpdateTime") |
Synonyms: ChangeInPercent, ChangePercent, and PercentChange.
See Copying formulas about inserting formulas into Excel spreadsheets.
The ChangeInPercent value is calculated by RealTimeToExcel.
Data Provider Settings
The data provider is configured to loading data every 5 minutes when the Excel workbook is open.
| Parameter | Value |
|---|---|
| RefreshInterval | 00:05:00, 5 minutes |
| NextRequestDelay | 1000, one second |
| DataStartTime | 00:00:00 -05:00 |
| DataEndTime | 24:00:00 -05:00 |
| LoadEndTime | 24:00:00 -05:00 |
| LoadOnSaturday | 0, loading as for other days. |
| LoadOnSunday | 0, loading as for other days. |
Data Source
http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.quoteslist
Special thanks to http://www.philadelphia-reflections.com/blog/2392.htm