Forum Discussion
I want to make a stock portfolio, with live updated key figures, prices and graphs
Hello, I am in dire need of help. I'm trying to make a detailed stock overview, as mentioned in the title. For that, I'm looking for data that can be updated automatically, as the possibilities...
It would be a lot easier to offer specific help if you uploaded a copy of your actual workbook/spreadsheets. Images help a little, but one can't actually DO anything with them other than look at them.
That said, if general advice is all you need, I suggest you familiarize yourself with functions like:
XLOOKUP
INDEX and MATCH used together
VLOOKUP
Here's a website that might help if you're comfortable doing your own research. https://exceljet.net