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.
|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 must 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|
|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||✓||✓|
|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|