Eikon Plugins For Excel
Overview
Welcome to the definitive resource for leveraging the power of Eikon plugins for Excel, designed to enhance productivity and streamline financial analysis. Discover the unparalleled value of integrating Thomson Reuters EIKON with Excel, allowing for seamless data extraction and manipulation using advanced Excel formulas. On this page, we’ll delve into what Eikon is, explore the symbiotic plugins between Eikon and Excel, examine common use cases for these plugins, and answer your frequently asked questions to empower your financial data management and presentation capabilities.
What is Eikon?
Eikon is a versatile software tool designed for financial markets professionals. As a graphical programming tool, it is utilized to create control programs that manage equipment. This can range from controlling single pieces of equipment to handling complex energy management functions. The programming in Eikon is facilitated through the use of microblocks, which are interconnected with graphical wires to build the control programs.
As a service, Eikon is a comprehensive offering from Refinitiv, standing out as an open technology platform that delivers industry-leading data, financial insights, and both exclusive and trusted news. It caters to the needs of its users by providing total data flexibility, simple workflows, and the ability to connect with financial professionals. Eikon is accessible as a standalone application, and it supports usage on both desktop and mobile devices, with the added functionality of Python APIs.
Regarding data, Eikon functions as a robust database, which grants access to a wide array of financial markets data. This includes historical data, worldwide economic data, and company-specific data covering equities, equity indices, fixed income securities, associated indices, commodities, and derivatives. The service also offers comprehensive company fundamentals sourced from Worldscope, as well as economics data, interest rates, and exchange rates. The data in Eikon can be categorized as static or time series, with the latter providing dynamic information such as changes in a company's revenue over time.
Eikon Plugins for Excel Features
Focused on Excel
Eikon for Excel is a suite of add-ins designed primarily for enhancing the functionality of Microsoft Excel. While it also includes some tools for Word and PowerPoint, its main purpose is to improve the user's experience and capabilities within Excel.
Data Retrieval
Users can leverage the Eikon for Excel plugins to fetch data directly from Eikon into Excel, streamlining the data retrieval process. This integration allows for efficient and immediate access to the required financial data within the familiar environment of Excel.
Formula Builder
The included Formula Builder is a powerful tool that aids in the construction of functions for data retrieval. This feature simplifies the process of creating complex functions that can fetch real-time, fundamental, and historical data.
Deal Analytics App
Eikon for Excel provides a specialized Deal Analytics app, which facilitates the retrieval and analysis of deals data directly within Excel. This app is particularly useful for professionals dealing with mergers, acquisitions, and other financial transactions.
Productivity Enhancements
To further enhance productivity, Eikon for Excel includes a set of keyboard shortcuts. These shortcuts enable users to perform common tasks more efficiently, reducing the time spent on repetitive actions.
Common Use Cases
-
Accessing Eikon and Datastream data directly within ExcelE
-
Creating and editing data retrieval functions using the Formula BuilderE
-
Enhancing data presentation in Word and PowerPoint with linkage from ExcelE
-
Utilizing the Deal Analytics app for accessing new datasets and toolsE
-
Activating keyboard shortcuts for efficiency in Excel, Word, and PowerPointE
Frequently Asked Questions
How do I access Eikon or Datastream in data room Q301?
To access Eikon or Datastream, log into a computer marked with Eikon/Datastream in data room Q301.
What should I do if Eikon doesn't open on my first attempt?
If Eikon does not open on the first attempt, close the window and try again. Then, open Excel and sign in through the Thomson Reuters leaflet.
How can I access time series data using the Eikon Excel Plugin?
Time series data can be accessed through the Formula Builder by selecting the time series icon instead of the default real-time data.
What can I do if I receive an error message due to downloading too much data?
If you receive an error message from downloading too much data, adjust the update frequency to be less frequent to resolve this issue.
Where can I find training videos for first-time users of Datastream?
First-time users of Datastream can watch training videos by typing 'training' in the Eikon search window.
Conclusion
The Refinitiv Eikon - Microsoft Office suite enhances the capabilities of Excel, Word, and PowerPoint for financial professionals by offering a wide array of features such as advanced financial functions, charting, data retrieval, and productivity tools like shortcuts and auto-color. With the help of APIs, the automation of data retrieval and processing becomes seamless, and the integration of apps like Deal Analytics and Linking and Presentation Tools provides access to new datasets and efficient connectivity between applications. The inclusion of the Eikon Template Library and the support of the FMC Team further enriches the user experience, enabling users to efficiently create and manage financial models. However, if you're looking to simplify your workflow even further, consider using Sourcetable to import data directly into your spreadsheets, bypassing the need for additional plugins. Sign up for Sourcetable today and streamline your data management in one swift move.
Recommended Excel Plugins
