Timeseries Export Options

Carl Reid shared this idea 7 years ago
Under Consideration

hey guys, nothing super urgent here, but at some point we might want to change the way timeseries exports to Excel due to column restraints in Excel. for instance, if a user was trying to export the entire history of the S&P 500 (or any other security with 60 + years of daily data) to perform some analysis, Excel is unable to write all the values because a workbook can only handle 16,384 columns, and that amount of data requires more than 16,384 inputs. a solution would be to have the option before you download - horizontal vs vertical - as Excel allows for up to 1,048,576 rows.

wouldn't want to make the change all together to have every download be vertical as i'm sure that would affect some current workflows of existing customers. but having that option would be great, along with the option to reverse the data

Leave a Comment
 
Attach a file