Empirasign Blog Entry: Improved Excel Presentation
Improved Excel PresentationMarch 25, 2013
A new version our Excel downloader is now available. The core functionality remains the same, but a few pesky presentation issues have been resolved.
Prices vs Dates: 12-04 is an entirely valid price for a derivative, but Excel will almost always convert this to the date 12/04/13. Based on a data extraction's header row, our downloader now pre-sets text columns to Text and number columns to General so this problem no longer occurs. Excel VBA masochists are free to read more on choosing different data types for each column when peforming a TextToColumns operation here.
Variable Column Widths: Columns widths are now AutoFit so the contents of all columns can be easily read while minimizing screen space used. Thank you Sam, whose suggestion lead to this change.
To download the latest version of the spreadsheet, head on over to our MBS API Product Page: www.empirasign.com/api-mbs
To get set up with an API Free Trial ID, please email us at: email@example.com.