UPDATE: DOWNLOAD IN OP- new design with some thought behind it and somewhat of a theme
- new easy sort functionality for each column (just click on the blue text, sorting alternates between ascending and descending)
- re-implemented the graph and also added a red break even line (data of graph gets selected by clicking on the blue text of the pairings in column A)
- trashed / reworked some of the code to make the workbook a little faster
- new formatting to indicate significance of profit / loss (green = 67 quantile, yellow = 33 quantile, red = rest)
- decided to display the traded volume instead of "amount" since the "amount"-value can be misleading for people who deposited/withdrew coins
also to all who got the object / library not found error:as far as i am informed this error occurs when you have an outdated version of ms excel which further leads to outdated libraries which are needed to execute my code properly
i dont know yet if i cant get my file to work cross-version but i will keep you updated on this.
as for now i can only provide a version for ms excel 2016 (tested it for this version on various computers in my university and it seems to work pretty smoothly)
PREVIEW:
i hope you guys like it and i am open for feedback!
greetings!