I have been trying to upload my CSV to yahoo finance, it complains that it’s in the wrong format, but gives absolutely no information about which columns it is expecting. I have spent the morning trying to guess what the column names, data formats etc are but I really cant be bothered anymore. I’ll stick to google sheets for now.
I’ve not done it myself, but Yahoo says the import and export CSV format is the same so you can export a portfolio in Yahoo Finance to understand the columns required to import…
it does say that, but it exports literally everything, volume, 52 week high/low etc which seems kind of irrelevant for importing a portfolio. If I were to through and collect all the data to populate those columns too, then it makes yahoo finance kinda pointless (since that’s the information I would want to get from it).
I can’t even get those to work, have used pandas to re-format all the dates to US, re-format the tickers to yahoos style, renamed all the columns to what you suggested, removed the others, nothing. thanks for the pointers all the same
I think it was the dates after all, got it working with this, just got to convert the USD ones and I should be good. Thanks again for the help
It does seem to completely ignore that I set the portfolio currency to GBP and has kindly decided to represent everything in dollars (without converting it)
It also doesn’t seem to know the difference between GBP and GBX, I’m now over 12000% up, which is nice
I’m also frustrated by WeBull pulling LSE - so looking for a new platform. Im finding Yahoo so full of banners and advertisments its anoying to look at.