question

Upvotes
1 0 0 1

refinitiv formula excel generate issue

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?

#productexcel
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hi @gaetano.martinico ,

Could you please provide the screenshot of the issue for better understanding?

1 Answer

· Write an Answer
Upvotes
1 0 0 1

@raksina.samasiri


1718091682584.png

I add a comment in blu, that is the column with the formula filtered
=@RDP.Data(N2,"TR.F.TotDebtPctofTotAssets","SDate=#1 EDate=#2 Period=FY1",,TESTO(Z2-364,"YYYY-MM-DD"),$Z2)
An example of formula, if I copy the formula in the whole column occurs that bug. Several cells take the formula than one cell get a value and than other empty cells and so on in loop within the column. I created the column BA to check wether the cell has a formula or less and filtered to obtain cells with no formula as you can see are a lot. Could it be that the formula provide more than one value? but actually it shouldn't be like this. The fact that provides more than one value could generate an issue?



1718091682584.png (140.6 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.