Option Data from MSN Money
Overview
The RTD database contains preconfigured tables for getting option data from MSN Money using RealTimeToExcel.
These data are available and activated by default. Just edit required symbols in the OptionListMsnMoney table.
MSN Money data are delayed.
Use https://www.msn.com/en-us/money to find option tickers.
Real-Time Data Tables
Table Configurations
Microsoft SQL Server and Microsoft SQL Server Compact:
| TABLE_SCHEMA | TABLE_NAME | LOAD_CODE | IS_HISTORY |
|---|---|---|---|
rtd | OptionListMsnMoney | ||
rtd | OptionsMsnMoney | SELECT Code FROM rtd.OptionListMsnMoney | |
rtd | OptionDayHistoryMsnMoney | SELECT Code FROM rtd.OptionListMsnMoney | |
rtd | OptionTickHistoryMsnMoney | SELECT Code FROM rtd.OptionListMsnMoney | 1 |
MySQL, MariaDB, and PostgreSQL:
| TABLE_SCHEMA | TABLE_NAME | LOAD_CODE | IS_HISTORY |
|---|---|---|---|
rtd | option_list_msnmoney | ||
rtd | options_msnmoney | SELECT CODE FROM rtd.option_list_msnmoney | |
rtd | option_day_history_msnmoney | SELECT CODE FROM rtd.option_list_msnmoney | |
rtd | option_tick_history_msnmoney | SELECT CODE FROM rtd.option_list_msnmoney | 1 |
Oracle Database, IBM DB2, and NuoDB:
| TABLE_SCHEMA | TABLE_NAME | LOAD_CODE | IS_HISTORY |
|---|---|---|---|
RTD | OPTION_LIST_MSNMONEY | ||
RTD | OPTIONS_MSNMONEY | SELECT CODE FROM RTD.OPTION_LIST_MSNMONEY | |
RTD | OPTION_DAY_HISTORY_MSNMONEY | SELECT CODE FROM RTD.OPTION_LIST_MSNMONEY | |
RTD | OPTION_TICK_HISTORY_MSNMONEY | SELECT CODE FROM RTD.OPTION_LIST_MSNMONEY | 1 |
* Click on the table name to go to the table description.
Task Table Examples
rtd.OptionListMsnMoney for Microsoft SQL Server and Microsoft SQL Server Compact:
| Code |
|---|
| .AAPL160115C100 |
| .AAPL160115C200 |
| AAPL160115P00100000 |
| AAPL160115P00200000 |
rtd.option_list_msnmoney for MySQL, MariaDB, Oracle Database, IBM DB2, NuoDB, and PostgreSQL:
| CODE |
|---|
| .AAPL160115C100 |
| .AAPL160115C200 |
| AAPL160115P00100000 |
| AAPL160115P00200000 |
Task tables can contain option codes in thinkDesktop and MSN Money formats as shown above.
The result OptionCode column in data tables contains option codes in MSN Money format.
Primary Key Columns
Microsoft SQL Server and Microsoft SQL Server Compact:
| TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|---|---|
rtd | OptionsMsnMoney | Code | PK | |
rtd | OptionDayHistoryMsnMoney | DateTime | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"rtd_LastUpdate") | Formula |
rtd | OptionDayHistoryMsnMoney | Code | PK | |
rtd | OptionDayHistoryMsnMoney | Date | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"rtd_LastUpdateDate") | PK |
rtd | OptionTickHistoryMsnMoney | ID | PK, IDENTITY |
MySQL, MariaDB, and PostgreSQL:
| TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|---|---|
rtd | options_msnmoney | CODE | PK | |
rtd | option_day_history_msnmoney | DATETIME | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"rtd_LastUpdate") | Formula |
rtd | option_day_history_msnmoney | CODE | PK | |
rtd | option_day_history_msnmoney | DATE | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"rtd_LastUpdateDate") | PK |
rtd | option_tick_history_msnmoney | ID | PK, IDENTITY |
Oracle Database, IBM DB2, and NuoDB:
| TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|---|---|
RTD | OPTIONS_MSNMONEY | CODE | PK | |
RTD | OPTION_DAY_HISTORY_MSNMONEY | DATETIME | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"rtd_LastUpdate") | Formula |
RTD | OPTION_DAY_HISTORY_MSNMONEY | CODE | PK | |
RTD | OPTION_DAY_HISTORY_MSNMONEY | DATE | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"rtd_LastUpdateDate") | PK |
RTD | OPTION_TICK_HISTORY_MSNMONEY | ID | PK, IDENTITY |
Real-Time Formulas for Microsoft SQL Server and Microsoft SQL Server Compact
rtd.OptionsMsnMoney
The table contains the last values of option data from MSN Money.
| COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| Code | PK | |
| OptionCode | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"OptionCode") | |
| Symbol | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Symbol") | |
| DateTime | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"rtd_LastUpdate") | |
| Date | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"rtd_LastUpdateDate") | |
| Time | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"rtd_LastUpdateTime") | |
| OptionSymbol | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"OptionSymbol") | |
| ExpDate | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Exp") | |
| Strike | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Strike") | |
| Type | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Type") | |
| Last | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Last") | |
| Change | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Change") | |
| PercentChange | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"PercentChange") | |
| Mark | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Mark") | |
| Bid | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Bid") | |
| Ask | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Ask") | |
| Volume | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Volume") | |
| OpenInt | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"OpenInt") | |
| LastUpdateTimeStamp |
rtd.OptionDayHistoryMsnMoney
The table contains day history of option data from MSN Money.
| COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| DateTime | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"rtd_LastUpdate") | Formula |
| Code | PK | |
| OptionCode | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"OptionCode") | |
| Symbol | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Symbol") | |
| Date | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"rtd_LastUpdateDate") | PK |
| Time | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"rtd_LastUpdateTime") | |
| OptionSymbol | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"OptionSymbol") | |
| ExpDate | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Exp") | |
| Strike | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Strike") | |
| Type | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Type") | |
| Last | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Last") | |
| Change | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Change") | |
| PercentChange | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"PercentChange") | |
| Mark | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Mark") | |
| Bid | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Bid") | |
| Ask | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Ask") | |
| Volume | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Volume") | |
| OpenInt | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"OpenInt") | |
| LastUpdateTimeStamp |
rtd.OptionTickHistoryMsnMoney
The table contains tick history of option data from MSN Money.
| COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| ID | PK, IDENTITY | |
| Code | ||
| OptionCode | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"OptionCode") | |
| Symbol | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Symbol") | |
| DateTime | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"rtd_LastUpdate") | |
| Date | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"rtd_LastUpdateDate") | |
| Time | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"rtd_LastUpdateTime") | |
| OptionSymbol | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"OptionSymbol") | |
| ExpDate | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Exp") | |
| Strike | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Strike") | |
| Type | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Type") | |
| Last | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Last") | |
| Change | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Change") | |
| PercentChange | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"PercentChange") | |
| Mark | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Mark") | |
| Bid | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Bid") | |
| Ask | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Ask") | |
| Volume | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"Volume") | |
| OpenInt | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"OpenInt") |
Real-Time Formulas for MySQL, MariaDB, Oracle Database, IBM DB2, NuoDB, and PostgreSQL
rtd.options_msnmoney
The table contains the last values of option data from MSN Money.
| COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| CODE | PK | |
| OPTION_CODE | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"OptionCode") | |
| SYMBOL | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Symbol") | |
| DATETIME | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"rtd_LastUpdate") | |
| DATE | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"rtd_LastUpdateDate") | |
| TIME | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"rtd_LastUpdateTime") | |
| OPTION_SYMBOL | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"OptionSymbol") | |
| EXP_DATE | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Exp") | |
| STRIKE | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Strike") | |
| TYPE | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Type") | |
| LAST | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Last") | |
| CHANGE | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Change") | |
| PERCENT_CHANGE | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"PercentChange") | |
| MARK | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Mark") | |
| BID | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Bid") | |
| ASK | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Ask") | |
| VOLUME | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Volume") | |
| OPEN_INT | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"OpenInt") | |
| LAST_UPDATE_TIMESTAMP |
rtd.option_day_history_msnmoney
The table contains day history of option data from MSN Money.
| COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| DATETIME | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"rtd_LastUpdate") | Formula |
| CODE | PK | |
| OPTION_CODE | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"OptionCode") | |
| SYMBOL | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Symbol") | |
| DATE | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"rtd_LastUpdateDate") | PK |
| TIME | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"rtd_LastUpdateTime") | |
| OPTION_SYMBOL | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"OptionSymbol") | |
| EXP_DATE | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Exp") | |
| STRIKE | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Strike") | |
| TYPE | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Type") | |
| LAST | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Last") | |
| CHANGE | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Change") | |
| PERCENT_CHANGE | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"PercentChange") | |
| MARK | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Mark") | |
| BID | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Bid") | |
| ASK | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Ask") | |
| VOLUME | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Volume") | |
| OPEN_INT | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"OpenInt") | |
| LAST_UPDATE_TIMESTAMP |
rtd.option_tick_history_msnmoney
The table contains tick history of option data from MSN Money.
| COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| ID | PK, IDENTITY | |
| CODE | ||
| OPTION_CODE | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"OptionCode") | |
| SYMBOL | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Symbol") | |
| DATETIME | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"rtd_LastUpdate") | |
| DATE | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"rtd_LastUpdateDate") | |
| TIME | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"rtd_LastUpdateTime") | |
| OPTION_SYMBOL | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"OptionSymbol") | |
| EXP_DATE | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Exp") | |
| STRIKE | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Strike") | |
| TYPE | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Type") | |
| LAST | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Last") | |
| CHANGE | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Change") | |
| PERCENT_CHANGE | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"PercentChange") | |
| MARK | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Mark") | |
| BID | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Bid") | |
| ASK | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Ask") | |
| VOLUME | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"Volume") | |
| OPEN_INT | =RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"OpenInt") |