Imported from previous forum
[ original email was from Ambar Arasan - Ambar.Arasan@rbccm.com ]
Could anyone please provide a Reuters to MIC exchange code mapping? I found an online resource from ONIX but its not the latest and few values were missing.
Thank you
Ambar
hey Ambar
Maybe I can help you and the community 
I have had the same issue for a long time whilst introducing SOR and MiFID changes. I’ve put together a list of US and Canadian alternative execution venue as supported by UBS IB. Can’t attach files in this forum (hint) so you can download the xls here
http://jmoola.com/downloads/20100303_MIC_RIC_US-Canada.xls
The normal agreement is that if an ECN/ATS doesn’t have a MIC code, you use the RIC. For European alternative venues, most are MTFs (so have known MIC/RIC)
Let me know if this helps
Jonathan