RealTimeToExcel Views for eSignal FutureSource
Preconfigured Views
| SQL Server and SQL Server Compact | MySQL, MariaDB, and PostgreSQL | Oracle Database, IBM DB2, and NuoDB |
|---|---|---|
| QuoteDayHistoryES | quote_day_history_es | QUOTE_DAY_HISTORY_ES |
| QuotesES | quotes_es | QUOTES_ES |
* Click on the view name to go to the view description.
Real-Time Views for Microsoft SQL Server and Microsoft SQL Server Compact
QuoteDayHistoryES
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Symbol | |
| Date | |
| Time | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryES",[Symbol],[Date],"Time") |
| Last | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryES",[Symbol],[Date],"Last") |
| Change | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryES",[Symbol],[Date],"Change") |
| PercentChange | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryES",[Symbol],[Date],"PercentChange") |
| Bid | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryES",[Symbol],[Date],"Bid") |
| Ask | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryES",[Symbol],[Date],"Ask") |
| BidSize | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryES",[Symbol],[Date],"BidSize") |
| AskSize | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryES",[Symbol],[Date],"AskSize") |
| Open | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryES",[Symbol],[Date],"Open") |
| High | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryES",[Symbol],[Date],"High") |
| Low | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryES",[Symbol],[Date],"Low") |
| Volume | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryES",[Symbol],[Date],"Volume") |
| OpenInt | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryES",[Symbol],[Date],"OpenInt") |
| TradePrice | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryES",[Symbol],[Date],"TradePrice") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryES",[Symbol],[Date],"LastUpdateTimeStamp") |
| RTD_LastMessage | =RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryES",[Symbol],[Date],"RTD_LastMessage") |
QuotesES
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Symbol | |
| Date | =RTD("gartle.rtd",,"rtd-mssql","QuotesES",[Symbol],"Date") |
| Time | =RTD("gartle.rtd",,"rtd-mssql","QuotesES",[Symbol],"Time") |
| Last | =RTD("gartle.rtd",,"rtd-mssql","QuotesES",[Symbol],"Last") |
| Change | =RTD("gartle.rtd",,"rtd-mssql","QuotesES",[Symbol],"Change") |
| PercentChange | =RTD("gartle.rtd",,"rtd-mssql","QuotesES",[Symbol],"PercentChange") |
| Bid | =RTD("gartle.rtd",,"rtd-mssql","QuotesES",[Symbol],"Bid") |
| Ask | =RTD("gartle.rtd",,"rtd-mssql","QuotesES",[Symbol],"Ask") |
| BidSize | =RTD("gartle.rtd",,"rtd-mssql","QuotesES",[Symbol],"BidSize") |
| AskSize | =RTD("gartle.rtd",,"rtd-mssql","QuotesES",[Symbol],"AskSize") |
| Open | =RTD("gartle.rtd",,"rtd-mssql","QuotesES",[Symbol],"Open") |
| High | =RTD("gartle.rtd",,"rtd-mssql","QuotesES",[Symbol],"High") |
| Low | =RTD("gartle.rtd",,"rtd-mssql","QuotesES",[Symbol],"Low") |
| Volume | =RTD("gartle.rtd",,"rtd-mssql","QuotesES",[Symbol],"Volume") |
| OpenInt | =RTD("gartle.rtd",,"rtd-mssql","QuotesES",[Symbol],"OpenInt") |
| TradePrice | =RTD("gartle.rtd",,"rtd-mssql","QuotesES",[Symbol],"TradePrice") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mssql","QuotesES",[Symbol],"LastUpdateTimeStamp") |
| RTD_LastMessage | =RTD("gartle.rtd",,"rtd-mssql","QuotesES",[Symbol],"RTD_LastMessage") |
Real-Time Views for MySQL, MariaDB, Oracle Database, IBM DB2, NuoDB, and PostgreSQL
quote_day_history_es
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Symbol | |
| Date | |
| Time | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_es",[Symbol],[Date],"Time") |
| Last | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_es",[Symbol],[Date],"Last") |
| Change | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_es",[Symbol],[Date],"Change") |
| PercentChange | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_es",[Symbol],[Date],"PercentChange") |
| Bid | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_es",[Symbol],[Date],"Bid") |
| Ask | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_es",[Symbol],[Date],"Ask") |
| BidSize | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_es",[Symbol],[Date],"BidSize") |
| AskSize | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_es",[Symbol],[Date],"AskSize") |
| Open | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_es",[Symbol],[Date],"Open") |
| High | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_es",[Symbol],[Date],"High") |
| Low | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_es",[Symbol],[Date],"Low") |
| Volume | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_es",[Symbol],[Date],"Volume") |
| OpenInt | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_es",[Symbol],[Date],"OpenInt") |
| TradePrice | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_es",[Symbol],[Date],"TradePrice") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_es",[Symbol],[Date],"LastUpdateTimeStamp") |
| RTD_LastMessage | =RTD("gartle.rtd",,"rtd-mysql","quote_day_history_es",[Symbol],[Date],"RTD_LastMessage") |
quotes_es
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Symbol | |
| Date | =RTD("gartle.rtd",,"rtd-mysql","quotes_es",[Symbol],"Date") |
| Time | =RTD("gartle.rtd",,"rtd-mysql","quotes_es",[Symbol],"Time") |
| Last | =RTD("gartle.rtd",,"rtd-mysql","quotes_es",[Symbol],"Last") |
| Change | =RTD("gartle.rtd",,"rtd-mysql","quotes_es",[Symbol],"Change") |
| PercentChange | =RTD("gartle.rtd",,"rtd-mysql","quotes_es",[Symbol],"PercentChange") |
| Bid | =RTD("gartle.rtd",,"rtd-mysql","quotes_es",[Symbol],"Bid") |
| Ask | =RTD("gartle.rtd",,"rtd-mysql","quotes_es",[Symbol],"Ask") |
| BidSize | =RTD("gartle.rtd",,"rtd-mysql","quotes_es",[Symbol],"BidSize") |
| AskSize | =RTD("gartle.rtd",,"rtd-mysql","quotes_es",[Symbol],"AskSize") |
| Open | =RTD("gartle.rtd",,"rtd-mysql","quotes_es",[Symbol],"Open") |
| High | =RTD("gartle.rtd",,"rtd-mysql","quotes_es",[Symbol],"High") |
| Low | =RTD("gartle.rtd",,"rtd-mysql","quotes_es",[Symbol],"Low") |
| Volume | =RTD("gartle.rtd",,"rtd-mysql","quotes_es",[Symbol],"Volume") |
| OpenInt | =RTD("gartle.rtd",,"rtd-mysql","quotes_es",[Symbol],"OpenInt") |
| TradePrice | =RTD("gartle.rtd",,"rtd-mysql","quotes_es",[Symbol],"TradePrice") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mysql","quotes_es",[Symbol],"LastUpdateTimeStamp") |
| RTD_LastMessage | =RTD("gartle.rtd",,"rtd-mysql","quotes_es",[Symbol],"RTD_LastMessage") |