[DATA] Add mic to the database

[PythonPeterr]

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.

[JerBouma]

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.

[PythonPeterr]

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?