How to create a Dynamic STOCK CHART in Excel (StockHistory Function)
I am using the features in Excel 365 which are Dynamic Array (DA) and StockHistory. If your license is not Microsoft Office 365, these features may not be available to your version of Excel.
Combining these new features we can create a dynamic chart using stock data types. You can use this to create charts to any Stock just by using the "ticker symbol". The process in this video can also be used to create dynamic charts in any datasets that has a time series just like sales over time (YTD, Past Months).
**********************************************
If you company is looking for an Excel or Power BI Online and Live courses please visit
https://pivotviz.com/private-group-tr...
Email: [email protected]
Sample Power BI Reports : https://pivotviz.com/power-bi-reports
**********************************************
excel | tagalog | powerbi | dashboarding in excel | dynamic array | stock data type | stockhistory