Option Data from MSN Money

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_SCHEMATABLE_NAMELOAD_CODEIS_HISTORY
rtdOptionListMsnMoney
rtdOptionsMsnMoneySELECT Code FROM rtd.OptionListMsnMoney
rtdOptionDayHistoryMsnMoneySELECT Code FROM rtd.OptionListMsnMoney
rtdOptionTickHistoryMsnMoneySELECT Code FROM rtd.OptionListMsnMoney1

MySQL, MariaDB, and PostgreSQL:

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORY
rtdoption_list_msnmoney
rtdoptions_msnmoneySELECT CODE FROM rtd.option_list_msnmoney
rtdoption_day_history_msnmoneySELECT CODE FROM rtd.option_list_msnmoney
rtdoption_tick_history_msnmoneySELECT CODE FROM rtd.option_list_msnmoney1

Oracle Database, IBM DB2, and NuoDB:

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORY
RTDOPTION_LIST_MSNMONEY
RTDOPTIONS_MSNMONEYSELECT CODE FROM RTD.OPTION_LIST_MSNMONEY
RTDOPTION_DAY_HISTORY_MSNMONEYSELECT CODE FROM RTD.OPTION_LIST_MSNMONEY
RTDOPTION_TICK_HISTORY_MSNMONEYSELECT CODE FROM RTD.OPTION_LIST_MSNMONEY1

* 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_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
rtdOptionsMsnMoneyCodePK
rtdOptionDayHistoryMsnMoneyDateTime=RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"rtd_LastUpdate")Formula
rtdOptionDayHistoryMsnMoneyCodePK
rtdOptionDayHistoryMsnMoneyDate=RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"rtd_LastUpdateDate")PK
rtdOptionTickHistoryMsnMoneyIDPK, IDENTITY

MySQL, MariaDB, and PostgreSQL:

TABLE_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
rtdoptions_msnmoneyCODEPK
rtdoption_day_history_msnmoneyDATETIME=RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"rtd_LastUpdate")Formula
rtdoption_day_history_msnmoneyCODEPK
rtdoption_day_history_msnmoneyDATE=RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"rtd_LastUpdateDate")PK
rtdoption_tick_history_msnmoneyIDPK, IDENTITY

Oracle Database, IBM DB2, and NuoDB:

TABLE_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
RTDOPTIONS_MSNMONEYCODEPK
RTDOPTION_DAY_HISTORY_MSNMONEYDATETIME=RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"rtd_LastUpdate")Formula
RTDOPTION_DAY_HISTORY_MSNMONEYCODEPK
RTDOPTION_DAY_HISTORY_MSNMONEYDATE=RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"rtd_LastUpdateDate")PK
RTDOPTION_TICK_HISTORY_MSNMONEYIDPK, 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_NAMERTD_FORMULACOMMENT
CodePK
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_NAMERTD_FORMULACOMMENT
DateTime=RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[Code],"rtd_LastUpdate")Formula
CodePK
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_NAMERTD_FORMULACOMMENT
IDPK, 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_NAMERTD_FORMULACOMMENT
CODEPK
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_NAMERTD_FORMULACOMMENT
DATETIME=RTD("gartle.rtd",,"MsnMoneyFinanceOptions",[CODE],"rtd_LastUpdate")Formula
CODEPK
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_NAMERTD_FORMULACOMMENT
IDPK, 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")