question

Upvotes
Accepted
64 3 5 7

cash dividends currency

dividends currency. I try to use filed Currency Code to get dividend currency code but I found this is the currency code of this equity trading in exchange.

for example, I got a dividend effect date is 2007-11-28, RIC is IEUT.L cash dividends mount is 42.18 event id 7568221, but the TRTH V2 show currency code is GBp however in TRTH V1 show cash dividends currency is USc. I think the V2 show a wrong currency of this dividends or I use wrong field could you correct me?

tick-history-rest-api
icon clock
10 |1500

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

Upvotes
Accepted
11.3k 25 8 13

Hi @bin

Could you try the "Dividend Currency" field? I have tried the field, but the field shows "EUc" for the example event you provided.

"IdentifierType": "Ric",
"Identifier": "",
"Dividend Rate": 42.18,
"Dividend Currency": "EUc",
"Dividend Ex Date": "2007-11-28",
"Corporate Actions ID": "7568221",
"Corporate Actions Type": "DIV",

I have rechecked the result of V1. It also shows "EUc" in the "Dividend Currency" field. I am not sure if this is the same field you are using. Could you please correct me?


ieutl.png (9.1 KiB)
icon clock
10 |1500

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

Upvotes
64 3 5 7

Hi I cannot access that field , this is locked for me?

icon clock
10 |1500

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

Upvotes
64 3 5 7

Hi I cannot access that field , this is locked for me? it said I need additional permission to access this filed.

7568221,DIV,0,,,,,,,,,,2007-12-24,2007-11-19,2007-11-28,CDI,42.18,here should show Dividend Currency but is empty,IEUT.L,

my request note.

Extraction Services Version 11.0.36705 (cbb5015f7377), Built May 3 2017 16:13:03
Processing started at 2017-05-31 08:20:19.
User ID: 9011977
Extraction ID: 260697825
Schedule: test1Name1222_Schedule (ID = 0x05bd1aa3b2cb2f76)
Reporting corporate actions between 2006-01-01 and 2017-04-27, inclusive.
Suppressing Deleted Events
Input List (1 items): test1Name1222_TInstrumentslist (ID = 05bd1aa312eb2f76) Created: 2017-05-31 08:20:15 Last Modified: 2017-05-31 08:20:17
Schedule Time: 2017-05-31 08:20:18
Report Template (20 fields): test1Name1222_TTemplate (ID = 0x05bd1aa37f1b2f76) Created: 2017-05-31 08:20:17 Last Modified: 2017-05-31 08:20:17
Column 'Dividend Currency' suppressed for lack of 'Non-Tick History Corporate Actions' permission.
Processing completed successfully at 2017-05-31 08:20:20, taking 0.404 Secs.
Extraction finished at 2017-05-31 08:20:20 UTC, with servers: x03A06, DSHA02 (0.0 secs), QSHA02 (0.0 secs), QSHC08 (0.0 secs)
Usage Summary for User 9011977, Client 105984, Template Type Corporate Actions, Standard Events
Base Usage
Instrument Instrument Terms Price
Count Type Subtype Source Source
------- ----------------------------------- ---------------------------- -------------- ----------------------------------------
1 Equities N/A N/A
-------
1 Total instrument charged.
0 Instruments with no reported data.
=======
1 Instrument in the input list.

icon clock
10 |1500

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

Your interpretation is correct, the message "Column 'Dividend Currency' suppressed for lack of 'Non-Tick History Corporate Actions' permission." means your TRTH account is not permissioned for this particular data.

Upvotes
64 3 5 7

If this is correct, then how I use the devidends value?

icon clock
10 |1500

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

@bin

The "Dividend Currency" field should be now available on TRTH. The field has been added to the Tick History 11.1 Data Dictionary document.

Click below to post an Idea Post Idea