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 sinan_islam · Oct 08, 2020 at 06:19 PM · eikoneikon-data-apieikon-com-apieikon-for-officepandas

Streaming Data From Eikon Excel To Python

Hello,

I am trying to read price data from Eikon Excel to Python Pandas DataFrame during real time updates.

The issue is that Eikon Excel does not save streaming data in real time, while Python can only read saved excel files. I tried to use an Excel macro to automatically save the file during real time updates, but unfortunately, it crashes Eikon Excel addon. It seems that the two events (macro save and Eikon updates) cannot run at the same time.

Is there a way to stream price data from Eikon Excel to Python without saving the Excel file?

PS.: I am using MetaStock subscription, thats why I cant read directly from your Data Feed API using Python.

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.1 · Oct 08, 2020 at 09:30 PM

You could try using xlwings to transfer data from Excel to Python. I can't say I have much experience with using xlwings to transfer frequently updating data from Excel to Python.

On a separate note Refinitiv Developer Portal is probably not the best place for a question that essentially aims to circumvent Refinitiv commercial policy, that deems programmatic access to Refinitiv data a premium feature and only makes it available in products that are significantly more expensive than Metastock Xenith.

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 sinan_islam · Oct 08, 2020 at 09:53 PM

Thanks for your reply!

I will check the python addon.

On a separate note, I didnt know that trying to access excel data from Python is considered an act of fraud and deception. Too bad alot of analysts do that everyday. They should listen to your great advice.

Refinitiv is very expensive and I dont need 99% of its features. So why would I buy it?

Why are you imposing a huge fee just to access a data feed? Exploitation? or perhaps bad marketing?

Learn to segment your product line better, before accusing anyone!

Comment

People who like this

0 Show 3 · 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.1 ♦♦ · Oct 09, 2020 at 01:07 AM 0
Share

@sinan_islam
There's nothing wrong with using product capabilities and extending them for your personal use. It's not an act of fraud to transfer data from Excel to Python, as long as Refinitiv data remains for your individual use only. I don't know how you got that from my response, but please accept my apologies if you felt you were being accused of anything.
It's perfectly natural for a consumer to want to have premium features at the lowest price, just as much as it's natural for a vendor to want to sell its products at the highest price. There's nothing wrong with extending the capabilities of the vendor's low end product, even when this extension aims to replicate features the vendor reserved for its higher end products. It just strikes me as odd to ask the vendor for an advice on how to best implement such an extension. I would find it similarly odd if someone was asking Microsoft for an advice on how to implement an Excel add-on for an old version of Office that replicates a feature introduced in the latest version of Excel because that someone doesn't want to pay for an upgrade. Perhaps it's only me who finds it odd.

avatar image
REFINITIV
wasin.w ♦♦ · Oct 09, 2020 at 03:36 AM 0
Share

Hello @sinan_islam

If you are interested to use xlwings to export your data to excel, please refer to Financial Reporting with Eikon and Excel article.

Hope this help.

avatar image
sinan_islam wasin.w ♦♦ · Oct 09, 2020 at 12:48 PM 0
Share

Thanks for trying to help me! But this does not work, because Mr. Alex Putkov contradicts himself in another post by saying that MetaStock users are not allowed to access Refinitiv Data Feed API.

https://community.developers.refinitiv.com/answers/46143/view.html

Following the sample code you provided, I keep getting the error "Port number was not identified", and the file named PortInUse does not exist under AppData Thomson directory. It is probably because I dont want to pay for an upgrade to a product that I will not use.

That said, people should purchase stuff they do not need. I find it odd that people do not want to pay for products they do not wish to use. Perhaps it's only me who finds it odd.

Unfortunately, the data feed for the market I trade is monopolized, so I do not have lots of options for alternatives.

I will deal with it. Thanks anyway.

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

Related Questions

how can I get parent ric for 'derrived' rics?

Can I send a message programmatically through Eikon messenger

Getting "ThomsonReuters.Desktop.SDK.DataAccess.TinyIoCResolutionException" in C# ConsoleApp but not WPF

ThomsonReuters.Desktop.SDK.DataAccess.dll Location

MS Office Excel 365 - API - AdfinX Real Time 6.0 Library for Windows 10

  • 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