Miscellaneous prices

Using get_data i get the PriceClose data from some but i need to use other field to get the NAV of a OEF.

Is there any (single) way to get the last price of any kind of instrument?

Best Answer

  • If you find a RIC that shows NAV in the close price field, you can use the CF_CLOSE field

Answers

  • I know but i'm looking for a command to call the last known price of any kind of instrument. I'm handling a portfolio with many types of papers and it would make my life much easier to use only one command to download all the prices.

  • @pchauveau

    You can directly contact the Eikon support via Get Support and ask for an excel formula (TR function) used to retrieve the required information. If it is available, you can use the same parameters with get_data to retrieve the data via Eikon Data API.

  • Hi @pchauveau

    As @Zhenya Kovalyov said, the closest you could get is using the Common Field.

    CF_ASK
    CF_BID
    CF_CLOSE
    CF_DATE
    CF_EXCHNG
    CF_HIGH
    CF_LAST
    CF_LOTSIZE
    CF_LOW
    CF_NETCHNG
    CF_OPEN
    CF_SOURCE
    CF_TICK
    CF_TIME
    CF_VOLUME
    CF_YIELD

    image

    All these fields represent the particular value of bid, ask, close, last price etc., but in the unified version, regardless of the type of the instrument.

    CF_LAST should cover the last known price.