Watch a step-by-step guide on how to request intraday (non close) daily historical data in Excel. (Level: Intermediate)
Watch a step-by-step guide on how to request multi-asset class historical data in Excel - in a single function. (Level: Intermediate)
Watch a step-by-step guide on how to retrieve real-time data programmatically in VBA for Excel. (Level: Advanced)
Watch a step-by-step guide on how to automatically capture real-time data at regular intervals in order to create a historical record. (Level: Advanced)
Thomson Reuters Eikon Excel allows you to find missing data points or project future values by using interpolation and extrapolation. This module will show you how to interpolate a data point on a US benchmark yield curve.
Discover the extensive toolkit within Thomson Reuters Excel enabling you to create intelligent and robust solutions based on endorsed market conventions. Learn how to examine and use the Style Database and the Adfin Analytics. Total Running Time 4:20
Discover how to quick and easy calculate correlation for a portfolio of assets in the excel environment. We explain how to retrieve time series data for the instruments using a convenient function wizard or directly using one of the Thomson Reuters data engines.
Fast and reliable pricing and valuation capabilities are central to a trader’s daily business. With Thomson Reuters Eikon you have access to a suite of powerful, ready-to-use calculators, a library of market-standard financial functions and highly sophisticated Excel capabilities. Learn more how to convert your existing sheets and easily integrate Thomson Reuters and 3rd party data into your Microsoft Excel spreadsheets. Course outline: - Accessing Thomson Reuters Eikon for Excel - Converting Spreadsheets - Dragging and Dropping - Retrieving Real-time data - Retrieving Reference data - Adfin functions