[DATA] How can we contribute ISIN codes ?

[Paruccone]

Hi,

you mention you'd like us to contribute with ISIN codes but how to add them? We could theoretically add a column but problem is that a single ticker can have multiple ISINs so that would create multiple columns or duplicate rows of the same ticker with different ISINs.

Thanks for your work!

PS: don't know if that can be relevant but I have an Excel file that, through powerquery, given a ticker, downloads all the historical values from yahoo finance. Problem is that now if the number of rows (tickers) changes, the query requires updating. I'm working on making it work on an array (to have it work no matter how many tickers, as any ticker is an iteration of the same cycle querying yahoo finance). The mix of your DB and this could create a very nice DB !

PPS: if you want to explore yourself here's the syntax:
https://query1.finance.yahoo.com/v7/finance/download/"&Ticker&"?period1=1214956800&period2=20037888000 where :

• "&Ticker&" is the ticker (who would have guessed?!)
• period1= start date in UNIX format
• period2= end date in UNIX format
  this will return a nice csv file with the following columns:
• Date
• Open
• High
• Low
• Close
• Adj Close
• Volume
• Ticker

[JerBouma]

Hi!

Companies always have one ISIN attached to them but you have multiple tickers that link to the same ISIN. For the most part what I am looking for is manual search (or programmatically if you can) and adding that information to the CSV files. I've made it relatively easy to edit those files on purpose.

Related to your Excel file, I also have an entire package titled the Finance Toolkit (https://github.com/JerBouma/FinanceToolkit) that does this and much more. I have also excluded the time-dependent data fields from the Finance Database given that I want it to maintain relevance for as long as possible.

[ReginaldAboagye]

Thank you JerBouma I would look it up and give you feedback

…

On Sun, Apr 21, 2024, 08:03 Jeroen Bouma ***@***.***> wrote: Hi! Companies always have one ISIN attached to them but you have multiple tickers that link to the same ISIN. For the most part what I am looking for is manual search (or programmatically if you can) and adding that information to the CSV files. I've made it relatively easy to edit those files on purpose. Related to your Excel file, I also have an entire package titled the Finance Toolkit (https://github.com/JerBouma?tab=repositories) that does this and much more. I have also excluded the time-dependent data fields from the Finance Database given that I want it to maintain relevance for as long as possible. — Reply to this email directly, view it on GitHub <#78 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AXV6V27AK355QDQBJMIWD4LY6NXGDAVCNFSM6AAAAABFNT6LZGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANRXHE2DSOJZGQ> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>