Forum Discussion
Trouble with Getting Data using Indirect from varying rows
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, Windows 10. My problems are:
1.) 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.
2.) I am unable to Forecast as I get an error saying the date is inconsistent but the dates are those when the Stock Markets were on.
3.) I want the charts to be plotted based on the time frames entered in the summary sheet.
Thanks a million.
There was some issue with links, so i turned it off
and it worked
so i did this dynamic charts, using sequence which uses ur first & last date in time frame & index & indirect, have a look at the sheet charts
in summary, i used just index, & last date from your time frame
7 Replies
- can you provide more details, exactly which columns you need to extract from data sheet to summary, & which columns you need for plot, can you make a small sample so we can help
- Hi Chahine! Thanks for responding fast. I need to extract from these columns in the data sheet to summary sheet (their names are the same):
VWAP
ADX
OBV
RSI
MACD
These are also the columns that need to be plotted automatically based on the time frame.
