Skip to main content

Exporting data as XLSX or PDF

All standard search views, such as Overview, Contacts, Portfolios, Securities, Transactions, Trade orders, Positions, Customers, Analytics+, Bookkeeping or Queries, allow you to export the content of the tables available within the view.Bookkeeping view

Exporting data from the system allows you to easily extract any data you can find from the system, either to use further with a spreadsheet or as "ad-hoc" reporting.

All export files contain the data you have visible on the screen with the columns you have selected and the date you have searched. Remember that you can easily save search views for different pre-selections of data and columns!

reporting_pdf_export.png

XLSX export

All search views support exporting the content as an Excel file through the XLSX icon. The exported Excel file contains the search result you have visible on the screen with the columns you have selected, allowing you to export any data easily from the system. (Before FA 3.9, export is done as XLS, not XLSX.)

Each exported Excel is named with the name of the exported view and a time stamp as name_of_the_view_yyyyMMdd.xls (for example, Transactions_current_month_20160301.xlsx).

If your table contains a summary row, as for example on the Transactions, Trade orders and Bookkeeping views, the summary row is also included in the exported Excel file.

Note

XLSX export allows you to export at most 50 000 rows at once, ensuring the system can manage exporting your data as an Excel. Make sure you search for a decent number of rows before exporting your data! You will be presented with a warning if you try to export more than 50 000 rows. (Available from FA 3.9 onward)

PDF export

All search views support exporting the content as a PDF file through the PDF icon. PDF export generates a nice-looking dynamic PDF report out of the data you have visible in the table, allowing you to extract any data easily, flexibly, and with a presentable and polished layout. (PDF export is available from FA 3.0 onward.)

PDF export from search views reacts to your own logo, themes and styles the same way as standard reports do, ensuring that any PDF export you take looks the same as any standard report you generate, allowing you to combine these fluently and conveniently (available from FA 3.2 onward).

In addition to the data visible on the screen, the exported PDF indicates the screen you exported your data from, and states the selected dates and selected customer/portfolio from relevant views (Overview, Analytics+, and Queries (last available from FA 3.2 onward)). Each exported PDF is named with the name of the exported view and a time stamp as name_of_the_view_yyyyMMdd.pdf (for example, Transactions_current_month_20160301.pdf).

Note

PDF export is done dynamically from the content of your table, and all columns you have visible are fitted horizontally into one page (landscape). Make sure you select a decent number of columns so that they fit nicely on the exported file! If you have more rows than what can vertically fit in one page, your PDF export file will contain multiple pages.