I am using excel and I want to ultimately get the closing price of the stocks currently in the AEX, from 2004 to today. I provide the chain RIC (0#.AEX correct?) and then I want to use =RDP.Data($B$3) (0#.AEX is in B3) to get all the stocks in the AEX. And then I would use an adjusted version of the following formula, =@RDP.HistoricalPricing($B$4:$B$510;"TRDPRC_1";"START:"&$B$1&" END:"&$B$2&" SOURCE:RFV INTERVAL:P1D";;"NULL:PREVIOUS TSREPEAT:NO CH:IN RH:Timestamp") this one I used for the S&P 500, in the same manner. But my first formula (=RDP.Data($B$3)) outputs first 5 cells that are not stocks. I only want to get the RICs of the stocks. I found something with "SKIP=1" but then you only skip cell nummer 1 and multiple are not possible (I have not been able to figure it out). Can someone assist?
