Quantitative finance collector
C++ Matlab VBA/Excel Java Mathematica R/Splus Net Code Site Other
Aug 5

Isin Cusip Conversion

Posted by abiao at 21:38 | Code » VBA/Excel | Comments(14) | Reads(49806)
Long time no blog. Just to let you know I am still alive, busy with my own PhD research, collecting & cleaning data, programming, making my hands dirty...

Data massaging is not fun, what makes us more upset is different data providers have their own data format, name, code, etc., matching the data from several sources is not so easy, for example, WRDS includes CUSIP code while Datastream provides ISIN. I didn't understand why they do business like that but now I get it, similar as those cell phone manufacturers have distinct chargers and plug-in, not because it's hard to standardize, but a way to impose customers to use always their own products.

Anyway, you can convert ISIN code to CUSIP easily once you understand the rule, ISIN is a 12-digit number while CUSIP is a 9-digit one (at least the case for US corporate bond), so what you need to do is to first strip off the first 2 characters representing country code and then remove the last digit which is a check digit for catching error.

Suppose your ISIN code is in cell A1, ISIN CUSIP conversion can be done easily in Excel as "=left(right(A1, 10), 9)", for instance, ISIN US885797AB65 equals CUSIP 885797AB6.

As always, I have been looking for guest writers.


Tags: ,
5764429ad64
Thanks !! this saved me !
If you do not have Excel, and want to do an online conversion of ISIN to CUSIP, you can also go to http://sites.google.com/site/isincodestools (ISIN to NSIN convertor) !
Gaurav kumar Email Homepage

Open in new window
http://
gaurav kumar singh
research paper company Email Homepage
I guess that this conversion is giong to be held at research paper company and then it will take some more turns for sure. It's going to get me out of something and then I will ask peple about it too.
I’m happy I located this blog! From time to time, students want to cognitive the keys of productive literary essays composing. Your first-class knowledge about this good post can become a proper basis for such people. nice one! armour games
Awesome web site! I discovered a lot of helpful points that I’ve invested hours and hours searching for on various other web-sites. I would advise it to absolutely everyone.

pixel gun 3d hack
Thanks a lot! You save my life!
This is really great work. Thank you for sharing such a good and useful information here in the blog for students cheap dissertation writing servicehttps://www.affordable-dissertation.co.uk/dissertation-writing-services-uk/
altoconvertpngtopdf Homepage
I am thankful to you for delivering a top quality blog entry here. There's a great deal of helpful data here, and as I am working at altoconvertpngtopdf, I can utilize this information in my papers. That would assist me with outing hugely.
sethyoungphd Homepage
If you need help with your PhD thesis then I would recommend you to contact sethyoungphd. He has helped so many aspiring doctors and I am sure he can do something for you too.
Good to know that. It's so useful for me.
Paket harga jasa SEO tahunan di Seohandal.
Matric Blueprint Homepage
AP Inter 2nd Year Hall Tickets 2020 is expected to release by the 4th week of February. Board of Intermediate Education Andhra Pradesh (BIEAP) is going to release the AP Intermediate II Year Hall Tickets 2020 on the official website which is jnanabhumi.ap.gov.in or bieap.gov.in. However, students can also check the link given below for downloading the hall ticket. In order to download the hall ticket students need to enter the roll number and choose the examination. After obtaining the admit card it is important for students to check the details and if they find any kind of mistake contact the respective authorities. Now if you want to know more information check the content available below
JSC Result 2019 Rajshahi Board Homepage
JSC examinations have successfully wrapped up under Rajshahi Board in Bangladesh. Thousand of aspiring students written the exam from this board and looking for JSC Result 2019 Rajshahi Board. Soon all education boards will publish the JSC exam result at their respective board websites.
Pages: 1/1 First page 1 Final page
Add a comment
Emots
Enable HTML
Enable UBB
Enable Emots
Hidden
Remember
Nickname   Password   Optional
Site URI   Email   [Register]