Stocks, Options, Currencies

Data from Yahoo Finance, Google Finance, MSN Money

RTD or DDE from trading platforms like Thinkorswim

to Excel, CSV, and databases

One time price. No monthly fee

Products for Traders and Investors

Here you will find a set of products that allows getting data in 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
WEB.RTDFinancial websitesExcelRTD formula
Market.rtdYahoo Finance, Google Finance, MSN MoneyExcelRTD formula
Market.csvYahoo Finance, Google Finance, MSN MoneyDatabasesBatch files
WEB.CSVFinancial websitesDatabasesBatch files
RTD.DBTrading platforms like ThinkorswimDatabasesWindows app
DB.RTDDatabasesExcelRTD 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 parser that allows getting these data in Excel using RTD formulas like

=RTD("market.rtd",,"MsnMoneyQuote","AAPL","High")
=RTD("market.rtd",,"MsnMoneyQuote","AAPL","Low")
=RTD("market.rtd",,"MsnMoneyQuote","AAPL","Last")

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 to your spreadsheets.

WEB.RTD

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

It 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.

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.

This is a specialized parser that downloads data from Yahoo Finance, Google Finance, or MSN Money and creates CSV files for further import to databases.

The product includes a preconfigured Microsoft SQL Server database. So, you may get the data in a database in an easy way.

RTD.DB

RTD.DB allows loading real-time data from trading platforms like Thinkorswim to databases.

It acts for DDE and RTD servers as Microsoft Excel, however, saves data to a database.

You may create stock and option histories in required time frames yourself.

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.

WEB.CSV aka gwebcmd

Market.csv is command line utility for loading market data for stocks, ETFs, indexes, and options to CSV and databases on a daily basis.

It is a universal parser.
So, you may try to load any data that you need.

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

We use the WEB.CSV name instead of the official name, gwebcmd, to address the main purposes better.

The download package includes a lot of examples.

DB.RTD

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

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

The main advantage of the product that you may eliminate intermediary pivot tables in your models.

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

Select a product for your needs

If you have data in one system and want to use it in another one, you definitely have to try to automate your tasks.

You may choose a universal parser or a specialized product. We proud of all of them, and they do their job.
You may try all products for free during 15 days. Also, you may continue with a free edition with some limitations.

We hope you will find an awesome product depend on your needs and skills.

WEB.RTDWEB.CSVDB.RTD
Data sourcesFinancial websitesFinancial websitesDatabases
Target applicationExcelDatabasesExcel
UsageExcel RTD formulasBatch filesExcel RTD formulas
Free edition limitations20 URLs10 rows500 formulas
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
 
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 formulasBatch filesWindows app
QuotesDelayedDelayedReal-time
Stock quotes
Fundamental data
Financial reports
Option chains
Greeks & probabilities
Historical stock prices
Historical option prices
Free edition limitations10 tickers10 tickers10 tickers
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