from Yahoo Finance and MSN Money
from trading platforms like Thinkorswim
into Microsoft Excel, CSV, and databases
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 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 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")
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.
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.
|Data sources||Yahoo Finance and MSN Money||Yahoo Finance and 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|