Quotes from MSN Money

Quotes from MSN Money

Overview

The RTD database contains preconfigured tables for getting stock quotes from MSN Money using RealTimeToExcel.

These data are available and activated by default. Just edit required symbols in the QuoteListMsnMoney table.

MSN Money data are delayed.

Use https://www.msn.com/en-us/money to find tickers.

Real-Time Data Tables

Table Configurations

Microsoft SQL Server and Microsoft SQL Server Compact:

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORY
rtdQuoteListMsnMoney
rtdQuotesMsnMoneySELECT Code AS Symbol FROM rtd.QuoteListMsnMoney
rtdQuoteDayHistoryMsnMoneySELECT Code AS Symbol FROM rtd.QuoteListMsnMoney
rtdQuoteTimeHistoryMsnMoneySELECT Code AS Symbol FROM rtd.QuoteListMsnMoney
rtdQuoteTickHistoryMsnMoneySELECT Code AS Symbol FROM rtd.QuoteListMsnMoney1

MySQL, MariaDB, and PostgreSQL:

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORY
rtdquote_list_msnmoney
rtdquotes_msnmoneySELECT CODE AS SYMBOL FROM rtd.quote_list_msnmoney
rtdquote_day_history_msnmoneySELECT CODE AS SYMBOL FROM rtd.quote_list_msnmoney
rtdquote_time_history_msnmoneySELECT CODE AS SYMBOL FROM rtd.quote_list_msnmoney
rtdquote_tick_history_msnmoneySELECT CODE AS SYMBOL FROM rtd.quote_list_msnmoney1

Oracle Database, IBM DB2, and NuoDB:

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORY
RTDQUOTE_LIST_MSNMONEY
RTDQUOTES_MSNMONEYSELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_MSNMONEY
RTDQUOTE_DAY_HISTORY_MSNMONEYSELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_MSNMONEY
RTDQUOTE_TIME_HISTORY_MSNMONEYSELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_MSNMONEY
RTDQUOTE_TICK_HISTORY_MSNMONEYSELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_MSNMONEY1

* Click on the table name to go to the table description.

Task Table Examples

rtd.QuoteListMsnMoney for Microsoft SQL Server and Microsoft SQL Server Compact:

Code
AAPL
GOOG

rtd.quote_list_msnmoney for MySQL, MariaDB, Oracle Database, IBM DB2, NuoDB, and PostgreSQL:

CODE
AAPL
GOOG

Use https://www.msn.com/en-us/money to find tickers.

Primary Key Columns

Microsoft SQL Server and Microsoft SQL Server Compact:

TABLE_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
rtdQuotesMsnMoneySymbol=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Symbol")PK
rtdQuoteDayHistoryMsnMoneySymbol=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Symbol")PK
rtdQuoteDayHistoryMsnMoneyDate=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"rtd_LastUpdateDate")PK
rtdQuoteTimeHistoryMsnMoneySymbol=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Symbol")PK
rtdQuoteTimeHistoryMsnMoneyDateTime=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"rtd_LastUpdate")PK
rtdQuoteTickHistoryMsnMoneyIDPK, IDENTITY

MySQL, MariaDB, and PostgreSQL:

TABLE_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
rtdquotes_msnmoneySYMBOL=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Symbol")PK
rtdquote_day_history_msnmoneySYMBOL=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Symbol")PK
rtdquote_day_history_msnmoneyDATE=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"rtd_LastUpdateDate")PK
rtdquote_time_history_msnmoneySYMBOL=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Symbol")PK
rtdquote_time_history_msnmoneyDATETIME=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"rtd_LastUpdate")PK
rtdquote_tick_history_msnmoneyIDPK, IDENTITY

Oracle Database, IBM DB2, and NuoDB:

TABLE_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
RTDQUOTES_MSNMONEYSYMBOL=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Symbol")PK
RTDQUOTE_DAY_HISTORY_MSNMONEYSYMBOL=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Symbol")PK
RTDQUOTE_DAY_HISTORY_MSNMONEYDATE=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"rtd_LastUpdateDate")PK
RTDQUOTE_TICK_HISTORY_MSNMONEYIDPK, IDENTITY
RTDQUOTE_TIME_HISTORY_MSNMONEYSYMBOL=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Symbol")PK
RTDQUOTE_TIME_HISTORY_MSNMONEYDATETIME=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"rtd_LastUpdate")PK

Real-Time Formulas for Microsoft SQL Server and Microsoft SQL Server Compact

rtd.QuotesMsnMoney

The table contains the last data values of stock quotes from MSN Money.

COLUMN_NAMERTD_FORMULACOMMENT
Symbol=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Symbol")PK
DateTime=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"rtd_LastUpdate")
Date=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"rtd_LastUpdateDate")
Time=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"rtd_LastUpdateTime")
Last=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Last")
Change=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Change")
PercentChange=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"PercentChange")
Open=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Open")
High=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"High")
Low=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Low")
Volume=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Volume")
YearHigh=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"YearHigh")
YearLow=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"YearLow")
PE=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"PE")
EPS=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"EPS")
MarketCap=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"MarketCap")
LastUpdateTimeStamp

