Added here. Feel free to edit: https://github.com/plaintextaccounting/plaintextaccounting/wiki/Looking-up-current-prices-by-ISIN
On Sunday, April 10, 2022 at 5:33:50 PM UTC-7 redst...@gmail.com wrote: > Nice, comprehensive rundown, thank you Pranesh. It would be helpful to > have your post be easily referenced in a place like the plaintextaccounting > wiki > <https://github.com/plaintextaccounting/plaintextaccounting/wiki/About-this-wiki> > > or elsewhere. Would you consider contributing your post to that wiki? > > On Sunday, April 10, 2022 at 12:08:56 PM UTC-7 Pranesh Prakash wrote: > >> On Sunday, 26 July, 2020 at 2:06:50 pm UTC+5:30 Stefano Zacchiroli wrote: >> >>> Does anyone know of a (free) service allowing to lookup current prices >>> by ISIN? >> >> >> I'm not sure if necro-bumping is frowned down upon in this mailing list. >> If so, my apologies. I just came across this and thought I'd share some >> comments, since I didn't see a direct response to this question. >> >> At one point I was trying to do the same: I use ISIN as the commodity >> symbol for all my mutual funds, ETFs, stocks, and bonds, and I was trying >> to automate downloading of prices via an API. >> >> I eventually realized this wasn't quite that simple (though there is a >> script for this, that I've linked to at the end). >> >> A single ISIN can translate into multiple ticker symbols in multiple >> exchanges. An ISIN only identifies the security but not the exchange. The >> same security might be traded in multiple exchanges across different >> countries valued in different currencies and at slightly different prices >> (the price differences wouldn't be too large, else there'd be opportunities >> for arbitrage). (And while there is a standard code for exchanges (called >> MIC, or market identification code), I don't know of many who actually use >> that.) >> >> At one point, I was looking at converting ISIN into ticker symbols from >> the exchange I wanted information from, and then doing the look-up, but I >> realized that if you need to be specifying the exchange, one might as well >> directly get information from the exchange if it provides it. That's what >> I ended up doing with small scripts like, which get information from the >> primary source: >> >> https://github.com/the-solipsist/scripts/blob/master/ledger_get-indian-stock-prices_bse.sh >> >> https://github.com/the-solipsist/scripts/blob/master/ledger_get-indian-mf-prices.sh >> and so on. >> >> There are tools (such as OpenFIGI) to get ticker symbols from ISIN. So >> you could convert from ISIN into the ticker and then use sources like >> Alphavantage or Yahoo Finance. The tool pricehist supports both, and can >> output to beancount format: >> https://gitlab.com/chrisberkhout/pricehist >> >> And there are also sources (such as Morningstar's API) which given an >> ISIN and an exchange, can provide you data. Here's a Github project that >> makes use of Morningstar's API with ISIN: >> https://github.com/LunaticMuch/msdownloader >> >> I hope that helps. >> >> Cheers, >> Pranesh >> > -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails from it, send an email to beancount+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/62c38a40-274a-4f2d-8a39-095120224816n%40googlegroups.com.
