I am trying to retrieve data for a list of ticker and date in excel, the formula for the single cell work well, example of formula

=@RDP.Data(N1782,"TR.CGBoardSize","SDate=#1 EDate=#2 Period=FY1",,TESTO(Z1782-364,"YYYY-MM-DD"),$Z1782)

When I copy and paste the formula in the other cells the formula is correctlycopied for several cells, but for others it seems like the formula interrupt, then there is a cell with just a value and then a gap of empty cells to restart with another cell with formula, after several cell another cell with value and a pool of empty cells, and so on. If i copy and paste the formula in the empty cells, the data is retrived but other cells (not all) with values update losing their values. It is a loop almost endless to fill a whole column of data. What could be the issue?