I am going bonkers trying to set excel-up as per my requirements. I have attached my excel file here which is Office 365 version. My problem is, in the Summary sheet, under Technical Indicators, each indicator should auto-fill the last result from the Data sheet, which it is not. The rows keep changing based on the period selected in the Time Frame in the summary sheet. But it is not showing. Please help.
Secondly, how do I get to use charts with such varying data, which depends on the Time Period selected in the summary sheet?