question

Upvotes
Accepted
1 1 1 2

=TR(arg, arg)

Where can I find all the required arguments for this function

alpha
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.

Upvotes
Accepted
47.5k 113 44 60

Do you mean TR function in Eikon Excel?

If yes, you can use Formula Builder in Eikon Excel to build the formula for the TR function, as shown below.

Otherwise, you can access Online Help in Eikon Excel for more information.


tr.png (57.1 KiB)
trhelp.png (43.0 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.

Upvotes
1 1 1 2

Thanks, I am aware of this, but is there a general instruction/manual how these arguments work?; so the function starts with =TR(RIC, Field, "Arguments", destination cell); I like to work with own-defined cell reference names, but do not know which arguments are available, will work etc. Do you have a clue how to find out? (Row Head, Column Head, Start Date, End Date, Frequency, Transpose, Currency, Interval, etc)

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.

There is the TR Parameters section in the Online Help which explains the arguments, such as CH, RH, and Transpose. Moreover, you can also find other arguments in the TR Function, Time Series Data with the TR Function, and Volatility Surface with the TR Function sections.

Otherwise, you can contact Eikon Excel support team for more information.