Open Paruccone opened 6 months ago
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.
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 https://github.com/JerBouma/FinanceDatabase/issues/78#issuecomment-2067949994, or unsubscribe https://github.com/notifications/unsubscribe-auth/AXV6V27AK355QDQBJMIWD4LY6NXGDAVCNFSM6AAAAABFNT6LZGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANRXHE2DSOJZGQ . You are receiving this because you are subscribed to this thread.Message ID: @.***>
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 :