RealTimeToExcel Views for Thinkorswim thinkDesktop

RealTimeToExcel Views for Thinkorswim thinkDesktop

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

OptionDayHistoryTOS

COLUMN_NAMEEXCEL FORMULA
Code
Date
Time=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"Time")
Description=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"Description")
Last=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"Last")
Change=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"Change")
PercentChange=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"PercentChange")
LastSize=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"LastSize")
LastX=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"LastX")
Mark=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"Mark")
MarkChange=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"MarkChange")
MarkPercentChange=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"MarkPercentChange")
Bid=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"Bid")
Ask=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"Ask")
BidSize=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"BidSize")
AskSize=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"AskSize")
BidAskSize=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"BidAskSize")
BidX=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"BidX")
AskX=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"AskX")
Open=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"Open")
High=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"High")
Low=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"Low")
Close=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"Close")
Volume=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"Volume")
OpenInt=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"OpenInt")
ImpliedVol=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"ImpliedVol")
Delta=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"Delta")
Gamma=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"Gamma")
Theta=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"Theta")
Vega=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"Vega")
Rho=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"Rho")
Extrinsic=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"Extrinsic")
Intrinsic=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"Intrinsic")
ProbabilityITM=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"ProbabilityITM")
ProbabilityOTM=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"ProbabilityOTM")
ProbabilityTouch=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"ProbabilityTouch")
CoveredReturn=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"CoveredReturn")
MaxCoveredReturn=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"MaxCoveredReturn")
LastUpdateTimeStamp=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"LastUpdateTimeStamp")
RTD_LastMessage=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTOS",[Code],[Date],"RTD_LastMessage")

OptionDayHistoryTWS

COLUMN_NAMEEXCEL FORMULA
Code
Date
Time=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"Time")
Last=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"Last")
LastSize=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"LastSize")
Bid=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"Bid")
Ask=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"Ask")
BidSize=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"BidSize")
AskSize=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"AskSize")
High=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"High")
Low=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"Low")
Close=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"Close")
Volume=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"Volume")
UnderlyingPrice=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"UnderlyingPrice")
ModelPrice=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"ModelPrice")
ImpliedVol=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"ImpliedVol")
BidImpliedVol=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"BidImpliedVol")
AskImpliedVol=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"AskImpliedVol")
LastImpliedVol=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"LastImpliedVol")
BidDelta=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"BidDelta")
AskDelta=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"AskDelta")
LastDelta=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"LastDelta")
Delta=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"Delta")
Gamma=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"Gamma")
Theta=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"Theta")
Vega=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"Vega")
pvDividend=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"pvDividend")
LastUpdateTimeStamp=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"LastUpdateTimeStamp")
RTD_LastMessage=RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryTWS",[Code],[Date],"RTD_LastMessage")

OptionsTOS

COLUMN_NAMEEXCEL FORMULA
Code
Date=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"Date")
Time=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"Time")
Description=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"Description")
Last=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"Last")
Change=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"Change")
PercentChange=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"PercentChange")
LastSize=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"LastSize")
LastX=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"LastX")
Mark=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"Mark")
MarkChange=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"MarkChange")
MarkPercentChange=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"MarkPercentChange")
Bid=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"Bid")
Ask=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"Ask")
BidSize=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"BidSize")
AskSize=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"AskSize")
BidAskSize=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"BidAskSize")
BidX=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"BidX")
AskX=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"AskX")
Open=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"Open")
High=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"High")
Low=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"Low")
Close=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"Close")
Volume=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"Volume")
OpenInt=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"OpenInt")
ImpliedVol=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"ImpliedVol")
Delta=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"Delta")
Gamma=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"Gamma")
Theta=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"Theta")
Vega=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"Vega")
Rho=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"Rho")
Extrinsic=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"Extrinsic")
Intrinsic=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"Intrinsic")
ProbabilityITM=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"ProbabilityITM")
ProbabilityOTM=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"ProbabilityOTM")
ProbabilityTouch=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"ProbabilityTouch")
CoveredReturn=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"CoveredReturn")
MaxCoveredReturn=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"MaxCoveredReturn")
LastUpdateTimeStamp=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"LastUpdateTimeStamp")
RTD_LastMessage=RTD("gartle.rtd",,"rtd-mssql","OptionsTOS",[Code],"RTD_LastMessage")

QuoteDayHistoryTOS

