How can I bring the closing prices of various securities based on their ISIN?

[Fanis G. Markakis]

Hello,

Is it possible to bring the closing price of 31/12/2024 for various securities based only on their ISIN?

Thank you.

[Andrew Sinclair]

Hi,

You can use the instrument identifier conversion formula (provided by Excel Price Feed) to convert an ISIN to a ticker (that is recognized by Yahoo Finance).

For example, this formula: =EPF.ID.ISIN.To.Ticker("US0378331005") will return "APPL" as this is the ISIN for Apple stock.

You then use this ticker with historic close formula: =EPF.Yahoo.Historic.Close("AAPL","31 Dec 2024") which retrieves the close price for 31 Dec 2024.

Please note that the conversion formula is limited to 25 requests per minute. We therefore suggest you use these formulas as an intermediate step in constructing your spreadsheet, i.e. use them to find tickers and then afterwards just use the tickers rather than calling the conversion formulas on each spreadsheet refresh: https://www.excelpricefeed.com/userguide/instrument-code-isin-cusip-conversion-formulas

I hope this helps.

Kind Regards,

Andrew Sinclair

Coderun Technologies Ltd

[Fanis G. Markakis]

This will not function in most of the tested securities. For example:

AT0000A1ZGE4

IE00B4L5YX21

Thank you.

[Fanis G. Markakis]

There is also a matter of wrong values being returned. For example, IE00BKWQ0G16 returns 221 (USD?), when 92.38 EUR is correct. This is not a conversion variance.