ADDRESS to return a text representation of a cell address based on the row, column,

[graemeal]

I have this spreadsheet where I use the below formula to save many, many hours of work. In row 7 is a list of codes that trade on the stock market such as ANZ, BHP, RIO etc. The below formula picks up the code from row 7 and saves me adding a different stock market company code to each formula over say 2000 rows.

=RTD("phoenixai.quotes","","VOLUME",INDIRECT(ADDRESS(ROW(),7)))

The charting package that supplies me the link to RTD data has now ceased to exist so I have to use a new data supplier.
The new below code is as follows:

=RTD("paritechpulse.rtd", "", "security", "ANZ", "Volume")

Is there a way to add the Row 7 to the above formula?

Thanks

 

[etaf]

that adds whatever is in $G$? cell to the formula , indirect allows the contents of that cell to be used in the RTD formula
So it uses what ever you have in the rows , the formula is in
i'm assuming
=RTD("paritechpulse.rtd", "", "security", "ANZ", "Volume",INDIRECT(ADDRESS(ROW(),7)))
does not work - what error are you getting