refinitiv in excel

itkachivska

hi,


I have created a formula for the last trade prices, but I can't make the interval show in seconds instead of minutes. Is there any way to do this?
=@RHistory($A$2:$A$15,"TRDPRC_1.Timestamp;TRDPRC_1.Close;TRDPRC_1.Open","START:"&$C$3&" END:"&$D$3&" CODE:SEDOL INTERVAL:1M",,"TSREPEAT:NO CH:IN;Fd",D8)

jason.ramchandani01

@itkachivska Thanks for your question - this is a forum for programmatic usage of APIs - it seems you have an in-product question - does this work for you?

=@TR("BQB5MV0","CF_LAST")

You can also use the formula builder app in Excel which can automatically build the formula for you if you put in some certain instrument, fields and parameters - all the guidance is provided by the app itself. If you need more support for in product queries - please click the Contact Us menu item (under Helios menu in Eikon) or Get Help & Support menu item (under ? menu in Workspace) to open a ticket.

I hope this can help.

[Deleted User]

Hi @itkachivska, have you had a look at the training online, or the articles on the Developer Portal? If these are insuficient, would you mind letting us know (i) which version or Workspace Excel or Eikon Excel you are using and (ii) an example SEDOL for an instrument you are interested in, and (iii) what CD & PD stand for?