from Yahoo Finance, Google Finance, and MSN Money
from trading platforms like Thinkorswim and TWS
into Microsoft Excel, CSV, Microsoft SQL Server and MySQL
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.
|MARKET.RTD||Yahoo Finance, Google Finance, and MSN Money||Excel||RTD formula|
|MARKET.CSV||Yahoo Finance, Google Finance, and MSN Money||Databases||Console app|
|WEB.RTD||Financial websites||Excel||RTD formula|
|WEB.CSV||Financial websites||Databases||Console app|
|RTD.DB||Trading platforms like Thinkorswim or TWS||Databases||Windows app|
|DB.RTD||Databases like Microsoft SQL Server or MySQL||Excel||RTD formula|
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")
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.
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.
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.
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.
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.
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.
|Data sources||Financial websites||Financial websites||Databases|
|Usage||Excel RTD formulas||Console app and batch files||Excel RTD formulas|
|Free edition limitations||20 URLs||10 rows||500 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 more||Learn more||Learn more|
|Data sources||Yahoo Finance, Google Finance, MSN Money||Yahoo Finance, Google Finance, MSN Money||Trading platforms like Thinkorswim|
|Usage||Excel RTD formulas||Console app and batch files||Windows app|
|Greeks & probabilities||✓|
|Historical stock prices||✓||✓||✓|
|Historical option prices||✓||✓|
|Free edition limitations||10 symbols||10 symbols||10 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 more||Learn more||Learn more|