Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
Question by handrew11 · Apr 03, 2019 at 03:22 AM · eikon apiget_timeseries

Trying to get .GDAXI history, but Eikon only returning the last data point?

>>> start = datetime.datetime(1850, 1, 1) 
>>> end = datetime.datetime.now() 
>>> ek.get_timeseries(".GDAXI", interval="monthly", start_date=start, end_date=end)
.GDAXI HIGH CLOSE LOW OPEN COUNT
Date 2019-03-31 11823.29 11526.04 11299.8 11584.24 -1.0 >>>

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

4 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Alex Putkov. · Apr 03, 2019 at 04:31 PM

@handrew11
The behavior you experienced is unexpected. Since it is specific to your Eikon account, as I cannot reproduce it on my end, the only way we can investigate it is by opening a ticket with Refinitiv Helpdesk and working together in direct contact with you. I would happily open a ticket on your behalf, however you chose to register on this portal with a personal rather than a business email address, which effectively makes you anonymous on these forums.
For this reason you need to reach out to Refinitiv Helpdesk yourself and open a support case. Refinitiv Helpdesk can be reached by either calling the Helpdesk phone number in your country or by using Contact Us capability in your Eikon application.

Comment

People who like this

0 Show 2 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
handrew11 · Apr 03, 2019 at 04:35 PM 0
Share

Hi @Alex Putkov. thank you for response. I would love if you could open a ticket for me. My email address on this forum is also the one associated with my Eikon account, so you can go ahead and use that one. Thanks!

avatar image
REFINITIV
Alex Putkov. ♦♦ handrew11 · Apr 03, 2019 at 05:13 PM 0
Share

@handrew11
Sure, no problem. I was able to locate you in Eikon user database and opened support ticket on your behalf. Refinitiv Helpdesk will reach out to you to investigate the issue. Just in case you need a reference to communicate with the Helpdesk, your support case number is 07504050.

avatar image
REFINITIV
Answer by jason.ramchandani · Apr 03, 2019 at 08:07 AM

Hi @handrew11: The reason its failing is that you are trying to pass a datetime to a function that is expecting a string - see correct code below:

start = str(datetime.datetime(1850, 1, 1).date())
end = str(datetime.datetime.now().date())
print(start, " ", end)
df2 = ek.get_timeseries(".GDAXI", interval="monthly", start_date=start, end_date=end)
df2
Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by Alex Putkov. · Apr 03, 2019 at 11:13 AM

One should be able to use datetime for start_date and end_date arguments of get_timeseries method. I have no problem executing the code snippet @handrew11 provided, and I retrieve full timeseries going back to 1987.
@handrew11, I suggest you use Fiddler to capture the HTTP request going on the wire. Alternatively you may enable logging in eikon library as follows

ek.set_log_path(r'C:\Temp')
ek.set_log_level(10)
The log file name will be pyeikon.%Y%m%d.%H-%M-%S.log
After you started Fiddler or enabled logging in eikon library reproduce the issue and see the request captured in Fiddler or in the log file.
The request going on the wire should be
{'Entity': {'E': 'TimeSeries', 'W': {'rics': ['.GDAXI'], 'fields': ['*'], 'interval': 'monthly', 'startdate': '1850-01-01T00:00:00', 'enddate': '2019-04-03T11:04:51.059467'}}} 
Is this what you get? Or is the request generated on your end different?
Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Answer by handrew11 · Apr 03, 2019 at 12:17 PM

@Alex Putkov.

The log said:

2019-04-03 09:19:42,118 -- pyeikon -- DEBUG -- Request:{'Entity': {'E': 'TimeSeries', 'W': {'rics': ['.GDAXI'], 'fields': ['*'], 'interval': 'monthly', 'startdate': '1850-01-01T00:00:00', 'enddate': '2019-04-03T00:00:00'}}}

I re-ran the code that both you and Jason gave and I am still only getting one month of data. This doesn't happen for other codes, like '.SPX'.

Does it have to do with my permissions?

Comment

People who like this

0 Show 5 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Alex Putkov. ♦♦ · Apr 03, 2019 at 12:50 PM 0
Share

The request looks correct and I don't think the problem is due to your entitlements. Could you also post the response to the request as it appears in the log file you created?

avatar image
handrew11 Alex Putkov. ♦♦ · Apr 03, 2019 at 01:00 PM 0
Share
2019-04-03 09:19:42,266 -- pyeikon -- DEBUG -- HTTP Response code: 200 
2019-04-03 09:19:42,266 -- pyeikon -- DEBUG -- HTTP Response: {"timeseriesData":[{"dataPoints":[["2019-03-31T00:00:00Z",11823.29,11526.04,11299.8,11584.24,-1]],"fields":[{"name":"TIMESTAMP","type":"DateTime"},{"name":"HIGH","type":"Double"},{"name":"CLOSE","type":"Double"},{"name":"LOW","type":"Double"},{"name":"OPEN","type":"Double"},{"name":"COUNT","type":"Long"}],"ric":".GDAXI","statusCode":"Normal"}]} 
avatar image
handrew11 handrew11 · Apr 03, 2019 at 02:23 PM 0
Share

any idea @Alex Putkov.? I also tried with a different app key and still had the same problem. I'm on a Mac using Python 3.7 with the latest version of Eikon too. I think also .FTSEMIB has the same problem

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
9 People are following this question.

Related Questions

1. get_timeseries cuts off historic data 2. get_data not working for all tickers

Data error when using get_timeseries()

HTTPError suddenly appears, but I am using the same codes I did only yesterday?

How to sort an ek.get_data request by instrument and fiscal period (absolute)?

get_date_from_today not defined

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges