Instant Functions
Instant functions provide you with End-of-Day (EOD) data instantly in your Excel spreadsheet.
What are Instant Functions?
Instant functions are designed to retrieve End-of-Day (EOD) market data quickly and efficiently. These functions don't require streaming connections and provide reliable historical and current day data.
Available Instant Functions
The instant functions that give you EOD data include:
=Last()Returns the last traded price for a symbol
=Ask()Returns the ask price for a symbol
Quick and Reliable
These instant functions are perfect for building watchlists, portfolios, and analysis sheets that don't require real-time streaming data. They provide fast, reliable EOD data with minimal overhead.
When to Use Instant Functions
- When you need End-of-Day data for analysis
- For building stock screeners and watchlists
- When working with large numbers of symbols (over 300)
- For portfolio tracking and historical analysis
- When you want to minimize data subscription costs