Stocks and Options
from Yahoo Finance and MSN Money
from trading platforms like Thinkorswim
into Microsoft Excel, CSV, and databases
Products for Traders and Investors
Here you will find a set of products that allow getting data into Microsoft Excel, CSV, and databases from financial websites and trading platforms.
| Product | Data Sources | Targets | Usage |
|---|---|---|---|
| MARKET.RTD | Yahoo Finance and MSN Money | Excel | RTD formula |
| MARKET.CSV | Yahoo Finance and MSN Money | Databases | Console app |
| RTD.DB | Trading platforms like Thinkorswim | Databases | Windows app |
MARKET.RTD
MARKET.RTD allows loading data from Yahoo Finance and MSN Money into Microsoft Excel.
These financial websites publish a lot of data: stock quotes, option and future chains, financial reports, etc.
MARKET.RTD is a specialized tool that allows getting these data into Excel using RTD formulas like
=RTD("market.rtd",,"MsnMoneyQuote","AAPL","High")
=RTD("market.rtd",,"MsnMoneyQuote","AAPL","Low")
=RTD("market.rtd",,"MsnMoneyQuote","AAPL","Last")
Learn more about MARKET.RTD Download
MARKET.RTD Formula Builder
Getting data in Excel using MARKET.RTD is easy.
You can customize a lot of examples.
Another way is to use Formula Builder.
Just select a data provider, formula style, separators.
Then click Go, Copy Formulas, and paste the formulas into your spreadsheets.
Learn more about MARKET.RTD Download
MARKET.CSV
MARKET.CSV is command line utility for loading market data for stocks, ETFs, indexes, and options to CSV and databases on a daily basis.
MARKET.CSV is a specialized parser that downloads data from Yahoo Finance, Google Finance, or MSN Money and creates CSV files for further import into databases.
The product includes a configured SQL Server database. So, you can get the data in a database in an easy way.
Learn more about MARKET.CSV Download
RTD.DB
RTD.DB allows loading real-time data from trading platforms like Thinkorswim into databases.
It works with DDE and RTD servers like Microsoft Excel, however, saves data to a database.
You can create stock and option histories in required time frames.
You must have SQL skills to use this product.
Also, you must have a platform that supports DDE or RTD.
Learn more about RTD.DB Download
Select a product for your needs
| MARKET.RTD | MARKET.CSV | RTD.DB | |
|---|---|---|---|
| Data sources | Yahoo Finance and MSN Money | Yahoo Finance and MSN Money | Trading platforms like Thinkorswim |
| Target application | Excel | Databases | Databases |
| Usage | Excel RTD formulas | Console app and batch files | Windows app |
| Quotes | Delayed | Delayed | Real-time |
| Stock quotes | ✓ | ✓ | ✓ |
| Fundamental data | ✓ | ✓ | ✓ |
| Financial reports | ✓ | ||
| Option chains | ✓ | ✓ | ✓ |
| Greeks & probabilities | ✓ | ||
| Historical stock prices | ✓ | ✓ | ✓ |
| Historical option prices | ✓ | ✓ | |
| 1-year subscription for personal use, USD | 4995 | 4995 | 4995 |
| 1-year subscription for commercial use, USD | 9995 | 14995 | 19995 |
| Download | Download | Download |