Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Datastream /
avatar image
Question by s0568725 · Dec 24, 2021 at 10:12 AM · eikoneikon-data-apidata

How to find the maximum daily bid ask spread (for example for Apple)

Hey guys,


I am completely new in Refinitiv Eikon and I really need your support.

Thank your very much!




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 zoya faberov · Jan 03 at 04:24 PM

Hello @s0568725 ,

If your interest is in how to find the correct field names to request in Datastream ( i.e. 'P', 'PA', 'PB', etc, you may wish to review the detailed documentation on the available Datastream content at http://product.datastream.com/DswsClient/Docs/ and select option 'DATA TYPES', you will be able to browse and search the list of fields that are available and select per your requirements.

To get started with Datastream, in Python, the quickest way should be DSWS Python Tutorial , otherwise, select from the available tutorials in the same section.

Per your requirement, you can request similar to the below via Datastream:

import DatastreamDSWS as DSWS
ds = DSWS.Datastream(username =USERNAME, password=PASSWORD)

df = ds.get_data(tickers='@AAPL', fields=('PA','PB'), start='-10D', end='-0D', freq='D
df

aapl.gif

and next you can arrive at your requirement, for example, for max SPREAD in the result set:

df = df.droplevel('Currency', axis=1).droplevel('Instrument', axis=1)

df['SPREAD'] = df['PA'] - df['PB']

df[df['SPREAD'] == df['SPREAD'].max()]

Resulting in:

maxspread.gif

As you probably are looking for a different date range, a different or additional calculation based on Datastream content, you can obtain use the same approach to arrive at your exact requirement.

I hope this information helps


aapl.gif (14.1 KiB)
maxspread.gif (4.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 Shadab Hussain · Dec 28, 2021 at 09:26 PM

Hi @s0568725 ,

Can you tell me more whether you are using Refinitiv/Eikon Workspace or trying to get data using Eikon Api?

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 >
10 People are following this question.

Related Questions

Financial Data: Liabilities Source from Informal Lenders

Structure Products - Download: Issue Date, Turnover, Strike

Connection problem with DSWS after upgrading to Python 3.9

What is the time when Datastream updates closing price data??

What is the datatype that gives the earnings announcements at Refinitiv Eikon Datastream?

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • 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
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • 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
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges