[DATA] Add mic to the database

In my opinion it would be very nice to have a mic_code, or at least a mapping between the current exchange code that is used and the respective "generally accepted" ISO mic_code. If you share the source of this exchange code I can make the mapping.

Hi @Python,

Exchange code comes from a variety of sources but something like Yahoo Finance should use about the same code. Does that work for you?

I believe current exchange codes are also well-known, e.g. LSE, AMS, NYSE.

That is indeed why it would be nice to have a standardised exchange code (MIC) as I suspected it already to come from different sources --> different exchange notations --> difficult to map. If you say it is from yahoo finance I can check if I can map it myself. Moreover, I was curious is it easy for you to add the ISIN column to the ETFs and the Funds tables?

I currently do not have the capacity to work on this which is also why it has taken me so long to respond to your comment. Primary source should be Yahoo Finance but many other platforms follow the same structure. If you can see if you can find a way to map them then please!

ISIN codes are difficult to obtain programatically. At best you could see if something like a LLM tool could help in the initial exploration.