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 COM /
avatar image
Question by christoph.klavers · Jan 07 at 11:14 AM · thomson reuterschartscharts.reuters.comtime series chartthomson reuters eikon

Reuters Eikon COM: Time Series Chart - How to base different stock prices to different dates? when firms started operations at different times

Hello,

I am using Reuters Eikon and I want to plot Time Series Charts. I want to plot the stock prices of different firms starting in 2017 with the base 0. My problem is that only two firms are starting there. Two other firms are starting in 2018 and 2019 but they also use 2017 as a base in order to compare the development of all stock prices, which means they are starting not form zero but another value. How can I set the dates I want to refer to as a base individually? So that the firms which are starting later also start at 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.

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Alex Putkov. · Jan 09 at 01:43 AM

Since you posted this question on a forum dedicated to software developers using Refinitiv APIs I assume you're looking for a programmatic solution. Here's an example using Eikon Data APIs.

# get timeseries of price history for IBM & Airbnb 
df = ek.get_timeseries(['IBM.N','ABNB.O'],['CLOSE'],
                      start_date='2020-11-05',end_date='2021-01-08') 
# backfill missing price history for Airbnb 
df['ABNB.O'].fillna(method='bfill', inplace=True) 
# rebase price history 
df = df/df.iloc[0] - 1 
# display rebasing plot 
ax = df.plot() ax.axhline()


rebasingchart.png (18.3 KiB)
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. · Jan 09 at 01:44 AM

However, if you're asking how to use a chart object (CHT) in Eikon application, when inserting an Indexed Price Performance / Rebasing Analysis in a chart app, one of the Analysis parameters is "Specified Date", which is set separately for each instrument.

Or you may want to consider using Financial Chart app, which does not require specifying rebasing date for each instrument and just starts the plot at zero on the first date available as long as "Normalize dates" option is set to Off.

If you need further help with Eikon apps, please contact Refinitiv Helpdesk using Contact Us capability in your Eikon application. This forum is dedicated to software developers utilizing Refinitiv APIs.


screen-shot-2021-01-08-at-83313-pm.png (202.4 KiB)
screen-shot-2021-01-08-at-83447-pm.png (287.7 KiB)
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.

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