What is MarketView?

MarketView is a unified data management platform created by Drillinginfo, designed specifically for energy and commodity companies. This software tool offers a suite of industry-leading solutions that support critical business, risk management, and trading decisions. It is a SaaS-based architecture with internet access that provides companies with the ability to access, analyze, and deliver information through real-time, historical, and proprietary data. MarketView manages thousands of public and proprietary data sets, presenting them in a single common view of evolving markets, which includes front-end analytics and data integration.

Additionally, MarketView is a service provided by LexisNexis for life sciences, providers, pharmacies, healthcare IT, and payer organizations. It is a medical claims-based intelligence service that transforms various business operations by offering insights based on patient data. The service includes MarketView Patient Journey Intelligence, a new service that provides de-identified medical claims data on over 300 million unique patient tokens, aiding businesses in understanding patient outcomes over time.

As a data management platform, MarketView is used by large energy and commodity companies to streamline the collection, analysis, and integration of energy and commodity market data. MarketView is tailored to serve the needs of traders, risk managers, IT professionals, analysts, and executives, offering solutions that cater to the entire spectrum from front to back office. It provides a clear and intuitive interface on desktop, mobile, and Excel tools, ensuring accessibility and efficiency. MarketView also emphasizes customer support, offering round-the-clock service and training to its users.

MarketView Plugins for Excel

ExcelTools Query Capabilities

ExcelTools supports a wide array of data queries within Excel, catering to both real-time and historical data needs. It enables users to perform quote and historical queries, as well as access snapshot and streaming data, satisfying diverse data analysis requirements.

Framework Requirements

For the MarketView ExcelTools to operate efficiently, it is necessary for the user to have the .NET 4.0 framework installed on their system. This ensures full compatibility and optimal performance of the ExcelTools plugin.

Data Insertion and Updates

MarketView's ExcelTools allows for easy updates of spreadsheets with new data. It is capable of inserting static data for historical queries, ensuring that users can maintain accurate and up-to-date records in their Excel workbooks.

User Interface and Experience

ExcelTools is designed with a clean and user-friendly interface, facilitating a smooth experience for users. It does not require an active workstation connection or subscription, making it a convenient option for Excel users. Additionally, the plugin simplifies the data entry process by automatically converting all symbol inputs into capital letters.

Advanced Data Management Features

The plugin not only supports drag-and-drop operations between cells, which streamlines data manipulation but also employs the robust RTD (Real-Time Data) function to stream real-time data efficiently. ExcelTools is adept at handling multiple historical time-series queries and supports a range of frequencies, including intraday, daily, weekly, monthly, and seasonal queries.

Common Use Cases

• M

  
  Real-time monitoring of financial markets
• M

  
  Historical data analysis for trend forecasting
• M

  
  Streamlining data workflows for financial reporting
• M

  
  Performing complex financial calculations and modeling within Excel
• M

  
  Automating data import for efficient decision-making processes

Frequently Asked Questions

How can I download the MarketView ExcelTools plugin?

MarketView ExcelTools can be downloaded from the MarketView website.

What versions of Microsoft Excel are compatible with ExcelTools?

ExcelTools is compatible with multiple versions of Microsoft Excel including 2003, 2007, 2010, and 2013.

What are the network requirements for ExcelTools?

ExcelTools uses port 6487 for connection and may reroute to port 80 if needed.

Can ExcelTools handle real-time data?

Yes, ExcelTools offers support for real-time streaming data and snapshot data.

What are the system requirements to run ExcelTools on my computer?

The .NET 4.0 framework is required to run ExcelTools on a computer.