Query individual courses
Security.current
[pricetype;date]→paymentwithtime
Course type (Course type[Close]): The close rate is requested by default; if this is not available, the spot rate is requested. If the corresponding setting is selected in the global options, missing courses can then be supplemented with valuation courses.
Date (Date[Current date]): Default is the current date. If there are no prices in the database on the current date, the most up-to-date price possible is supplied (up to eight days before the date).
Result: The Current
function returns the price for <course type> at (before)<date>. The time value provides the date of the price found. Capital measures and dividends are not offset.
Security.close_price→payment_with_time
Result: The Close_Price
function returns the same result as Current
, but with the predefined price type "Close".
Security_first_price
[price_type]→payment_with_time
Course type (course type).
Result: The First_price
function returns the price and date of the first price available for this security. Capital measures and dividends are not offset.
Security.high_price→payment_with_time
Result: The function High_Price
returns the same result as Current
, but with the predefined price type "High".
Security.spot_price→payment_with_time
Result: The function Kassa_Kurs
returns the same result as Aktuell
, but with the predefined exchange rate type "High".
Security_contract_price→payment_with_time
Result: The function Kontrakt_Kurs
returns the same result as Aktuell
, but with the predefined price type "Kontrakt".
Security.price
[date;pricetype]→paymentwithtime
Date (Date[Current date]).
Course type (Course type[Close]): The close rate is requested by default; if this is not available, the spot rate is requested. If the corresponding setting is selected in the global options, missing courses can then be supplemented with valuation courses.
Result: The Course
function returns the same result as Current
, but no time tolerance is provided if the<date>is explicitly specified.
Security_price_tol
[price_type;date]→payment_with_time
Course type (Course type[Close]): The close rate is requested by default; if this is not available, the spot rate is requested. If the corresponding setting is selected in the global options, missing courses can then be supplemented with valuation courses.
Date (Date[Current date]): Default is the current date. If there are no prices in the database on the current date, the most up-to-date price possible is supplied (up to eight days before the date).
Result: The function Kurs_Tol
returns the rate for<Kurstyp>at (before)<Datum>. The time value provides the date of the price found. Capital measures and dividends are not offset.
Security.last_price
[price_type]→payment_with_time
Course type (course type).
Result: The Last_price
function returns the price and date of the most recent price available for this security. Capital measures and dividends are not offset.
Security.low_price→payment_with_time
Result: The Low_Price
function returns the same result as Current
, but with the predefined price type "Low".
Security.OI_Price→PaymentwithTime
Result: The OI_Kurs
function returns the same result as Aktuell
, but with the predefined price type "Open Interest".
Security.open_price→payment_with_time
Result: The Open_Course
function returns the same result as Current
, but with the predefined course type "Open".
Security_volume_price→payment_with_time
Result: The Volume_Price
function returns the same result as Current
, but with the predefined price type "Volume".