How to Use Pivot Table in Excel

• Related Articles

• How to Access Elliott's Data by Using Query in Microsoft Office Excel 2019

  Release Date: 06/30/2020 Version: 7.x & Up Elliott's data is based on the PSQL database engine. In Excel, you can access the PSQL database through an ODBC interface with the Microsoft "Query" function. The following procedure outlines how you can do ...

• Converting Elliott Internal Date to Conventional Date Format in Excel

  Q - If I retrieve Elliott's data in Excel through ODBC, the date column is retrieved in an 8-digit numeric format like:20161231, where the first 4 digits are the years, the following 2 digits are the month, and the last two digits are the day of the ...

• Feature - Prevent Excel from Dropping Leading Zeroes in CSV Item Number Field

  Release Date - 1/4/18 When exporting Elliott's item numbers to CSV through Elliott-provided reports with a CSV export option, the leading zeroes will be dropped when the file is opened with Excel. For example, when opening the CSV in Excel, item ...

• Report Desk: SELECT Statement Errors Using Alternate Table Names

  Release Date: 4/24/2025 Versions: Elliott V8.6 and Up The Problem When the SELECT statement in the SQL Template uses alternate table names in join statements, an error may occur during the running of the report: [SQL Engine] Error in expression: ...

• How to Make Excel Show Negative as Red by Default When Bringing up a CSV File

  Release Date: 10/16/2023 Version: 7.x & Up Q - During the Elliott 2023 conference, at the Financial Statement with Excel session, I saw you were able to bring up the CSV file in Excel that shows the negative amount with red color. I know how to ...