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?
64
●3 ●9 ●11
cash dividends currency
Thank you for your participation in the forum.
Is the reply below satisfactory in resolving your query? If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
-AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
11.3k
●25 ●9 ●14
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?
64
●3 ●9 ●11
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.
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.
The client has also raised this issue in the case: 05554027. The issue currently is investigated by the TRTH Upgrade Specialists team.
64
●3 ●9 ●11
If this is correct, then how I use the devidends value?
The "Dividend Currency" field should be now available on TRTH. The field has been added to the Tick History 11.1 Data Dictionary document.