COLUMN_NAMEEXCEL FORMULA
Symbol
Date
Time=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"Time")
Description=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"Description")
Last=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"Last")
Change=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"Change")
PercentChange=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"PercentChange")
LastSize=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"LastSize")
LastX=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"LastX")
Mark=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"Mark")
MarkChange=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"MarkChange")
MarkPercentChange=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"MarkPercentChange")
Bid=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"Bid")
Ask=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"Ask")
BidSize=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"BidSize")
AskSize=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"AskSize")
BidAskSize=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"BidAskSize")
BidX=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"BidX")
AskX=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"AskX")
StrengthMeter=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"StrengthMeter")
Open=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"Open")
High=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"High")
Low=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"Low")
Close=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"Close")
Volume=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"Volume")
OpenInt=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"OpenInt")
ImpliedVol=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"ImpliedVol")
VolIndex=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"VolIndex")
FrontVol=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"FrontVol")
BackVol=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"BackVol")
WeightedBackVol=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"WeightedBackVol")
VolDiff=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"VolDiff")
PutCallRatio=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"PutCallRatio")
CallVolumeIndex=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"CallVolumeIndex")
PutVolumeIndex=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"PutVolumeIndex")
OptionVolumeIndex=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"OptionVolumeIndex")
FrontExpectedMove=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"FrontExpectedMove")
BackExpectedMove=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"BackExpectedMove")
ExpectedMoveDiff=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"ExpectedMoveDiff")
Beta=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"Beta")
High52=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"High52")
Low52=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"Low52")
PE=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"PE")
EPS=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"EPS")
MarketCap=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"MarketCap")
Shares=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"Shares")
DividendYield=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"DividendYield")
DividendShare=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"DividendShare")
LastUpdateTimeStamp=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"LastUpdateTimeStamp")
RTD_LastMessage=RTD("gartle.rtd",,"rtd-mssql","QuoteDayHistoryTOS",[Symbol],[Date],"RTD_LastMessage")

QuotesTOS

COLUMN_NAMEEXCEL FORMULA
Symbol
Date=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"Date")
Time=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"Time")
Description=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"Description")
Last=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"Last")
Change=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"Change")
PercentChange=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"PercentChange")
LastSize=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"LastSize")
LastX=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"LastX")
Mark=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"Mark")
MarkChange=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"MarkChange")
MarkPercentChange=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"MarkPercentChange")
Bid=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"Bid")
Ask=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"Ask")
BidSize=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"BidSize")
AskSize=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"AskSize")
BidAskSize=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"BidAskSize")
BidX=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"BidX")
AskX=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"AskX")
StrengthMeter=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"StrengthMeter")
Open=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"Open")
High=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"High")
Low=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"Low")
Close=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"Close")
Volume=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"Volume")
OpenInt=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"OpenInt")
ImpliedVol=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"ImpliedVol")
VolIndex=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"VolIndex")
FrontVol=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"FrontVol")
BackVol=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"BackVol")
WeightedBackVol=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"WeightedBackVol")
VolDiff=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"VolDiff")
PutCallRatio=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"PutCallRatio")
CallVolumeIndex=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"CallVolumeIndex")
PutVolumeIndex=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"PutVolumeIndex")
OptionVolumeIndex=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"OptionVolumeIndex")
FrontExpectedMove=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"FrontExpectedMove")
BackExpectedMove=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"BackExpectedMove")
ExpectedMoveDiff=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"ExpectedMoveDiff")
Beta=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"Beta")
High52=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"High52")
Low52=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"Low52")
PE=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"PE")
EPS=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"EPS")
MarketCap=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"MarketCap")
Shares=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"Shares")
DividendYield=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"DividendYield")
DividendShare=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"DividendShare")
LastUpdateTimeStamp=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"LastUpdateTimeStamp")
RTD_LastMessage=RTD("gartle.rtd",,"rtd-mssql","QuotesTOS",[Symbol],"RTD_LastMessage")

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

option_day_history_tos

COLUMN_NAMEEXCEL FORMULA
Code
Date
Time=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"Time")
Description=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"Description")
Last=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"Last")
Change=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"Change")
PercentChange=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"PercentChange")
LastSize=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"LastSize")
LastX=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"LastX")
Mark=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"Mark")
MarkChange=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"MarkChange")
MarkPercentChange=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"MarkPercentChange")
Bid=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"Bid")
Ask=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"Ask")
BidSize=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"BidSize")
AskSize=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"AskSize")
BidAskSize=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"BidAskSize")
BidX=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"BidX")
AskX=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"AskX")
Open=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"Open")
High=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"High")
Low=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"Low")
Close=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"Close")
Volume=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"Volume")
OpenInt=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"OpenInt")
ImpliedVol=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"ImpliedVol")
Delta=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"Delta")
Gamma=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"Gamma")
Theta=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"Theta")
Vega=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"Vega")
Rho=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"Rho")
Extrinsic=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"Extrinsic")
Intrinsic=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"Intrinsic")
ProbabilityITM=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"ProbabilityITM")
ProbabilityOTM=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"ProbabilityOTM")
ProbabilityTouch=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"ProbabilityTouch")
CoveredReturn=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"CoveredReturn")
MaxCoveredReturn=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"MaxCoveredReturn")
LastUpdateTimeStamp=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"LastUpdateTimeStamp")
RTD_LastMessage=RTD("gartle.rtd",,"rtd-mysql","option_day_history_tos",[Code],[Date],"RTD_LastMessage")

options_tos

