Forum Discussion
Solved
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 Techn...
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
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.
VWAP
ADX
OBV
RSI
MACD
These are also the columns that need to be plotted automatically based on the time frame.
PowerLord your excel file is not working properly in formulas, so am not able to arrange it, maybe there are some formulas which are like loops
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
- Chahine,
Charts are still causing a problem. The chart plot data is different for each. For example, for OBV, the chart data is the Close Price, OBV and respective date. I entered this data many times but keeping getting a straight line for Close Price and weird pattern for OBV.