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_SCHEMA | TABLE_NAME | LOAD_CODE | IS_HISTORY |
|---|---|---|---|
rtd | QuoteListMsnMoney | ||
rtd | QuotesMsnMoney | SELECT Code AS Symbol FROM rtd.QuoteListMsnMoney | |
rtd | QuoteDayHistoryMsnMoney | SELECT Code AS Symbol FROM rtd.QuoteListMsnMoney | |
rtd | QuoteTimeHistoryMsnMoney | SELECT Code AS Symbol FROM rtd.QuoteListMsnMoney | |
rtd | QuoteTickHistoryMsnMoney | SELECT Code AS Symbol FROM rtd.QuoteListMsnMoney | 1 |
MySQL, MariaDB, and PostgreSQL:
| TABLE_SCHEMA | TABLE_NAME | LOAD_CODE | IS_HISTORY |
|---|---|---|---|
rtd | quote_list_msnmoney | ||
rtd | quotes_msnmoney | SELECT CODE AS SYMBOL FROM rtd.quote_list_msnmoney | |
rtd | quote_day_history_msnmoney | SELECT CODE AS SYMBOL FROM rtd.quote_list_msnmoney | |
rtd | quote_time_history_msnmoney | SELECT CODE AS SYMBOL FROM rtd.quote_list_msnmoney | |
rtd | quote_tick_history_msnmoney | SELECT CODE AS SYMBOL FROM rtd.quote_list_msnmoney | 1 |
Oracle Database, IBM DB2, and NuoDB:
| TABLE_SCHEMA | TABLE_NAME | LOAD_CODE | IS_HISTORY |
|---|---|---|---|
RTD | QUOTE_LIST_MSNMONEY | ||
RTD | QUOTES_MSNMONEY | SELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_MSNMONEY | |
RTD | QUOTE_DAY_HISTORY_MSNMONEY | SELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_MSNMONEY | |
RTD | QUOTE_TIME_HISTORY_MSNMONEY | SELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_MSNMONEY | |
RTD | QUOTE_TICK_HISTORY_MSNMONEY | SELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_MSNMONEY | 1 |
* 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_SCHEMA | TABLE_NAME | COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|---|---|
rtd | QuotesMsnMoney | Symbol | =RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Symbol") | PK |
rtd | QuoteDayHistoryMsnMoney | Symbol | =RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Symbol") | PK |
rtd | QuoteDayHistoryMsnMoney | Date | =RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"rtd_LastUpdateDate") | PK |
rtd | QuoteTimeHistoryMsnMoney | Symbol | =RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"Symbol") | PK |
rtd | QuoteTimeHistoryMsnMoney | DateTime | =RTD("gartle.rtd",,"MsnMoneyQuotes",[Symbol],"rtd_LastUpdate") | PK |
rtd | QuoteTickHistoryMsnMoney | ID | PK, IDENTITY |
MySQL, MariaDB, and PostgreSQL:
| TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|---|---|
rtd | quotes_msnmoney | SYMBOL | =RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Symbol") | PK |
rtd | quote_day_history_msnmoney | SYMBOL | =RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Symbol") | PK |
rtd | quote_day_history_msnmoney | DATE | =RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"rtd_LastUpdateDate") | PK |
rtd | quote_time_history_msnmoney | SYMBOL | =RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Symbol") | PK |
rtd | quote_time_history_msnmoney | DATETIME | =RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"rtd_LastUpdate") | PK |
rtd | quote_tick_history_msnmoney | ID | PK, IDENTITY |
Oracle Database, IBM DB2, and NuoDB:
| TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|---|---|
RTD | QUOTES_MSNMONEY | SYMBOL | =RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Symbol") | PK |
RTD | QUOTE_DAY_HISTORY_MSNMONEY | SYMBOL | =RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Symbol") | PK |
RTD | QUOTE_DAY_HISTORY_MSNMONEY | DATE | =RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"rtd_LastUpdateDate") | PK |
RTD | QUOTE_TICK_HISTORY_MSNMONEY | ID | PK, IDENTITY | |
RTD | QUOTE_TIME_HISTORY_MSNMONEY | SYMBOL | =RTD("gartle.rtd",,"MsnMoneyQuotes",[SYMBOL],"Symbol") | PK |
RTD | QUOTE_TIME_HISTORY_MSNMONEY | DATETIME | =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_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| 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_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| 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_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| 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_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| ID | PK, 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_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| 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_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| 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_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| 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_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| ID | PK, 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") |