Nov 12 2020 09:27 PM
Hi all.
I am trying to benchmark my stock portfolio in excel using the data types feature. I am wanting to create a chart that updates daily, collecting data automatically from the data types feature. I'm not sure if this makes sense..
Thanks
Josh
Nov 13 2020 02:35 AM
With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture.
*Knowledge of Excel version and the operating system is a must have if you want to proposing a reasonable solution (Example: office version e.g. 2016 or 2019 or 365 web or 365 pro, etc) and your operating system (e.g. Win10 (2004), Win 10 (1903), Mac, etc.).
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Nov 13 2020 03:10 AM
If you'd like to keep historical data there is STOCKHISTORY function , but so far only for insiders. STOCK data type returns current and related data, if collect them that perhaps VBA solution.