RealTimeToExcel Views for Yahoo! Finance
Preconfigured Views
* Click on the view name to go to the view description.
Real-Time Views for Microsoft SQL Server and Microsoft SQL Server Compact
FundamentalsDayHistoryYahoo
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Symbol | |
| Date | |
| LastTradeTime | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"LastTradeTime") |
| Last | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"Last") |
| Change | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"Change") |
| PercentChange | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"PercentChange") |
| Open | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"Open") |
| High | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"High") |
| Low | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"Low") |
| Volume | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"Volume") |
| DaysRange | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"DaysRange") |
| PrevClose | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"PrevClose") |
| ShortRatio | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"ShortRatio") |
| YearHigh | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"YearHigh") |
| YearLow | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"YearLow") |
| YearRange | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"YearRange") |
| ChangeFromYearHigh | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"ChangeFromYearHigh") |
| ChangeFromYearLow | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"ChangeFromYearLow") |
| PercentChangeFromYearHigh | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"PercentChangeFromYearHigh") |
| PercentChangeFromYearLow | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"PercentChangeFromYearLow") |
| MA50 | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"MA50") |
| MA200 | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"MA200") |
| ChangeFromMA50 | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"ChangeFromMA50") |
| ChangeFromMA200 | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"ChangeFromMA200") |
| PercentChangeFromMA50 | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"PercentChangeFromMA50") |
| PercentChangeFromMA200 | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"PercentChangeFromMA200") |
| AverageDailyVolume | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"AverageDailyVolume") |
| OneYearTargetPrice | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"OneYearTargetPrice") |
| PE | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"PE") |
| PEG | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"PEG") |
| EPSEstCurrentYear | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"EPSEstCurrentYear") |
| EPSEstNextQuarter | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"EPSEstNextQuarter") |
| EPSEstNextYear | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"EPSEstNextYear") |
| EarningsShare | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"EarningsShare") |
| MarketCap | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"MarketCap") |
| DividendYield | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"DividendYield") |
| DividendShare | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"DividendShare") |
| ExDividendDate | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"ExDividendDate") |
| DividendPayDate | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"DividendPayDate") |
| BookValue | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"BookValue") |
| PriceBook | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"PriceBook") |
| PriceSales | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"PriceSales") |
| PriceEPSEstCurrentYear | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"PriceEPSEstCurrentYear") |
| PriceEPSEstNextYear | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"PriceEPSEstNextYear") |
| EBITDA | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"EBITDA") |
| CompanyName | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"CompanyName") |
| StockExchange | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"StockExchange") |
| Commission | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"Commission") |
| Notes | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"Notes") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"LastUpdateTimeStamp") |
| RTD_LastMessage | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsDayHistoryYahoo",[Symbol],[Date],"RTD_LastMessage") |
FundamentalsYahoo
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Symbol | |
| LastTradeDate | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"LastTradeDate") |
| LastTradeTime | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"LastTradeTime") |
| Last | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"Last") |
| Change | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"Change") |
| PercentChange | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"PercentChange") |
| Open | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"Open") |
| High | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"High") |
| Low | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"Low") |
| Volume | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"Volume") |
| DaysRange | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"DaysRange") |
| PrevClose | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"PrevClose") |
| ShortRatio | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"ShortRatio") |
| YearHigh | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"YearHigh") |
| YearLow | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"YearLow") |
| YearRange | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"YearRange") |
| ChangeFromYearHigh | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"ChangeFromYearHigh") |
| ChangeFromYearLow | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"ChangeFromYearLow") |
| PercentChangeFromYearHigh | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"PercentChangeFromYearHigh") |
| PercentChangeFromYearLow | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"PercentChangeFromYearLow") |
| MA50 | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"MA50") |
| MA200 | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"MA200") |
| ChangeFromMA50 | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"ChangeFromMA50") |
| ChangeFromMA200 | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"ChangeFromMA200") |
| PercentChangeFromMA50 | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"PercentChangeFromMA50") |
| PercentChangeFromMA200 | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"PercentChangeFromMA200") |
| AverageDailyVolume | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"AverageDailyVolume") |
| OneYearTargetPrice | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"OneYearTargetPrice") |
| PE | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"PE") |
| PEG | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"PEG") |
| EPSEstCurrentYear | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"EPSEstCurrentYear") |
| EPSEstNextQuarter | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"EPSEstNextQuarter") |
| EPSEstNextYear | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"EPSEstNextYear") |
| EarningsShare | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"EarningsShare") |
| MarketCap | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"MarketCap") |
| DividendYield | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"DividendYield") |
| DividendShare | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"DividendShare") |
| ExDividendDate | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"ExDividendDate") |
| DividendPayDate | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"DividendPayDate") |
| BookValue | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"BookValue") |
| PriceBook | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"PriceBook") |
| PriceSales | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"PriceSales") |
| PriceEPSEstCurrentYear | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"PriceEPSEstCurrentYear") |
| PriceEPSEstNextYear | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"PriceEPSEstNextYear") |
| EBITDA | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"EBITDA") |
| CompanyName | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"CompanyName") |
| StockExchange | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"StockExchange") |
| Commission | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"Commission") |
| Notes | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"Notes") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"LastUpdateTimeStamp") |
| RTD_LastMessage | =RTD("gartle.rtd",,"rtd-mssql","FundamentalsYahoo",[Symbol],"RTD_LastMessage") |
OptionDayHistoryYahoo
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Code | |
| Date | |
| Time | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryYahoo",[Code],[Date],"Time") |
| OptionCode | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryYahoo",[Code],[Date],"OptionCode") |
| Symbol | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryYahoo",[Code],[Date],"Symbol") |
| OptionSymbol | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryYahoo",[Code],[Date],"OptionSymbol") |
| ExpDate | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryYahoo",[Code],[Date],"ExpDate") |
| Strike | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryYahoo",[Code],[Date],"Strike") |
| Type | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryYahoo",[Code],[Date],"Type") |
| Last | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryYahoo",[Code],[Date],"Last") |
| Change | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryYahoo",[Code],[Date],"Change") |
| PercentChange | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryYahoo",[Code],[Date],"PercentChange") |
| Mark | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryYahoo",[Code],[Date],"Mark") |
| Bid | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryYahoo",[Code],[Date],"Bid") |
| Ask | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryYahoo",[Code],[Date],"Ask") |
| Volume | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryYahoo",[Code],[Date],"Volume") |
| OpenInt | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryYahoo",[Code],[Date],"OpenInt") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryYahoo",[Code],[Date],"LastUpdateTimeStamp") |
| RTD_LastMessage | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryYahoo",[Code],[Date],"RTD_LastMessage") |
OptionsYahoo
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Code | |
| Date | =RTD("gartle.rtd",,"rtd-mssql","OptionsYahoo",[Code],"Date") |
| Time | =RTD("gartle.rtd",,"rtd-mssql","OptionsYahoo",[Code],"Time") |
| OptionCode | =RTD("gartle.rtd",,"rtd-mssql","OptionsYahoo",[Code],"OptionCode") |
| Symbol | =RTD("gartle.rtd",,"rtd-mssql","OptionsYahoo",[Code],"Symbol") |
| OptionSymbol | =RTD("gartle.rtd",,"rtd-mssql","OptionsYahoo",[Code],"OptionSymbol") |
| ExpDate | =RTD("gartle.rtd",,"rtd-mssql","OptionsYahoo",[Code],"ExpDate") |
| Strike | =RTD("gartle.rtd",,"rtd-mssql","OptionsYahoo",[Code],"Strike") |
| Type | =RTD("gartle.rtd",,"rtd-mssql","OptionsYahoo",[Code],"Type") |
| Last | =RTD("gartle.rtd",,"rtd-mssql","OptionsYahoo",[Code],"Last") |
| Change | =RTD("gartle.rtd",,"rtd-mssql","OptionsYahoo",[Code],"Change") |
| PercentChange | =RTD("gartle.rtd",,"rtd-mssql","OptionsYahoo",[Code],"PercentChange") |
| Mark | =RTD("gartle.rtd",,"rtd-mssql","OptionsYahoo",[Code],"Mark") |
| Bid | =RTD("gartle.rtd",,"rtd-mssql","OptionsYahoo",[Code],"Bid") |
| Ask | =RTD("gartle.rtd",,"rtd-mssql","OptionsYahoo",[Code],"Ask") |
| Volume | =RTD("gartle.rtd",,"rtd-mssql","OptionsYahoo",[Code],"Volume") |
| OpenInt | =RTD("gartle.rtd",,"rtd-mssql","OptionsYahoo",[Code],"OpenInt") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mssql","OptionsYahoo",[Code],"LastUpdateTimeStamp") |
| RTD_LastMessage | =RTD("gartle.rtd",,"rtd-mssql","OptionsYahoo",[Code],"RTD_LastMessage") |
QuoteDayHistoryYahoo
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Symbol | |
| Date | |
| LastTradeTime | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryYahoo",[Symbol],[Date],"LastTradeTime") |
| Last | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryYahoo",[Symbol],[Date],"Last") |
| Change | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryYahoo",[Symbol],[Date],"Change") |
| PercentChange | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryYahoo",[Symbol],[Date],"PercentChange") |
| Open | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryYahoo",[Symbol],[Date],"Open") |
| High | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryYahoo",[Symbol],[Date],"High") |
| Low | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryYahoo",[Symbol],[Date],"Low") |
| Volume | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryYahoo",[Symbol],[Date],"Volume") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryYahoo",[Symbol],[Date],"LastUpdateTimeStamp") |
| RTD_LastMessage | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryYahoo",[Symbol],[Date],"RTD_LastMessage") |
QuotesYahoo
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Symbol | |
| LastTradeDate | =RTD("gartle.rtd",,"rtd-mssql","QuotesYahoo",[Symbol],"LastTradeDate") |
| LastTradeTime | =RTD("gartle.rtd",,"rtd-mssql","QuotesYahoo",[Symbol],"LastTradeTime") |
| Last | =RTD("gartle.rtd",,"rtd-mssql","QuotesYahoo",[Symbol],"Last") |
| Change | =RTD("gartle.rtd",,"rtd-mssql","QuotesYahoo",[Symbol],"Change") |
| PercentChange | =RTD("gartle.rtd",,"rtd-mssql","QuotesYahoo",[Symbol],"PercentChange") |
| Open | =RTD("gartle.rtd",,"rtd-mssql","QuotesYahoo",[Symbol],"Open") |
| High | =RTD("gartle.rtd",,"rtd-mssql","QuotesYahoo",[Symbol],"High") |
| Low | =RTD("gartle.rtd",,"rtd-mssql","QuotesYahoo",[Symbol],"Low") |
| Volume | =RTD("gartle.rtd",,"rtd-mssql","QuotesYahoo",[Symbol],"Volume") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mssql","QuotesYahoo",[Symbol],"LastUpdateTimeStamp") |
| RTD_LastMessage | =RTD("gartle.rtd",,"rtd-mssql","QuotesYahoo",[Symbol],"RTD_LastMessage") |
StocksYahoo
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Symbol | |
| CompanyName | =RTD("gartle.rtd",,"rtd-mssql","StocksYahoo",[Symbol],"CompanyName") |
| Sector | =RTD("gartle.rtd",,"rtd-mssql","StocksYahoo",[Symbol],"Sector") |
| Industry | =RTD("gartle.rtd",,"rtd-mssql","StocksYahoo",[Symbol],"Industry") |
| FullTimeEmployees | =RTD("gartle.rtd",,"rtd-mssql","StocksYahoo",[Symbol],"FullTimeEmployees") |
| TradeStart | =RTD("gartle.rtd",,"rtd-mssql","StocksYahoo",[Symbol],"TradeStart") |
| TradeEnd | =RTD("gartle.rtd",,"rtd-mssql","StocksYahoo",[Symbol],"TradeEnd") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mssql","StocksYahoo",[Symbol],"LastUpdateTimeStamp") |
CurrenciesDayHistoryYahoo
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Symbol | |
| Date | |
| LastTradeTime | =RTD("gartle.rtd",,"rtd-mssql","CurrenciesDayHistoryYahoo",[Symbol],[Date],"LastTradeTime") |
| Last | =RTD("gartle.rtd",,"rtd-mssql","CurrenciesDayHistoryYahoo",[Symbol],[Date],"Last") |
| Change | =RTD("gartle.rtd",,"rtd-mssql","CurrenciesDayHistoryYahoo",[Symbol],[Date],"Change") |
| PercentChange | =RTD("gartle.rtd",,"rtd-mssql","CurrenciesDayHistoryYahoo",[Symbol],[Date],"PercentChange") |
| Open | =RTD("gartle.rtd",,"rtd-mssql","CurrenciesDayHistoryYahoo",[Symbol],[Date],"Open") |
| High | =RTD("gartle.rtd",,"rtd-mssql","CurrenciesDayHistoryYahoo",[Symbol],[Date],"High") |
| Low | =RTD("gartle.rtd",,"rtd-mssql","CurrenciesDayHistoryYahoo",[Symbol],[Date],"Low") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mssql","CurrenciesDayHistoryYahoo",[Symbol],[Date],"LastUpdateTimeStamp") |
| RTD_LastMessage | =RTD("gartle.rtd",,"rtd-mssql","CurrenciesDayHistoryYahoo",[Symbol],[Date],"RTD_LastMessage") |
CurrenciesYahoo
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Symbol | |
| LastTradeDate | =RTD("gartle.rtd",,"rtd-mssql","CurrenciesYahoo",[Symbol],"LastTradeDate") |
| LastTradeTime | =RTD("gartle.rtd",,"rtd-mssql","CurrenciesYahoo",[Symbol],"LastTradeTime") |
| Last | =RTD("gartle.rtd",,"rtd-mssql","CurrenciesYahoo",[Symbol],"Last") |
| Change | =RTD("gartle.rtd",,"rtd-mssql","CurrenciesYahoo",[Symbol],"Change") |
| PercentChange | =RTD("gartle.rtd",,"rtd-mssql","CurrenciesYahoo",[Symbol],"PercentChange") |
| Open | =RTD("gartle.rtd",,"rtd-mssql","CurrenciesYahoo",[Symbol],"Open") |
| High | =RTD("gartle.rtd",,"rtd-mssql","CurrenciesYahoo",[Symbol],"High") |
| Low | =RTD("gartle.rtd",,"rtd-mssql","CurrenciesYahoo",[Symbol],"Low") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mssql","CurrenciesYahoo",[Symbol],"LastUpdateTimeStamp") |
| RTD_LastMessage | =RTD("gartle.rtd",,"rtd-mssql","CurrenciesYahoo",[Symbol],"RTD_LastMessage") |
Real-Time Views for MySQL, MariaDB, Oracle Database, IBM DB2, NuoDB, and PostgreSQL
fundamentals_day_history_yahoo
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Symbol | |
| Date | |
| LastTradeTime | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"LastTradeTime") |
| Last | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"Last") |
| Change | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"Change") |
| PercentChange | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"PercentChange") |
| Open | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"Open") |
| High | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"High") |
| Low | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"Low") |
| Volume | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"Volume") |
| DaysRange | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"DaysRange") |
| PrevClose | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"PrevClose") |
| ShortRatio | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"ShortRatio") |
| YearHigh | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"YearHigh") |
| YearLow | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"YearLow") |
| YearRange | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"YearRange") |
| ChangeFromYearHigh | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"ChangeFromYearHigh") |
| ChangeFromYearLow | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"ChangeFromYearLow") |
| PercentChangeFromYearHigh | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"PercentChangeFromYearHigh") |
| PercentChangeFromYearLow | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"PercentChangeFromYearLow") |
| MA50 | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"MA50") |
| MA200 | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"MA200") |
| ChangeFromMA50 | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"ChangeFromMA50") |
| ChangeFromMA200 | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"ChangeFromMA200") |
| PercentChangeFromMA50 | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"PercentChangeFromMA50") |
| PercentChangeFromMA200 | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"PercentChangeFromMA200") |
| AverageDailyVolume | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"AverageDailyVolume") |
| OneYearTargetPrice | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"OneYearTargetPrice") |
| PE | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"PE") |
| PEG | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"PEG") |
| EPSEstCurrentYear | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"EPSEstCurrentYear") |
| EPSEstNextQuarter | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"EPSEstNextQuarter") |
| EPSEstNextYear | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"EPSEstNextYear") |
| EarningsShare | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"EarningsShare") |
| MarketCap | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"MarketCap") |
| DividendYield | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"DividendYield") |
| DividendShare | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"DividendShare") |
| ExDividendDate | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"ExDividendDate") |
| DividendPayDate | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"DividendPayDate") |
| BookValue | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"BookValue") |
| PriceBook | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"PriceBook") |
| PriceSales | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"PriceSales") |
| PriceEPSEstCurrentYear | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"PriceEPSEstCurrentYear") |
| PriceEPSEstNextYear | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"PriceEPSEstNextYear") |
| EBITDA | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"EBITDA") |
| CompanyName | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"CompanyName") |
| StockExchange | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"StockExchange") |
| Commission | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"Commission") |
| Notes | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"Notes") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"LastUpdateTimeStamp") |
| RTD_LastMessage | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_day_history_yahoo",[Symbol],[Date],"RTD_LastMessage") |
fundamentals_yahoo
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Symbol | |
| LastTradeDate | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"LastTradeDate") |
| LastTradeTime | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"LastTradeTime") |
| Last | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"Last") |
| Change | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"Change") |
| PercentChange | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"PercentChange") |
| Open | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"Open") |
| High | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"High") |
| Low | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"Low") |
| Volume | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"Volume") |
| DaysRange | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"DaysRange") |
| PrevClose | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"PrevClose") |
| ShortRatio | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"ShortRatio") |
| YearHigh | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"YearHigh") |
| YearLow | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"YearLow") |
| YearRange | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"YearRange") |
| ChangeFromYearHigh | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"ChangeFromYearHigh") |
| ChangeFromYearLow | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"ChangeFromYearLow") |
| PercentChangeFromYearHigh | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"PercentChangeFromYearHigh") |
| PercentChangeFromYearLow | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"PercentChangeFromYearLow") |
| MA50 | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"MA50") |
| MA200 | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"MA200") |
| ChangeFromMA50 | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"ChangeFromMA50") |
| ChangeFromMA200 | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"ChangeFromMA200") |
| PercentChangeFromMA50 | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"PercentChangeFromMA50") |
| PercentChangeFromMA200 | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"PercentChangeFromMA200") |
| AverageDailyVolume | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"AverageDailyVolume") |
| OneYearTargetPrice | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"OneYearTargetPrice") |
| PE | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"PE") |
| PEG | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"PEG") |
| EPSEstCurrentYear | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"EPSEstCurrentYear") |
| EPSEstNextQuarter | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"EPSEstNextQuarter") |
| EPSEstNextYear | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"EPSEstNextYear") |
| EarningsShare | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"EarningsShare") |
| MarketCap | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"MarketCap") |
| DividendYield | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"DividendYield") |
| DividendShare | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"DividendShare") |
| ExDividendDate | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"ExDividendDate") |
| DividendPayDate | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"DividendPayDate") |
| BookValue | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"BookValue") |
| PriceBook | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"PriceBook") |
| PriceSales | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"PriceSales") |
| PriceEPSEstCurrentYear | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"PriceEPSEstCurrentYear") |
| PriceEPSEstNextYear | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"PriceEPSEstNextYear") |
| EBITDA | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"EBITDA") |
| CompanyName | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"CompanyName") |
| StockExchange | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"StockExchange") |
| Commission | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"Commission") |
| Notes | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"Notes") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"LastUpdateTimeStamp") |
| RTD_LastMessage | =RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo",[Symbol],"RTD_LastMessage") |
option_day_history_yahoo
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Code | |
| Date | |
| Time | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_yahoo",[Code],[Date],"Time") |
| OptionCode | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_yahoo",[Code],[Date],"OptionCode") |
| Symbol | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_yahoo",[Code],[Date],"Symbol") |
| OptionSymbol | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_yahoo",[Code],[Date],"OptionSymbol") |
| ExpDate | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_yahoo",[Code],[Date],"ExpDate") |
| Strike | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_yahoo",[Code],[Date],"Strike") |
| Type | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_yahoo",[Code],[Date],"Type") |
| Last | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_yahoo",[Code],[Date],"Last") |
| Change | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_yahoo",[Code],[Date],"Change") |
| PercentChange | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_yahoo",[Code],[Date],"PercentChange") |
| Mark | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_yahoo",[Code],[Date],"Mark") |
| Bid | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_yahoo",[Code],[Date],"Bid") |
| Ask | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_yahoo",[Code],[Date],"Ask") |
| Volume | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_yahoo",[Code],[Date],"Volume") |
| OpenInt | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_yahoo",[Code],[Date],"OpenInt") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_yahoo",[Code],[Date],"LastUpdateTimeStamp") |
| RTD_LastMessage | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_yahoo",[Code],[Date],"RTD_LastMessage") |
options_yahoo
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Code | |
| Date | =RTD("gartle.rtd",,"rtd-mysql","options_yahoo",[Code],"Date") |
| Time | =RTD("gartle.rtd",,"rtd-mysql","options_yahoo",[Code],"Time") |
| OptionCode | =RTD("gartle.rtd",,"rtd-mysql","options_yahoo",[Code],"OptionCode") |
| Symbol | =RTD("gartle.rtd",,"rtd-mysql","options_yahoo",[Code],"Symbol") |
| OptionSymbol | =RTD("gartle.rtd",,"rtd-mysql","options_yahoo",[Code],"OptionSymbol") |
| ExpDate | =RTD("gartle.rtd",,"rtd-mysql","options_yahoo",[Code],"ExpDate") |
| Strike | =RTD("gartle.rtd",,"rtd-mysql","options_yahoo",[Code],"Strike") |
| Type | =RTD("gartle.rtd",,"rtd-mysql","options_yahoo",[Code],"Type") |
| Last | =RTD("gartle.rtd",,"rtd-mysql","options_yahoo",[Code],"Last") |
| Change | =RTD("gartle.rtd",,"rtd-mysql","options_yahoo",[Code],"Change") |
| PercentChange | =RTD("gartle.rtd",,"rtd-mysql","options_yahoo",[Code],"PercentChange") |
| Mark | =RTD("gartle.rtd",,"rtd-mysql","options_yahoo",[Code],"Mark") |
| Bid | =RTD("gartle.rtd",,"rtd-mysql","options_yahoo",[Code],"Bid") |
| Ask | =RTD("gartle.rtd",,"rtd-mysql","options_yahoo",[Code],"Ask") |
| Volume | =RTD("gartle.rtd",,"rtd-mysql","options_yahoo",[Code],"Volume") |
| OpenInt | =RTD("gartle.rtd",,"rtd-mysql","options_yahoo",[Code],"OpenInt") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mysql","options_yahoo",[Code],"LastUpdateTimeStamp") |
| RTD_LastMessage | =RTD("gartle.rtd",,"rtd-mysql","options_yahoo",[Code],"RTD_LastMessage") |
quote_day_history_yahoo
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Symbol | |
| Date | |
| LastTradeTime | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_yahoo",[Symbol],[Date],"LastTradeTime") |
| Last | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_yahoo",[Symbol],[Date],"Last") |
| Change | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_yahoo",[Symbol],[Date],"Change") |
| PercentChange | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_yahoo",[Symbol],[Date],"PercentChange") |
| Open | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_yahoo",[Symbol],[Date],"Open") |
| High | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_yahoo",[Symbol],[Date],"High") |
| Low | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_yahoo",[Symbol],[Date],"Low") |
| Volume | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_yahoo",[Symbol],[Date],"Volume") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_yahoo",[Symbol],[Date],"LastUpdateTimeStamp") |
| RTD_LastMessage | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_yahoo",[Symbol],[Date],"RTD_LastMessage") |
quotes_yahoo
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Symbol | |
| LastTradeDate | =RTD("gartle.rtd",,"rtd-mysql","quotes_yahoo",[Symbol],"LastTradeDate") |
| LastTradeTime | =RTD("gartle.rtd",,"rtd-mysql","quotes_yahoo",[Symbol],"LastTradeTime") |
| Last | =RTD("gartle.rtd",,"rtd-mysql","quotes_yahoo",[Symbol],"Last") |
| Change | =RTD("gartle.rtd",,"rtd-mysql","quotes_yahoo",[Symbol],"Change") |
| PercentChange | =RTD("gartle.rtd",,"rtd-mysql","quotes_yahoo",[Symbol],"PercentChange") |
| Open | =RTD("gartle.rtd",,"rtd-mysql","quotes_yahoo",[Symbol],"Open") |
| High | =RTD("gartle.rtd",,"rtd-mysql","quotes_yahoo",[Symbol],"High") |
| Low | =RTD("gartle.rtd",,"rtd-mysql","quotes_yahoo",[Symbol],"Low") |
| Volume | =RTD("gartle.rtd",,"rtd-mysql","quotes_yahoo",[Symbol],"Volume") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mysql","quotes_yahoo",[Symbol],"LastUpdateTimeStamp") |
| RTD_LastMessage | =RTD("gartle.rtd",,"rtd-mysql","quotes_yahoo",[Symbol],"RTD_LastMessage") |
stocks_yahoo
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Symbol | |
| CompanyName | =RTD("gartle.rtd",,"rtd-mysql","stocks_yahoo",[Symbol],"CompanyName") |
| Sector | =RTD("gartle.rtd",,"rtd-mysql","stocks_yahoo",[Symbol],"Sector") |
| Industry | =RTD("gartle.rtd",,"rtd-mysql","stocks_yahoo",[Symbol],"Industry") |
| FullTimeEmployees | =RTD("gartle.rtd",,"rtd-mysql","stocks_yahoo",[Symbol],"FullTimeEmployees") |
| TradeStart | =RTD("gartle.rtd",,"rtd-mysql","stocks_yahoo",[Symbol],"TradeStart") |
| TradeEnd | =RTD("gartle.rtd",,"rtd-mysql","stocks_yahoo",[Symbol],"TradeEnd") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mysql","stocks_yahoo",[Symbol],"LastUpdateTimeStamp") |
currencies_day_history_yahoo
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Symbol | |
| Date | |
| LastTradeTime | =RTD("gartle.rtd",,"rtd-mysql","currencies_day_history_yahoo",[Symbol],[Date],"LastTradeTime") |
| Last | =RTD("gartle.rtd",,"rtd-mysql","currencies_day_history_yahoo",[Symbol],[Date],"Last") |
| Change | =RTD("gartle.rtd",,"rtd-mysql","currencies_day_history_yahoo",[Symbol],[Date],"Change") |
| PercentChange | =RTD("gartle.rtd",,"rtd-mysql","currencies_day_history_yahoo",[Symbol],[Date],"PercentChange") |
| Open | =RTD("gartle.rtd",,"rtd-mysql","currencies_day_history_yahoo",[Symbol],[Date],"Open") |
| High | =RTD("gartle.rtd",,"rtd-mysql","currencies_day_history_yahoo",[Symbol],[Date],"High") |
| Low | =RTD("gartle.rtd",,"rtd-mysql","currencies_day_history_yahoo",[Symbol],[Date],"Low") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mysql","currencies_day_history_yahoo",[Symbol],[Date],"LastUpdateTimeStamp") |
| RTD_LastMessage | =RTD("gartle.rtd",,"rtd-mysql","currencies_day_history_yahoo",[Symbol],[Date],"RTD_LastMessage") |
currencies_yahoo
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Symbol | |
| LastTradeDate | =RTD("gartle.rtd",,"rtd-mysql","currencies_yahoo",[Symbol],"LastTradeDate") |
| LastTradeTime | =RTD("gartle.rtd",,"rtd-mysql","currencies_yahoo",[Symbol],"LastTradeTime") |
| Last | =RTD("gartle.rtd",,"rtd-mysql","currencies_yahoo",[Symbol],"Last") |
| Change | =RTD("gartle.rtd",,"rtd-mysql","currencies_yahoo",[Symbol],"Change") |
| PercentChange | =RTD("gartle.rtd",,"rtd-mysql","currencies_yahoo",[Symbol],"PercentChange") |
| Open | =RTD("gartle.rtd",,"rtd-mysql","currencies_yahoo",[Symbol],"Open") |
| High | =RTD("gartle.rtd",,"rtd-mysql","currencies_yahoo",[Symbol],"High") |
| Low | =RTD("gartle.rtd",,"rtd-mysql","currencies_yahoo",[Symbol],"Low") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mysql","currencies_yahoo",[Symbol],"LastUpdateTimeStamp") |
| RTD_LastMessage | =RTD("gartle.rtd",,"rtd-mysql","currencies_yahoo",[Symbol],"RTD_LastMessage") |