RealTimeToExcel Views for VertexFX Trader
Preconfigured Views
| SQL Server and SQL Server Compact | MySQL, MariaDB, and PostgreSQL | Oracle Database, IBM DB2, and NuoDB |
|---|---|---|
| QuoteDayHistoryVFX | quote_day_history_vfx | QUOTE_DAY_HISTORY_VFX |
| QuotesVFX | quotes_vfx | QUOTES_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_NAME | EXCEL 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_NAME | EXCEL 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_NAME | EXCEL 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_NAME | EXCEL 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") |