question

Upvotes
Accepted
2 2 2 7

Where do I obtain Open, high, low and bid in End of Day Pricing Data? I have no permissions for PremiumEndOfDayPricingReportTemplate

I am trying to look for Open, High, Low and Close Bid. I found them in PremiumEndOfDayPricingReportTemplate except for Close Bid. But looks like I do not have access to the template.

Also, Could you please tell me where I can find the following?
OTC Quote - Contributed ID, Bid Price, Ask Price and Qualifiers?

tick-history-rest-apipricingderivatives
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.

Upvote
Accepted
11.3k 25 8 13

Yes. For TRTH user, the ElektronTimeSeries report template should be used to obtain end of day data. The PremiumEndOfDayPricing and EndOfDayPricing report template is for DataScope Select only.

For Close Bid, I think it is the "Bid" field in the ElektronTimeSeries report template. According to Data Dictionary - Custom Reporting for Tick History 11.2, the Bid field is instrument’s last bid price for the trading day.

In case that you have the fields for TRTH V1 and want to know which fields and template should be used in V2, you can find this information in the attachment (TRTH_DataFieldDifferences_Jun2017.xlsx) of the Tick History v1 - v2 Comparison document.

Below are the list of OTC Quote fields.

This means that you should get the same information in the "Quote - Exchange/Contributor ID", "Quote - Bid Price", "Quote - Ask Price" and "Quote - Qualifiers" fields of the TickHistoryTimeandSales report template.


otcquote.png (15.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.

Hi Veerapath

Thanks a lot for sharing the links. Saved me a lot of time.

Upvotes
2 2 2 7

Open, High, Low- Found them in ElektronTimeseries. Am I right? But I couldn't find Close Bid

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
2 2 2 7

@veerapath.rungruengrayubkul

I see the below in the pdf:

Difference 1: End of Day (from Real Time)

AFFECTED AREAS: Customized Extractions, Venue by Day

DESCRIPTION: This format is not supported. Datascope Select Timeseries Pricing reports have the entire breadth and depth of DataScope and Eikon.

SOLUTION: To retrieve end of day content, use the Timeseries Pricing report

So, currently I am using V1 End of Day from Real Time and End of Day, to get Open, High, Low, Last and Open, High, Low, Bid respectively.

I was not able to find the differences in the excel. I got the details of Open , High , Low , Bid from ETS (Electron Time Series). Could you please guide me on how to get them?

End of Day (from real time)

V1 -> V2

Open -> ETS.Open

High -> ETS.High

Low-> ETS.Low

Last-> ETS.Last

End of Day

Open -> ETS.Open

High-> ETS.High

Low-> ETS.Low

Bid-> ETS.Bid?


Also, Is End of Day from real time and End of Day are same data? And both are the same under V2 ETS?

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
262 8 9 15

ets-fields.png and ETS.pngets.png

Hi San
To provide background on the difference between v1 and v2 End of day data:

In TRTHv1, we have End of Day (Real-time) and End of Day (Verified). However, in TRTHv2 we have only one End of Day pricing template which is Elektron Time Series (Verified data) and is already available on TRTHv2 for clients under Pricing Data templates: "Elektron Time Series report template"

With respect to fields in question on EOD data, please refer to screenshot "ETS fields".

Regards,
Beera


ets.png (46.1 KiB)
ets-fields.png (55.5 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.

Click below to post an Idea Post Idea