Platts Excel Add-In User Guide

This is a user manual for Platts™ Excel® Add-In


Platts Excel Add-In User Guide - cover page
Brand
Platts
Category
Other
Document type
User Manual
Language
English
Pages
18
File format
PDF
File size
1.1 MB
Published
21 October, 2023
Updated
21 October, 2023
MD5 checksum
286299E6807689AFFA79CA5D39AB0522

About this manual

This guide explains how to use the Platts Excel Add-In, including signing in, navigating the ribbon bar, and using built-in functions. It covers templates, data retrieval methods, and troubleshooting common errors like #NAME?, #N/A, and #VALUE!. The add-in integrates with Excel to deliver proprietary market data and analytics through pre-configured templates and functions.

The guide also details specific functions such as PlattsDataSet, PlattsGetData, and PlattsDataSeries, including their syntax, arguments, and example results for datasets like WRD and MD. It includes error handling for incorrect syntax or missing references.

What's inside

  • Introduction
  • Ribbon bar
  • Signing in
  • Forgot password
  • Templates
  • Platts Excel Add-In functions
  • Transitioning from PGA to PCR
  • Common Problems
  • Function Syntax
  • Error Handling

Frequently asked questions

How do I sign in to the Platts Excel Add-In?

Enter your email address and password (case-sensitive) in the Sign In window. If you forgot your password, use the 'Forgot your password?' link to reset it via email.

What functions are available in the Platts Excel Add-In?

Functions include PlattsDataSet, PlattsGetData, PlattsGetMetadata, PlattsStreamData, PlattsToday, and PlattsDataSeries. These can be accessed via the 'Fx' icon in the formula bar under the 'Platts' category.

Download PDF (1.1 MB)