COLUMN_NAMEEXCEL FORMULA
Code
Date=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"Date")
Time=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"Time")
Description=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"Description")
Last=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"Last")
Change=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"Change")
PercentChange=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"PercentChange")
LastSize=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"LastSize")
LastX=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"LastX")
Mark=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"Mark")
MarkChange=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"MarkChange")
MarkPercentChange=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"MarkPercentChange")
Bid=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"Bid")
Ask=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"Ask")
BidSize=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"BidSize")
AskSize=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"AskSize")
BidAskSize=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"BidAskSize")
BidX=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"BidX")
AskX=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"AskX")
Open=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"Open")
High=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"High")
Low=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"Low")
Close=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"Close")
Volume=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"Volume")
OpenInt=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"OpenInt")
ImpliedVol=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"ImpliedVol")
Delta=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"Delta")
Gamma=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"Gamma")
Theta=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"Theta")
Vega=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"Vega")
Rho=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"Rho")
Extrinsic=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"Extrinsic")
Intrinsic=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"Intrinsic")
ProbabilityITM=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"ProbabilityITM")
ProbabilityOTM=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"ProbabilityOTM")
ProbabilityTouch=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"ProbabilityTouch")
CoveredReturn=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"CoveredReturn")
MaxCoveredReturn=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"MaxCoveredReturn")
LastUpdateTimeStamp=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"LastUpdateTimeStamp")
RTD_LastMessage=RTD("gartle.rtd",,"rtd-mysql","options_tos",[Code],"RTD_LastMessage")

quote_day_history_tos

COLUMN_NAMEEXCEL FORMULA
Symbol
Date
Time=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"Time")
Description=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"Description")
Last=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"Last")
Change=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"Change")
PercentChange=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"PercentChange")
LastSize=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"LastSize")
LastX=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"LastX")
Mark=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"Mark")
MarkChange=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"MarkChange")
MarkPercentChange=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"MarkPercentChange")
Bid=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"Bid")
Ask=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"Ask")
BidSize=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"BidSize")
AskSize=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"AskSize")
BidAskSize=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"BidAskSize")
BidX=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"BidX")
AskX=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"AskX")
StrengthMeter=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"StrengthMeter")
Open=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"Open")
High=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"High")
Low=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"Low")
Close=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"Close")
Volume=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"Volume")
OpenInt=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"OpenInt")
ImpliedVol=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"ImpliedVol")
VolIndex=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"VolIndex")
FrontVol=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"FrontVol")
BackVol=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"BackVol")
WeightedBackVol=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"WeightedBackVol")
VolDiff=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"VolDiff")
PutCallRatio=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"PutCallRatio")
CallVolumeIndex=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"CallVolumeIndex")
PutVolumeIndex=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"PutVolumeIndex")
OptionVolumeIndex=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"OptionVolumeIndex")
FrontExpectedMove=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"FrontExpectedMove")
BackExpectedMove=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"BackExpectedMove")
ExpectedMoveDiff=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"ExpectedMoveDiff")
Beta=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"Beta")
High52=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"High52")
Low52=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"Low52")
PE=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"PE")
EPS=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"EPS")
MarketCap=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"MarketCap")
Shares=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"Shares")
DividendYield=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"DividendYield")
DividendShare=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"DividendShare")
LastUpdateTimeStamp=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"LastUpdateTimeStamp")
RTD_LastMessage=RTD("gartle.rtd",,"rtd-mysql","quote_day_history_tos",[Symbol],[Date],"RTD_LastMessage")

quotes_tos

COLUMN_NAMEEXCEL FORMULA
Symbol
Date=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"Date")
Time=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"Time")
Description=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"Description")
Last=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"Last")
Change=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"Change")
PercentChange=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"PercentChange")
LastSize=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"LastSize")
LastX=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"LastX")
Mark=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"Mark")
MarkChange=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"MarkChange")
MarkPercentChange=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"MarkPercentChange")
Bid=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"Bid")
Ask=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"Ask")
BidSize=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"BidSize")
AskSize=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"AskSize")
BidAskSize=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"BidAskSize")
BidX=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"BidX")
AskX=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"AskX")
StrengthMeter=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"StrengthMeter")
Open=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"Open")
High=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"High")
Low=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"Low")
Close=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"Close")
Volume=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"Volume")
OpenInt=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"OpenInt")
ImpliedVol=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"ImpliedVol")
VolIndex=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"VolIndex")
FrontVol=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"FrontVol")
BackVol=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"BackVol")
WeightedBackVol=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"WeightedBackVol")
VolDiff=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"VolDiff")
PutCallRatio=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"PutCallRatio")
CallVolumeIndex=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"CallVolumeIndex")
PutVolumeIndex=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"PutVolumeIndex")
OptionVolumeIndex=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"OptionVolumeIndex")
FrontExpectedMove=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"FrontExpectedMove")
BackExpectedMove=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"BackExpectedMove")
ExpectedMoveDiff=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"ExpectedMoveDiff")
Beta=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"Beta")
High52=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"High52")
Low52=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"Low52")
PE=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"PE")
EPS=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"EPS")
MarketCap=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"MarketCap")
Shares=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"Shares")
DividendYield=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"DividendYield")
DividendShare=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"DividendShare")
LastUpdateTimeStamp=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[Symbol],"LastUpdateTimeStamp")
RTD_LastMessage=RTD("gartle.rtd",,"rtd-mysql","quotes_tos",[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.