Getting Started with MARKET.RTD
MARKET.RTD allows loading data from Yahoo Finance and MSN Money into Microsoft Excel spreadsheets.
Here is a pivot table of available data:
| Category | Yahoo Finance | MSN Money |
|---|---|---|
| Quotes | ✓ | ✓ |
| Historical Prices | ✓ | ✓ |
| Intraday Prices | ✓ | ✓ |
| Options Chains | ✓ | ✓ |
| Financials | ✓ | |
| Instruments: | ||
| Stocks | ✓ | ✓ |
| Options (US market only) | ✓ | ✓ |
| Futures (US market only) | ✓ | |
| Indexes | ✓ | ✓ |
| Currencies | ✓ | ✓ |
You can create refreshable models using Excel RTD formulas like this:
The report uses formulas like these:
=RTD("market.rtd",,"YahooFinanceQuotesCSV","AAPL","Open")
=RTD("market.rtd",,"YahooFinanceQuotesCSV","AAPL","High")
=RTD("market.rtd",,"YahooFinanceQuotesCSV","AAPL","Low")
=RTD("market.rtd",,"YahooFinanceQuotesCSV","AAPL","Last")
You can get ready-to-use formulas for any data provider using Formula Builder:
Also, you can find models for different data providers in the Examples folder of the downloaded package.
MARKET.RTD is an easy-to-use product.
Active your trial after setup. Then open examples from the downloaded package to see the common picture.
Then try Formula Builder and create your models.
When your trial period ends, choose an edition.
Also, read Using MARKET.RTD to understand the product features deeply.