RealTimeToExcel Views for VertexFX Trader

RealTimeToExcel Views for VertexFX Trader

Preconfigured Views

SQL Server and SQL Server CompactMySQL, MariaDB, and PostgreSQLOracle Database, IBM DB2, and NuoDB
QuoteDayHistoryVFXquote_day_history_vfxQUOTE_DAY_HISTORY_VFX
QuotesVFXquotes_vfxQUOTES_VFX

* Click on the view name to go to the view description.

Real-Time Views for Microsoft SQL Server and Microsoft SQL Server Compact

QuoteDayHistoryVFX

COLUMN_NAMEEXCEL FORMULA
Symbol
Date
Time=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryVFX",[Symbol],[Date],"Time")
Bid=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryVFX",[Symbol],[Date],"Bid")
Ask=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryVFX",[Symbol],[Date],"Ask")
Open=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryVFX",[Symbol],[Date],"Open")
High=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryVFX",[Symbol],[Date],"High")
Low=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryVFX",[Symbol],[Date],"Low")
Close=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryVFX",[Symbol],[Date],"Close")
Change=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryVFX",[Symbol],[Date],"Change")
PercentChange=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryVFX",[Symbol],[Date],"PercentChange")
LastUpdateTimeStamp=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryVFX",[Symbol],[Date],"LastUpdateTimeStamp")
RTD_LastMessage=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryVFX",[Symbol],[Date],"RTD_LastMessage")

QuotesVFX

COLUMN_NAMEEXCEL FORMULA
Symbol
Date=RTD("gartle.rtd",,"rtd-mssql","QuotesVFX",[Symbol],"Date")
Time=RTD("gartle.rtd",,"rtd-mssql","QuotesVFX",[Symbol],"Time")
Bid=RTD("gartle.rtd",,"rtd-mssql","QuotesVFX",[Symbol],"Bid")
Ask=RTD("gartle.rtd",,"rtd-mssql","QuotesVFX",[Symbol],"Ask")
Open=RTD("gartle.rtd",,"rtd-mssql","QuotesVFX",[Symbol],"Open")
High=RTD("gartle.rtd",,"rtd-mssql","QuotesVFX",[Symbol],"High")
Low=RTD("gartle.rtd",,"rtd-mssql","QuotesVFX",[Symbol],"Low")
Close=RTD("gartle.rtd",,"rtd-mssql","QuotesVFX",[Symbol],"Close")
Change=RTD("gartle.rtd",,"rtd-mssql","QuotesVFX",[Symbol],"Change")
PercentChange=RTD("gartle.rtd",,"rtd-mssql","QuotesVFX",[Symbol],"PercentChange")
LastUpdateTimeStamp=RTD("gartle.rtd",,"rtd-mssql","QuotesVFX",[Symbol],"LastUpdateTimeStamp")
RTD_LastMessage=RTD("gartle.rtd",,"rtd-mssql","QuotesVFX",[Symbol],"RTD_LastMessage")

Real-Time Views for MySQL, MariaDB, Oracle Database, IBM DB2, NuoDB, and PostgreSQL

quote_day_history_vfx

COLUMN_NAMEEXCEL FORMULA
Symbol
Date
Time=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_vfx",[Symbol],[Date],"Time")
Bid=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_vfx",[Symbol],[Date],"Bid")
Ask=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_vfx",[Symbol],[Date],"Ask")
Open=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_vfx",[Symbol],[Date],"Open")
High=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_vfx",[Symbol],[Date],"High")
Low=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_vfx",[Symbol],[Date],"Low")
Close=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_vfx",[Symbol],[Date],"Close")
Change=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_vfx",[Symbol],[Date],"Change")
PercentChange=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_vfx",[Symbol],[Date],"PercentChange")
LastUpdateTimeStamp=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_vfx",[Symbol],[Date],"LastUpdateTimeStamp")
RTD_LastMessage=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_vfx",[Symbol],[Date],"RTD_LastMessage")

quotes_vfx

COLUMN_NAMEEXCEL FORMULA
Symbol
Date=RTD("gartle.rtd",,"rtd-mysql","quotes_vfx",[Symbol],"Date")
Time=RTD("gartle.rtd",,"rtd-mysql","quotes_vfx",[Symbol],"Time")
Bid=RTD("gartle.rtd",,"rtd-mysql","quotes_vfx",[Symbol],"Bid")
Ask=RTD("gartle.rtd",,"rtd-mysql","quotes_vfx",[Symbol],"Ask")
Open=RTD("gartle.rtd",,"rtd-mysql","quotes_vfx",[Symbol],"Open")
High=RTD("gartle.rtd",,"rtd-mysql","quotes_vfx",[Symbol],"High")
Low=RTD("gartle.rtd",,"rtd-mysql","quotes_vfx",[Symbol],"Low")
Close=RTD("gartle.rtd",,"rtd-mysql","quotes_vfx",[Symbol],"Close")
Change=RTD("gartle.rtd",,"rtd-mysql","quotes_vfx",[Symbol],"Change")
PercentChange=RTD("gartle.rtd",,"rtd-mysql","quotes_vfx",[Symbol],"PercentChange")
LastUpdateTimeStamp=RTD("gartle.rtd",,"rtd-mysql","quotes_vfx",[Symbol],"LastUpdateTimeStamp")
RTD_LastMessage=RTD("gartle.rtd",,"rtd-mysql","quotes_vfx",[Symbol],"RTD_LastMessage")