Getting Started with Market RTD
Market RTD enables you to load data from Yahoo Finance and MSN Money directly into Microsoft Excel spreadsheets.
Here is a summary of the 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 these:
The report uses formulas such as:
=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 generate ready-to-use formulas for any data provider using the Formula Builder:
Additionally, you can find models for different data providers in the Examples folder of the downloaded package.
Market RTD is user-friendly.
Activate your trial after setup. Then, open examples from the downloaded package to familiarize yourself with common use cases.
Next, try the Formula Builder to create your own models.
When your trial period ends, choose an edition that suits your needs.
For a deeper understanding of the product features, read Using Market RTD.