If you are a DDE user you’ve noticed that it’s broken after this latest Think Desktop update. I just got word from the developers that they are looking to release improved capability this coming weekend. Now, please remember that development estimates are just that: estimates. This weekend is the goal. Don’t burn down your local village if it doesn’t happen on time. ?
- Excel Rtd Function
- Excel For Mac Rtd Functions Thinkorswim Pdf
- Thinkorswim Rtd Commands
- Thinkorswim Api Excel
- Linking Thinkorswim Chart To Excel
What they have should be better than the old DDE in terms of what we could do with it. It’s not two-way interaction with ToS, so done get that excited. It’s faster and more improved data handling that should be much easier to work with and more powerful for data handling inside of Excel. I’ll update as I know more.
Tags: DDE, excel
Overview
The RTD database contains preconfigured tables for getting real-time data from Thinkorswim thinkDesktop.
Excel Rtd Function
To set the throttle interval higher using the Excel object model: In Excel, go to the Visual Basic Editor by pressing ALT + F11. On the Immediate Window at the bottom of the display, type this code: Application.RTD.ThrottleInterval=0 (Note: If the Immediate Window is not open, press CTRL +. (COM) Automation server to retrieve data from thinkorswim in real time. To use RTD, bring up a watchlist on the Quotes sub-tab under the. Click on the Printer icon in the top right, and choose 'Export to Excel'. Because RTD is a function in Excel, you can take full advantage of the power. What rtd codes are you using to get Implied Volatility and Open Interest on the excel charts you are showing? In my experience, those fields come up blank when exporting to excel (rtd or direct export from Marketwatch). Same is true for Theoretical Option Price. What i have: =RTD('tos.rtd', 'ImpVolatility', '.AAPL180511C175').
Quote tables are designed for getting data for stocks, futures, and currency pairs. Use option tables for options.
Since RealTimeToDB 2.5, RTD functions are used by default.
To update existing DDE formulas, you may use patches from the database folders.
To update existing DDE formulas, you may use patches from the database folders.
You may disable unusable columns to reduce the server overhead.
Note that Thinkorswim thinkDesktop can crash if more than 200 000 topics are being requested.
The RTD server does not contain an actual data time field.
The DateTime, Date, and Time fields are updated using the PC time adjusted to the table time zone (Eastern Standard Time).
The DateTime, Date, and Time fields are updated using the PC time adjusted to the table time zone (Eastern Standard Time).
Real-Time Data Tables
Excel For Mac Rtd Functions Thinkorswim Pdf
Table Configurations
Microsoft SQL Server and Microsoft SQL Server Compact:
TABLE_SCHEMA | TABLE_NAME | LOAD_CODE | IS_HISTORY |
---|---|---|---|
rtd | QuoteListTOS | ||
rtd | QuotesTOS | SELECT Code AS Symbol FROM rtd.QuoteListTOS | |
rtd | QuoteDayHistoryTOS | SELECT Code AS Symbol FROM rtd.QuoteListTOS | |
rtd | QuoteTickHistoryTOS | SELECT Code AS Symbol FROM rtd.QuoteListTOS | 1 |
MySQL, MariaDB, and PostgreSQL:
Jan 29, 2020 NEW LUMBER TYCOON 2 SCRIPT HACK DOWNLOAD LINK 2020 WORKING working on Windows, Mac OS platforms and is supported by latest iOS an Android mobile platforms. Our tool has latest Anti Ban and Anti detect system such as PROXY and VPN support, you can use NEW LUMBER TYCOON 2 SCRIPT HACK DOWNLOAD LINK 2020 WORKING without any worries. Roblox: Lumber Tycoon Hack (the Cheat For Mac Roblox gaming and its features Roblox is a massive multiplayer game which allows the users to design games according to their needs. One can play different types of games created from different users and developers. Roblox lumber tycoon hack (the cheat for mac. If you extremely need robux, use Roblox Cheats together with Cheat Roblox Lumber Tycoon 2. INSANE! LUMBER TYCOON 2: UNLIMITED WOOD / ITEM DUPE!!! HACK / EXPLOIT (UNLIMITED MONEY) ROBLOX 2018 This Script Is Not Mine! But thanks to:. fortuneymmb For generating the possible.
TABLE_SCHEMA | TABLE_NAME | LOAD_CODE | IS_HISTORY |
---|---|---|---|
rtd | quote_list_tos | ||
rtd | quotes_tos | SELECT CODE AS SYMBOL FROM rtd.quote_list_tos | |
rtd | quote_day_history_tos | SELECT CODE AS SYMBOL FROM rtd.quote_list_tos | |
rtd | quote_tick_history_tos | SELECT CODE AS SYMBOL FROM rtd.quote_list_tos | 1 |
Self defence training manual. Oracle Database, IBM DB2, and NuoDB:
TABLE_SCHEMA | TABLE_NAME | LOAD_CODE | IS_HISTORY |
---|---|---|---|
RTD | QUOTE_LIST_TOS | ||
RTD | QUOTES_TOS | SELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_TOS | |
RTD | QUOTE_DAY_HISTORY_TOS | SELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_TOS | |
RTD | QUOTE_TICK_HISTORY_TOS | SELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_TOS | 1 |
* Click on the table name to go to the table description.
Task Table Examples
rtd.QuoteListTOS for Microsoft SQL Server and Microsoft SQL Server Compact:
Code |
---|
AAPL |
GOOG |
rtd.quote_list_tos for MySQL, MariaDB, Oracle Database, IBM DB2, NuoDB, and PostgreSQL:
CODE |
---|
AAPL |
GOOG |
Primary Key Columns
Thinkorswim Rtd Commands
Microsoft SQL Server and Microsoft SQL Server Compact:
TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | RTD_FORMULA | COMMENT |
---|---|---|---|---|
rtd | QuotesTOS | Symbol | PK | |
rtd | QuoteDayHistoryTOS | Symbol | PK | |
rtd | QuoteDayHistoryTOS | Date | =Date() | PK |
rtd | QuoteTickHistoryTOS | ID | PK, IDENTITY |
MySQL, MariaDB, and PostgreSQL:
TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | RTD_FORMULA | COMMENT |
---|---|---|---|---|
rtd | quotes_tos | SYMBOL | PK | |
rtd | quote_day_history_tos | SYMBOL | PK | |
rtd | quote_day_history_tos | DATE | =Date() | PK |
rtd | quote_tick_history_tos | ID | PK, IDENTITY |
Oracle Database, IBM DB2, and NuoDB:
Thinkorswim Api Excel
TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | RTD_FORMULA | COMMENT |
---|---|---|---|---|
RTD | QUOTES_TOS | SYMBOL | PK | |
RTD | QUOTE_DAY_HISTORY_TOS | SYMBOL | PK | |
RTD | QUOTE_DAY_HISTORY_TOS | DATE | =Date() | PK |
RTD | QUOTE_TICK_HISTORY_TOS | ID | PK, IDENTITY |
Real-Time Formulas for Microsoft SQL Server and Microsoft SQL Server Compact
rtd.QuotesTOS
The table contains the last data values of stocks, futures, and currency pairs from Thinkorswim thinkDesktop.
1-877-484-6246 (US Toll-Free) 1-512-346-3700 (US & International) [email protected]. Box 203156 Austin, TX 78720. Vidbox driver. HT Honestech Nw06 VIDBOX Convert Video to DVD Bvd5h201-2ag Cables. You can contact customer care and support via the phone number or email address honestech vidbox nw06 on our Contact page – http: Edited by leader2, 24 November — Start honestech vidbox nw06, with the Microsoft sequence of suggested repair steps.
COLUMN_NAME | RTD_FORMULA | COMMENT |
---|---|---|
Symbol | PK | |
DateTime | =DateTime() | |
Date | =Date() | |
Time | =Time() | |
Description | =RTD('tos.rtd','DESCRIPTION',[Symbol]) | |
Last | =RTD('tos.rtd','LAST',[Symbol]) | |
Change | =RTD('tos.rtd','NET_CHANGE',[Symbol]) | |
PercentChange | =RTD('tos.rtd','PERCENT_CHANGE',[Symbol]) | |
LastSize | =RTD('tos.rtd','LAST_SIZE',[Symbol]) | |
LastX | =RTD('tos.rtd','LX',[Symbol]) | |
Mark | =RTD('tos.rtd','MARK',[Symbol]) | |
MarkChange | =RTD('tos.rtd','MARK_CHANGE',[Symbol]) | |
MarkPercentChange | =RTD('tos.rtd','MARK_PERCENT_CHANGE',[Symbol]) | |
Bid | =RTD('tos.rtd','BID',[Symbol]) | |
Ask | =RTD('tos.rtd','ASK',[Symbol]) | |
BidSize | =RTD('tos.rtd','BID_SIZE',[Symbol]) | |
AskSize | =RTD('tos.rtd','ASK_SIZE',[Symbol]) | |
BidAskSize | =RTD('tos.rtd','BA_SIZE',[Symbol]) | |
BidX | =RTD('tos.rtd','BX',[Symbol]) | |
AskX | =RTD('tos.rtd','AX',[Symbol]) | |
StrengthMeter | =RTD('tos.rtd','STRENGTH_METER',[Symbol]) | |
Open | =RTD('tos.rtd','OPEN',[Symbol]) | |
High | =RTD('tos.rtd','HIGH',[Symbol]) | |
Low | =RTD('tos.rtd','LOW',[Symbol]) | |
Close | =RTD('tos.rtd','CLOSE',[Symbol]) | |
Volume | =RTD('tos.rtd','VOLUME',[Symbol]) | |
OpenInt | =RTD('tos.rtd','OPEN_INT',[Symbol]) | |
ImpliedVol | =RTD('tos.rtd','IMPL_VOL',[Symbol]) | |
VolIndex | =RTD('tos.rtd','VOL_INDEX',[Symbol]) | |
FrontVol | =RTD('tos.rtd','FRONT_VOL',[Symbol]) | |
BackVol | =RTD('tos.rtd','BACK_VOL',[Symbol]) | |
WeightedBackVol | =RTD('tos.rtd','WEIGHTED_BACK_VOL',[Symbol]) | |
VolDiff | =RTD('tos.rtd','VOL_DIFF',[Symbol]) | |
PutCallRatio | =RTD('tos.rtd','PUT_CALL_RATIO',[Symbol]) | |
CallVolumeIndex | =RTD('tos.rtd','CALL_VOLUME_INDEX',[Symbol]) | |
PutVolumeIndex | =RTD('tos.rtd','PUT_VOLUME_INDEX',[Symbol]) | |
OptionVolumeIndex | =RTD('tos.rtd','OPTION_VOLUME_INDEX',[Symbol]) | |
FrontExpectedMove | =RTD('tos.rtd','FRONT_EX_MOVE',[Symbol]) | |
BackExpectedMove | =RTD('tos.rtd','BACK_EX_MOVE',[Symbol]) | |
ExpectedMoveDiff | =RTD('tos.rtd','EX_MOVE_DIFF',[Symbol]) | |
Beta | =RTD('tos.rtd','BETA',[Symbol]) | |
High52 | =RTD('tos.rtd','52HIGH',[Symbol]) | |
Low52 | =RTD('tos.rtd','52LOW',[Symbol]) | |
PE | =RTD('tos.rtd','PE',[Symbol]) | |
EPS | =RTD('tos.rtd','EPS',[Symbol]) | |
MarketCap | =RTD('tos.rtd','MARKET_CAP',[Symbol]) | |
Shares | =RTD('tos.rtd','SHARES',[Symbol]) | |
DividendYield | =RTD('tos.rtd','YIELD',[Symbol]) | |
DividendShare | =RTD('tos.rtd','DIV',[Symbol]) | |
LastUpdateTimeStamp |
rtd.QuoteDayHistoryTOS
Linking Thinkorswim Chart To Excel
The table contains day data history of stocks, futures, and currency pairs from Thinkorswim thinkDesktop.
COLUMN_NAME | RTD_FORMULA | COMMENT |
---|---|---|
Symbol | PK | |
Date | =Date() | PK |
Time | =Time() | |
Description | =RTD('tos.rtd','DESCRIPTION',[Symbol]) | |
Last | =RTD('tos.rtd','LAST',[Symbol]) | |
Change | =RTD('tos.rtd','NET_CHANGE',[Symbol]) | |
PercentChange | =RTD('tos.rtd','PERCENT_CHANGE',[Symbol]) | |
LastSize | =RTD('tos.rtd','LAST_SIZE',[Symbol]) | |
LastX | =RTD('tos.rtd','LX',[Symbol]) | |
Mark | =RTD('tos.rtd','MARK',[Symbol]) | |
MarkChange | =RTD('tos.rtd','MARK_CHANGE',[Symbol]) | |
MarkPercentChange | =RTD('tos.rtd','MARK_PERCENT_CHANGE',[Symbol]) | |
Bid | =RTD('tos.rtd','BID',[Symbol]) | |
Ask | =RTD('tos.rtd','ASK',[Symbol]) | |
BidSize | =RTD('tos.rtd','BID_SIZE',[Symbol]) | |
AskSize | =RTD('tos.rtd','ASK_SIZE',[Symbol]) | |
BidAskSize | =RTD('tos.rtd','BA_SIZE',[Symbol]) | |
BidX | =RTD('tos.rtd','BX',[Symbol]) | |
AskX | =RTD('tos.rtd','AX',[Symbol]) | |
StrengthMeter | =RTD('tos.rtd','STRENGTH_METER',[Symbol]) | |
Open | =RTD('tos.rtd','OPEN',[Symbol]) | |
High | =RTD('tos.rtd','HIGH',[Symbol]) | |
Low | =RTD('tos.rtd','LOW',[Symbol]) | |
Close | =RTD('tos.rtd','CLOSE',[Symbol]) | |
Volume | =RTD('tos.rtd','VOLUME',[Symbol]) | |
OpenInt | =RTD('tos.rtd','OPEN_INT',[Symbol]) | |
ImpliedVol | =RTD('tos.rtd','IMPL_VOL',[Symbol]) | |
VolIndex | =RTD('tos.rtd','VOL_INDEX',[Symbol]) | |
FrontVol | =RTD('tos.rtd','FRONT_VOL',[Symbol]) | |
BackVol | =RTD('tos.rtd','BACK_VOL',[Symbol]) | |
WeightedBackVol | =RTD('tos.rtd','WEIGHTED_BACK_VOL',[Symbol]) | |
VolDiff | =RTD('tos.rtd','VOL_DIFF',[Symbol]) | |
PutCallRatio | =RTD('tos.rtd','PUT_CALL_RATIO',[Symbol]) | |
CallVolumeIndex | =RTD('tos.rtd','CALL_VOLUME_INDEX',[Symbol]) | |
PutVolumeIndex | =RTD('tos.rtd','PUT_VOLUME_INDEX',[Symbol]) | |
OptionVolumeIndex | =RTD('tos.rtd','OPTION_VOLUME_INDEX',[Symbol]) | |
FrontExpectedMove | =RTD('tos.rtd','FRONT_EX_MOVE',[Symbol]) | |
BackExpectedMove | =RTD('tos.rtd','BACK_EX_MOVE',[Symbol]) | |
ExpectedMoveDiff | =RTD('tos.rtd','EX_MOVE_DIFF',[Symbol]) | |
Beta | =RTD('tos.rtd','BETA',[Symbol]) | |
High52 | =RTD('tos.rtd','52HIGH',[Symbol]) | |
Low52 | =RTD('tos.rtd','52LOW',[Symbol]) | |
PE | =RTD('tos.rtd','PE',[Symbol]) | |
EPS | =RTD('tos.rtd','EPS',[Symbol]) | |
MarketCap | =RTD('tos.rtd','MARKET_CAP',[Symbol]) | |
Shares | =RTD('tos.rtd','SHARES',[Symbol]) | |
DividendYield | =RTD('tos.rtd','YIELD',[Symbol]) | |
DividendShare | =RTD('tos.rtd','DIV',[Symbol]) | |
LastUpdateTimeStamp |
rtd.QuoteTickHistoryTOS
The table contains tick data history of stocks, futures, and currency pairs from Thinkorswim thinkDesktop.
COLUMN_NAME | RTD_FORMULA | COMMENT |
---|---|---|
ID | PK, IDENTITY | |
Symbol | ||
DateTime | =DateTime() | |
Date | =Date() | |
Time | =Time() | |
Description | =RTD('tos.rtd','DESCRIPTION',[Symbol]) | |
Last | =RTD('tos.rtd','LAST',[Symbol]) | |
Change | =RTD('tos.rtd','NET_CHANGE',[Symbol]) | |
PercentChange | =RTD('tos.rtd','PERCENT_CHANGE',[Symbol]) | |
LastSize | =RTD('tos.rtd','LAST_SIZE',[Symbol]) | |
LastX | =RTD('tos.rtd','LX',[Symbol]) | |
Mark | =RTD('tos.rtd','MARK',[Symbol]) | |
MarkChange | =RTD('tos.rtd','MARK_CHANGE',[Symbol]) | |
MarkPercentChange | =RTD('tos.rtd','MARK_PERCENT_CHANGE',[Symbol]) | |
Bid | =RTD('tos.rtd','BID',[Symbol]) | |
Ask | =RTD('tos.rtd','ASK',[Symbol]) | |
BidSize | =RTD('tos.rtd','BID_SIZE',[Symbol]) | |
AskSize | =RTD('tos.rtd','ASK_SIZE',[Symbol]) | |
BidAskSize | =RTD('tos.rtd','BA_SIZE',[Symbol]) | |
BidX | =RTD('tos.rtd','BX',[Symbol]) | |
AskX | =RTD('tos.rtd','AX',[Symbol]) | |
StrengthMeter | =RTD('tos.rtd','STRENGTH_METER',[Symbol]) | |
Open | =RTD('tos.rtd','OPEN',[Symbol]) | |
High | =RTD('tos.rtd','HIGH',[Symbol]) | |
Low | =RTD('tos.rtd','LOW',[Symbol]) | |
Close | =RTD('tos.rtd','CLOSE',[Symbol]) | |
Volume | =RTD('tos.rtd','VOLUME',[Symbol]) | |
OpenInt | =RTD('tos.rtd','OPEN_INT',[Symbol]) | |
ImpliedVol | =RTD('tos.rtd','IMPL_VOL',[Symbol]) | |
VolIndex | =RTD('tos.rtd','VOL_INDEX',[Symbol]) | |
FrontVol | =RTD('tos.rtd','FRONT_VOL',[Symbol]) | |
BackVol | =RTD('tos.rtd','BACK_VOL',[Symbol]) | |
WeightedBackVol | =RTD('tos.rtd','WEIGHTED_BACK_VOL',[Symbol]) | |
VolDiff | =RTD('tos.rtd','VOL_DIFF',[Symbol]) | |
PutCallRatio | =RTD('tos.rtd','PUT_CALL_RATIO',[Symbol]) | |
CallVolumeIndex | =RTD('tos.rtd','CALL_VOLUME_INDEX',[Symbol]) | |
PutVolumeIndex | =RTD('tos.rtd','PUT_VOLUME_INDEX',[Symbol]) | |
OptionVolumeIndex | =RTD('tos.rtd','OPTION_VOLUME_INDEX',[Symbol]) | |
FrontExpectedMove | =RTD('tos.rtd','FRONT_EX_MOVE',[Symbol]) | |
BackExpectedMove | =RTD('tos.rtd','BACK_EX_MOVE',[Symbol]) | |
ExpectedMoveDiff | =RTD('tos.rtd','EX_MOVE_DIFF',[Symbol]) | |
Beta | =RTD('tos.rtd','BETA',[Symbol]) | |
High52 | =RTD('tos.rtd','52HIGH',[Symbol]) | |
Low52 | =RTD('tos.rtd','52LOW',[Symbol]) | |
PE | =RTD('tos.rtd','PE',[Symbol]) | |
EPS | =RTD('tos.rtd','EPS',[Symbol]) | |
MarketCap | =RTD('tos.rtd','MARKET_CAP',[Symbol]) | |
Shares | =RTD('tos.rtd','SHARES',[Symbol]) | |
DividendYield | =RTD('tos.rtd','YIELD',[Symbol]) | |
DividendShare | =RTD('tos.rtd','DIV',[Symbol]) |
Real-Time Formulas for MySQL, MariaDB, Oracle Database, IBM DB2, NuoDB, and PostgreSQL
rtd.quotes_tos
The table contains the last data values of stocks, futures, and currency pairs from Thinkorswim thinkDesktop.
COLUMN_NAME | RTD_FORMULA | COMMENT |
---|---|---|
SYMBOL | PK | |
DATETIME | =DateTime() | |
DATE | =Date() | |
TIME | =Time() | |
DESCRIPTION | =RTD('tos.rtd','DESCRIPTION',[SYMBOL]) | |
LAST | =RTD('tos.rtd','LAST',[SYMBOL]) | |
CHANGE | =RTD('tos.rtd','NET_CHANGE',[SYMBOL]) | |
PERCENT_CHANGE | =RTD('tos.rtd','PERCENT_CHANGE',[SYMBOL]) | |
LAST_SIZE | =RTD('tos.rtd','LAST_SIZE',[SYMBOL]) | |
LAST_X | =RTD('tos.rtd','LX',[SYMBOL]) | |
MARK | =RTD('tos.rtd','MARK',[SYMBOL]) | |
MARK_CHANGE | =RTD('tos.rtd','MARK_CHANGE',[SYMBOL]) | |
MARK_PERCENT_CHANGE | =RTD('tos.rtd','MARK_PERCENT_CHANGE',[SYMBOL]) | |
BID | =RTD('tos.rtd','BID',[SYMBOL]) | |
ASK | =RTD('tos.rtd','ASK',[SYMBOL]) | |
BID_SIZE | =RTD('tos.rtd','BID_SIZE',[SYMBOL]) | |
ASK_SIZE | =RTD('tos.rtd','ASK_SIZE',[SYMBOL]) | |
BID_ASK_SIZE | =RTD('tos.rtd','BA_SIZE',[SYMBOL]) | |
BID_X | =RTD('tos.rtd','BX',[SYMBOL]) | |
ASK_X | =RTD('tos.rtd','AX',[SYMBOL]) | |
STRENGTH_METER | =RTD('tos.rtd','STRENGTH_METER',[SYMBOL]) | |
OPEN | =RTD('tos.rtd','OPEN',[SYMBOL]) | |
HIGH | =RTD('tos.rtd','HIGH',[SYMBOL]) | |
LOW | =RTD('tos.rtd','LOW',[SYMBOL]) | |
CLOSE | =RTD('tos.rtd','CLOSE',[SYMBOL]) | |
VOLUME | =RTD('tos.rtd','VOLUME',[SYMBOL]) | |
OPEN_INT | =RTD('tos.rtd','OPEN_INT',[SYMBOL]) | |
IMPLIED_VOL | =RTD('tos.rtd','IMPL_VOL',[SYMBOL]) | |
VOL_INDEX | =RTD('tos.rtd','VOL_INDEX',[SYMBOL]) | |
FRONT_VOL | =RTD('tos.rtd','FRONT_VOL',[SYMBOL]) | |
BACK_VOL | =RTD('tos.rtd','BACK_VOL',[SYMBOL]) | |
WEIGHTED_BACK_VOL | =RTD('tos.rtd','WEIGHTED_BACK_VOL',[SYMBOL]) | |
VOL_DIFF | =RTD('tos.rtd','VOL_DIFF',[SYMBOL]) | |
PUT_CALL_RATIO | =RTD('tos.rtd','PUT_CALL_RATIO',[SYMBOL]) | |
CALL_VOLUME_INDEX | =RTD('tos.rtd','CALL_VOLUME_INDEX',[SYMBOL]) | |
PUT_VOLUME_INDEX | =RTD('tos.rtd','PUT_VOLUME_INDEX',[SYMBOL]) | |
OPTION_VOLUME_INDEX | =RTD('tos.rtd','OPTION_VOLUME_INDEX',[SYMBOL]) | |
FRONT_EXPECTED_MOVE | =RTD('tos.rtd','FRONT_EX_MOVE',[SYMBOL]) | |
BACK_EXPECTED_MOVE | =RTD('tos.rtd','BACK_EX_MOVE',[SYMBOL]) | |
EXPECTED_MOVE_DIFF | =RTD('tos.rtd','EX_MOVE_DIFF',[SYMBOL]) | |
BETA | =RTD('tos.rtd','BETA',[SYMBOL]) | |
HIGH52 | =RTD('tos.rtd','52HIGH',[SYMBOL]) | |
LOW52 | =RTD('tos.rtd','52LOW',[SYMBOL]) | |
PE | =RTD('tos.rtd','PE',[SYMBOL]) | |
EPS | =RTD('tos.rtd','EPS',[SYMBOL]) | |
MARKET_CAP | =RTD('tos.rtd','MARKET_CAP',[SYMBOL]) | |
SHARES | =RTD('tos.rtd','SHARES',[SYMBOL]) | |
DIVIDEND_YIELD | =RTD('tos.rtd','YIELD',[SYMBOL]) | |
DIVIDEND_SHARE | =RTD('tos.rtd','DIV',[SYMBOL]) | |
LAST_UPDATE_TIMESTAMP |
rtd.quote_day_history_tos
The table contains day data history of stocks, futures, and currency pairs from Thinkorswim thinkDesktop.
COLUMN_NAME | RTD_FORMULA | COMMENT |
---|---|---|
SYMBOL | PK | |
DATE | =Date() | PK |
TIME | =Time() | |
DESCRIPTION | =RTD('tos.rtd','DESCRIPTION',[SYMBOL]) | |
LAST | =RTD('tos.rtd','LAST',[SYMBOL]) | |
CHANGE | =RTD('tos.rtd','NET_CHANGE',[SYMBOL]) | |
PERCENT_CHANGE | =RTD('tos.rtd','PERCENT_CHANGE',[SYMBOL]) | |
LAST_SIZE | =RTD('tos.rtd','LAST_SIZE',[SYMBOL]) | |
LAST_X | =RTD('tos.rtd','LX',[SYMBOL]) | |
MARK | =RTD('tos.rtd','MARK',[SYMBOL]) | |
MARK_CHANGE | =RTD('tos.rtd','MARK_CHANGE',[SYMBOL]) | |
MARK_PERCENT_CHANGE | =RTD('tos.rtd','MARK_PERCENT_CHANGE',[SYMBOL]) | |
BID | =RTD('tos.rtd','BID',[SYMBOL]) | |
ASK | =RTD('tos.rtd','ASK',[SYMBOL]) | |
BID_SIZE | =RTD('tos.rtd','BID_SIZE',[SYMBOL]) | |
ASK_SIZE | =RTD('tos.rtd','ASK_SIZE',[SYMBOL]) | |
BID_ASK_SIZE | =RTD('tos.rtd','BA_SIZE',[SYMBOL]) | |
BID_X | =RTD('tos.rtd','BX',[SYMBOL]) | |
ASK_X | =RTD('tos.rtd','AX',[SYMBOL]) | |
STRENGTH_METER | =RTD('tos.rtd','STRENGTH_METER',[SYMBOL]) | |
OPEN | =RTD('tos.rtd','OPEN',[SYMBOL]) | |
HIGH | =RTD('tos.rtd','HIGH',[SYMBOL]) | |
LOW | =RTD('tos.rtd','LOW',[SYMBOL]) | |
CLOSE | =RTD('tos.rtd','CLOSE',[SYMBOL]) | |
VOLUME | =RTD('tos.rtd','VOLUME',[SYMBOL]) | |
OPEN_INT | =RTD('tos.rtd','OPEN_INT',[SYMBOL]) | |
IMPLIED_VOL | =RTD('tos.rtd','IMPL_VOL',[SYMBOL]) | |
VOL_INDEX | =RTD('tos.rtd','VOL_INDEX',[SYMBOL]) | |
FRONT_VOL | =RTD('tos.rtd','FRONT_VOL',[SYMBOL]) | |
BACK_VOL | =RTD('tos.rtd','BACK_VOL',[SYMBOL]) | |
WEIGHTED_BACK_VOL | =RTD('tos.rtd','WEIGHTED_BACK_VOL',[SYMBOL]) | |
VOL_DIFF | =RTD('tos.rtd','VOL_DIFF',[SYMBOL]) | |
PUT_CALL_RATIO | =RTD('tos.rtd','PUT_CALL_RATIO',[SYMBOL]) | |
CALL_VOLUME_INDEX | =RTD('tos.rtd','CALL_VOLUME_INDEX',[SYMBOL]) | |
PUT_VOLUME_INDEX | =RTD('tos.rtd','PUT_VOLUME_INDEX',[SYMBOL]) | |
OPTION_VOLUME_INDEX | =RTD('tos.rtd','OPTION_VOLUME_INDEX',[SYMBOL]) | |
FRONT_EXPECTED_MOVE | =RTD('tos.rtd','FRONT_EX_MOVE',[SYMBOL]) | |
BACK_EXPECTED_MOVE | =RTD('tos.rtd','BACK_EX_MOVE',[SYMBOL]) | |
EXPECTED_MOVE_DIFF | =RTD('tos.rtd','EX_MOVE_DIFF',[SYMBOL]) | |
BETA | =RTD('tos.rtd','BETA',[SYMBOL]) | |
HIGH52 | =RTD('tos.rtd','52HIGH',[SYMBOL]) | |
LOW52 | =RTD('tos.rtd','52LOW',[SYMBOL]) | |
PE | =RTD('tos.rtd','PE',[SYMBOL]) | |
EPS | =RTD('tos.rtd','EPS',[SYMBOL]) | |
MARKET_CAP | =RTD('tos.rtd','MARKET_CAP',[SYMBOL]) | |
SHARES | =RTD('tos.rtd','SHARES',[SYMBOL]) | |
DIVIDEND_YIELD | =RTD('tos.rtd','YIELD',[SYMBOL]) | |
DIVIDEND_SHARE | =RTD('tos.rtd','DIV',[SYMBOL]) | |
LAST_UPDATE_TIMESTAMP |
rtd.quote_tick_history_tos
The table contains tick data history of stocks, futures, and currency pairs from Thinkorswim thinkDesktop.
COLUMN_NAME | RTD_FORMULA | COMMENT |
---|---|---|
ID | PK, IDENTITY | |
SYMBOL | ||
DATETIME | =DateTime() | |
DATE | =Date() | |
TIME | =Time() | |
DESCRIPTION | =RTD('tos.rtd','DESCRIPTION',[SYMBOL]) | |
LAST | =RTD('tos.rtd','LAST',[SYMBOL]) | |
CHANGE | =RTD('tos.rtd','NET_CHANGE',[SYMBOL]) | |
PERCENT_CHANGE | =RTD('tos.rtd','PERCENT_CHANGE',[SYMBOL]) | |
LAST_SIZE | =RTD('tos.rtd','LAST_SIZE',[SYMBOL]) | |
LAST_X | =RTD('tos.rtd','LX',[SYMBOL]) | |
MARK | =RTD('tos.rtd','MARK',[SYMBOL]) | |
MARK_CHANGE | =RTD('tos.rtd','MARK_CHANGE',[SYMBOL]) | |
MARK_PERCENT_CHANGE | =RTD('tos.rtd','MARK_PERCENT_CHANGE',[SYMBOL]) | |
BID | =RTD('tos.rtd','BID',[SYMBOL]) | |
ASK | =RTD('tos.rtd','ASK',[SYMBOL]) | |
BID_SIZE | =RTD('tos.rtd','BID_SIZE',[SYMBOL]) | |
ASK_SIZE | =RTD('tos.rtd','ASK_SIZE',[SYMBOL]) | |
BID_ASK_SIZE | =RTD('tos.rtd','BA_SIZE',[SYMBOL]) | |
BID_X | =RTD('tos.rtd','BX',[SYMBOL]) | |
ASK_X | =RTD('tos.rtd','AX',[SYMBOL]) | |
STRENGTH_METER | =RTD('tos.rtd','STRENGTH_METER',[SYMBOL]) | |
OPEN | =RTD('tos.rtd','OPEN',[SYMBOL]) | |
HIGH | =RTD('tos.rtd','HIGH',[SYMBOL]) | |
LOW | =RTD('tos.rtd','LOW',[SYMBOL]) | |
CLOSE | =RTD('tos.rtd','CLOSE',[SYMBOL]) | |
VOLUME | =RTD('tos.rtd','VOLUME',[SYMBOL]) | |
OPEN_INT | =RTD('tos.rtd','OPEN_INT',[SYMBOL]) | |
IMPLIED_VOL | =RTD('tos.rtd','IMPL_VOL',[SYMBOL]) | |
VOL_INDEX | =RTD('tos.rtd','VOL_INDEX',[SYMBOL]) | |
FRONT_VOL | =RTD('tos.rtd','FRONT_VOL',[SYMBOL]) | |
BACK_VOL | =RTD('tos.rtd','BACK_VOL',[SYMBOL]) | |
WEIGHTED_BACK_VOL | =RTD('tos.rtd','WEIGHTED_BACK_VOL',[SYMBOL]) | |
VOL_DIFF | =RTD('tos.rtd','VOL_DIFF',[SYMBOL]) | |
PUT_CALL_RATIO | =RTD('tos.rtd','PUT_CALL_RATIO',[SYMBOL]) | |
CALL_VOLUME_INDEX | =RTD('tos.rtd','CALL_VOLUME_INDEX',[SYMBOL]) | |
PUT_VOLUME_INDEX | =RTD('tos.rtd','PUT_VOLUME_INDEX',[SYMBOL]) | |
OPTION_VOLUME_INDEX | =RTD('tos.rtd','OPTION_VOLUME_INDEX',[SYMBOL]) | |
FRONT_EXPECTED_MOVE | =RTD('tos.rtd','FRONT_EX_MOVE',[SYMBOL]) | |
BACK_EXPECTED_MOVE | =RTD('tos.rtd','BACK_EX_MOVE',[SYMBOL]) | |
EXPECTED_MOVE_DIFF | =RTD('tos.rtd','EX_MOVE_DIFF',[SYMBOL]) | |
BETA | =RTD('tos.rtd','BETA',[SYMBOL]) | |
HIGH52 | =RTD('tos.rtd','52HIGH',[SYMBOL]) | |
LOW52 | =RTD('tos.rtd','52LOW',[SYMBOL]) | |
PE | =RTD('tos.rtd','PE',[SYMBOL]) | |
EPS | =RTD('tos.rtd','EPS',[SYMBOL]) | |
MARKET_CAP | =RTD('tos.rtd','MARKET_CAP',[SYMBOL]) | |
SHARES | =RTD('tos.rtd','SHARES',[SYMBOL]) | |
DIVIDEND_YIELD | =RTD('tos.rtd','YIELD',[SYMBOL]) | |
DIVIDEND_SHARE | =RTD('tos.rtd','DIV',[SYMBOL]) |