QuoteLive

 

Syntax: QUOTELIVE(Ticker, Fields, RefreshRate)

 

Equivalent Function Names: QL

 

Purpose: The function displays the live data for a given ticker, e.g. MSFT.

 

Parameters: 
 

1.Ticker(s) is the Yahoo ticker(s) or Currency Pair. If more than one ticker is given, the formula needs to be entered as a Range Formula.
 

2.Field(s) may be optional for a given operation. If not specified, Spearian shows the current price. The list of fields is equivalent to the fields for retrieving current data of the Quote function.
 

3.RefreshRate = the number of seconds before the field is refreshed. Default value = 15 secs.

 

 

NOTE: For some tickers, there is neither real time nor current data provided, though the historical data may be provided. Thus, if the real time function returns an N/A, try to retrieve the last year of history.

 

Examples:

1. Retrieve live data of the FTSE index

=QL("^FTSE") returns the live value of the FTSE index.

 

 

 

2. Retrieve current exchange rate using Yahoo!

=QL("y::usdeur=x")

 

 

 

 

3. Retrieve current exchange rate using Open Exchange Rates

=QL("usdeur")

 

 

 

4. Retrieve in bulk current live prices

=QL(A1:A4)

 

 

 

Copyright © 2013-2017 Jiri Pik

Document Version: Sunday, May 7, 2017