rtd.QuoteDayHistoryMsnMoney

The table contains day history of stock quotes from MSN Money.

COLUMN_NAMERTD_FORMULACOMMENT
Symbol=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Symbol")PK
Date=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"rtd_LastUpdateDate")PK
Time=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"rtd_LastUpdateTime")
Last=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Last")
Change=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Change")
PercentChange=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"PercentChange")
Open=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Open")
High=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"High")
Low=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Low")
Volume=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Volume")
YearHigh=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"YearHigh")
YearLow=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"YearLow")
PE=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"PE")
EPS=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"EPS")
MarketCap=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"MarketCap")
LastUpdateTimeStamp

rtd.QuoteTimeHistoryMsnMoney

The table contains time history of stock quotes from MSN Money.

COLUMN_NAMERTD_FORMULACOMMENT
Symbol=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Symbol")PK
DateTime=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"rtd_LastUpdate")PK
Date=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"rtd_LastUpdateDate")
Time=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"rtd_LastUpdateTime")
Last=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Last")
Change=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Change")
PercentChange=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"PercentChange")
Open=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Open")
High=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"High")
Low=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Low")
Volume=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Volume")
YearHigh=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"YearHigh")
YearLow=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"YearLow")
PE=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"PE")
EPS=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"EPS")
MarketCap=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"MarketCap")
LastUpdateTimeStamp

rtd.QuoteTickHistoryMsnMoney

The table contains tick history of stock quotes from MSN Money.

COLUMN_NAMERTD_FORMULACOMMENT
IDPK, IDENTITY
Symbol=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Symbol")
DateTime=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"rtd_LastUpdate")
Date=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"rtd_LastUpdateDate")
Time=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"rtd_LastUpdateTime")
Last=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Last")
Change=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Change")
PercentChange=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"PercentChange")
Open=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Open")
High=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"High")
Low=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Low")
Volume=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Volume")
YearHigh=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"YearHigh")
YearLow=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"YearLow")
PE=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"PE")
EPS=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"EPS")
MarketCap=RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"MarketCap")

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

rtd.quotes_msnmoney

The table contains the last data values of stock quotes from MSN Money.

COLUMN_NAMERTD_FORMULACOMMENT
SYMBOL=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Symbol")PK
DATETIME=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"rtd_LastUpdate")
DATE=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"rtd_LastUpdateDate")
TIME=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"rtd_LastUpdateTime")
LAST=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Last")
CHANGE=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Change")
PERCENT_CHANGE=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"PercentChange")
OPEN=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Open")
HIGH=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"High")
LOW=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Low")
VOLUME=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Volume")
YEAR_HIGH=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"YearHigh")
YEAR_LOW=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"YearLow")
PE=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"PE")
EPS=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"EPS")
MARKET_CAP=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"MarketCap")
LAST_UPDATE_TIMESTAMP

rtd.quote_day_history_msnmoney

The table contains day history of stock quotes from MSN Money.

COLUMN_NAMERTD_FORMULACOMMENT
SYMBOL=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Symbol")PK
DATE=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"rtd_LastUpdateDate")PK
TIME=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"rtd_LastUpdateTime")
LAST=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Last")
CHANGE=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Change")
PERCENT_CHANGE=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"PercentChange")
OPEN=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Open")
HIGH=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"High")
LOW=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Low")
VOLUME=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Volume")
YEAR_HIGH=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"YearHigh")
YEAR_LOW=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"YearLow")
PE=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"PE")
EPS=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"EPS")
MARKET_CAP=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"MarketCap")
LAST_UPDATE_TIMESTAMP

rtd.quote_time_history_msnmoney

The table contains time history of stock quotes from MSN Money.

COLUMN_NAMERTD_FORMULACOMMENT
SYMBOL=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Symbol")PK
DATETIME=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"rtd_LastUpdate")PK
DATE=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"rtd_LastUpdateDate")
TIME=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"rtd_LastUpdateTime")
LAST=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Last")
CHANGE=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Change")
PERCENT_CHANGE=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"PercentChange")
OPEN=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Open")
HIGH=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"High")
LOW=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Low")
VOLUME=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Volume")
YEAR_HIGH=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"YearHigh")
YEAR_LOW=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"YearLow")
PE=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"PE")
EPS=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"EPS")
MARKET_CAP=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"MarketCap")
LAST_UPDATE_TIMESTAMP

rtd.quote_tick_history_msnmoney

The table contains tick history of stock quotes from MSN Money.

COLUMN_NAMERTD_FORMULACOMMENT
IDPK, IDENTITY
SYMBOL=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Symbol")
DATETIME=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"rtd_LastUpdate")
DATE=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"rtd_LastUpdateDate")
TIME=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"rtd_LastUpdateTime")
LAST=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Last")
CHANGE=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Change")
PERCENT_CHANGE=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"PercentChange")
OPEN=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Open")
HIGH=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"High")
LOW=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Low")
VOLUME=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Volume")
YEAR_HIGH=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"YearHigh")
YEAR_LOW=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"YearLow")
PE=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"PE")
EPS=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"EPS")
MARKET_CAP=RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"MarketCap")
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.