Stocks and Options

from Yahoo Finance, Google Finance, and MSN Money

from trading platforms like Thinkorswim and TWS

into Microsoft Excel, CSV, Microsoft SQL Server and MySQL

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.

If you have less than ten stocks in your portfolio or just start building your trading system, you may use any product for free.

ProductData SourcesTargetsUsage
MARKET.RTDYahoo Finance, Google Finance, and MSN MoneyExcelRTD formula
MARKET.CSVYahoo Finance, Google Finance, and MSN MoneyDatabasesConsole app
WEB.RTDFinancial websitesExcelRTD formula
WEB.CSVFinancial websitesDatabasesConsole app
RTD.DBTrading platforms like Thinkorswim or TWSDatabasesWindows app
DB.RTDDatabases like Microsoft SQL Server or MySQLExcelRTD formula

MARKET.RTD

MARKET.RTD allows loading data from Yahoo Finance, Google 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

Example of Yahoo Finance Quotes

MARKET.RTD Formula Builder

Getting data in Excel using MARKET.RTD is easy.

You may 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

MARKET.RTD Formula Builder - Providers

WEB.RTD

WEB.RTD implements a simple idea:
if you may get data from the Web,
you may get the data in Microsoft Excel spreadsheets.

WEB.RTD is a universal parser of HTML, XML, JSON, and CSV.

You get Excel RTD formulas using Formula Builder as shown above. It is easy.

WEB.RTD is a unique product.
If you know the URL, you may build an updateable model yourself in a couple of minutes.

Learn more

Report Worksheet Example

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 may get the data in a database in an easy way.

Learn more

Market data download using MARKET.CSV

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 may create stock and option histories in required time frames.

You may start creating your trading system with a free edition.
You need have SQL skills to use this product.
Also, you must have a platform that supports DDE or RTD.

Learn more

RTD.DB Interface

WEB.CSV

WEB.CSV is command line utility for loading data from any website.

WEB.CSV is a universal parser.
So, you may try to load any data you need.

WEB.CSV supports parsing HTML, XML, JSON, and CSV.

The download package includes a lot of examples.

Learn more

Market data download using MARKET.CSV

DB.RTD

DB.RTD allows creating refreshable models based on database data.

DB.RTD is an awesome product if you already have data in a database and want to consume it in Excel.

You may build refreshable models without pivot tables and macros. You save your time and make models simpler for your colleagues.

Learn more

Open formula example for historical stock prices

Select a product for your needs

WEB.RTDWEB.CSVDB.RTD
Data sourcesFinancial websitesFinancial websitesDatabases
Target applicationExcelDatabasesExcel
UsageExcel RTD formulasConsole app and batch filesExcel RTD formulas
Free edition limitations20 URLs10 rows500 cells
1-year subscription for personal use$24$24$24
1-year subscription for commercial use$49$49$49
Perpetual license for personal use$49$49$49
Perpetual license for commercial use$99$99$99
Learn moreLearn moreLearn more
DownloadDownloadDownload
 
Specialized Products
MARKET.RTDMARKET.CSVRTD.DB
Data sourcesYahoo Finance, Google Finance, MSN MoneyYahoo Finance, Google Finance, MSN MoneyTrading platforms like Thinkorswim
Target applicationExcelDatabasesDatabases
UsageExcel RTD formulasConsole app and batch filesWindows app
QuotesDelayedDelayedReal-time
Stock quotes
Fundamental data
Financial reports
Option chains
Greeks & probabilities
Historical stock prices
Historical option prices
Free edition limitations10 symbols10 symbols10 symbols
1-year subscription for personal use$49$49$49
1-year subscription for commercial use$99$149$199
Perpetual license for personal use$99$99$99
Perpetual license for commercial use$199$299$399
Learn moreLearn moreLearn more
DownloadDownloadDownload