arketView ExcelTools Features and Advantages
There are many vendors who can provide access to real-time and historical data. Only ExcelTools offers these unique features and advantages:
- ExcelTools is a standalone component (it does NOT require an active workstation connection or subscription.)
- ExcelTools uses a clean, easy-to-use interface that streamlines the way you request quotes or historical data.
- Your workflow is simplified, as queries are automatically updated with new data.
- Optionally Insert static data on a historical query.
- A "Symbol Tree" lets you navigate exchanges quickly to find the categories and symbols you want, and even "remembers" your last symbol search so you won't have to!
- Access your User-Defined Formulas that were created in MarketView.
- Access Independent System Operator (ISO) electricity/power data.
- ExcelTools offers one-click capabilities, automatically converts all symbol inputs to capital letters (for spreadsheet consistency and accuracy), and supports drag-and-drop between cells.
- New software upgrades happen seamlessly in the background when you open Excel.
- Uses the newer, more robust RTD (vs DDE) to stream real-time data. This translates into faster and more reliable updates to your data.
- You can easily format any individual cell using the symbol and Field Name of choice, including but not limited to Last, Open, High, Low, Volume, and Open Interest.
- ExcelTools supports multiple historical time-series queries, including intraday, daily, weekly, monthly, and seasonal.