Jul 11 2020 08:43 AM
I've made an excel document for my portfolio and for following various shares
it's fairly easy - but I miss one thing - that I know can be made i google
I would like to integrate a chart-line for the last 90 days in a column for each share
can anyone tell me how to do it - and from where I can fetch the chart
Jul 11 2020 10:02 AM
@tinke10 Looks like you need the new STOCKHISTORY function.
Announcing STOCKHISTORY - Microsoft Tech Community - 1404338
If you are the lucky 50% in the Beta channel, that is.
Disclaimer
STOCKHISTORY is currently available to 50% of Microsoft 365 Subscribers in the Beta level of the Office Insider program. The behavior and signature of this function is subject to change. Releasing this way allows us to get early feedback to prepare for a broader release. This function will only be available to Microsoft 365 customers who are signed in.
Jul 11 2020 10:09 AM
@tinke10 Hello Friend,
Firstly try attaching the file in English Language.
Secondly I think you want a chart line of past 90 days.
You can integrate this but for that please find the website where the shares History is maintained and from there using Webquery you can Import any data
If you want to get this done you contact me privately therein I will give you My mail Id and then we can connect through mail and solve your query.
Thanks & Regards,
Devendra Jain