RealTimeToExcel Views for eSignal FutureSource

RealTimeToExcel Views for eSignal FutureSource

Preconfigured Views

SQL Server and SQL Server CompactMySQL, MariaDB, and PostgreSQLOracle Database, IBM DB2, and NuoDB
QuoteDayHistoryESquote_day_history_esQUOTE_DAY_HISTORY_ES
QuotesESquotes_esQUOTES_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_NAMEEXCEL 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_NAMEEXCEL 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_NAMEEXCEL 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_NAMEEXCEL 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")
This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.