isin

Hi All, I'm trying to read the ticker (called F00000LWVH) used on Morningstar on a fund with this query based on an ISIN: Sub MstarTicker() Dim Url As String, XmlHttp As New MSXML2.XmlHttp, PayloadStr As String, RespVar As Variant Url =...

Hello! Need help on how can insert the function ‘isin’ into my excel. I see it is used on a different users excel file. I am finding I need to use this ‘isin.’ I am unable to find much information on how to use ‘isin’ as a formula in excel. Thank you!

I need a XIRR function that would only compute the XIRR for specific ISINs. This is a picture of a sample file with unnecessary info deleted: <tbody> ISIN DATE OF INVESTMENT DATE OF SALE BUY VOLUME SELL VOLUME US7475251036 18.11. 2015 2421 -385,86 US3546131018 3.12. 2015...

Hi all, I have long a list of entities with a unique code, and the countries where they are represented. I want to discard all "GB" and then list all counties per entity in one row. See example. I tried out with arrays but couldn't figure it out. INPUT Desired Output ISIN...

Hi! I am trying to get a path in the online Excel on Google Drive. Basically what i am trying to do is for it to return the ISIN code for a certain company on the London Stock Exchange Website. I am trying to do this for all of them and I am really close but can't seem to find the last part...

Hi, I have a workbook with 3 worksheets. The first (Called "EMT") is a template which holds information in respect of an investment fund (not relevant but it's an EMT template for the new EU MiFID II regulations.) Sheet 2 (Called "ISINs") has a list of Fund ISIN codes (an ISIN code is a...

Hi guys, I'm a bit newbie in VBA but I'm sure that this macro will be straightforward for you guys. I got a basic Excel spreadsheet named "Tester". I just want to check in my bloomberg window named "3-Bloomberg" the ISINs beginning by "XS" or "US" followed by 10 figures/letters. The macro...