Enhanements to Artindex

[kaljuvee]

Small fixes / enhancements:

• Add Kanvas.AI logo on top (use image below) or ask Karola / Astrid for high resolution photo - DONE

• Add relationship graph between price and size to gallery sub pages like we have it on Home.py - DONE

• Move all gallery pages to archive folder, rename 'pages' to 'archive' - DONE

• Calculate the following metrics and display the metrics in a table: 1/ Title - Historical Price Performance DONE Total % change since inception (beginning) for each category (group by category)

• Annualise arthimetically, annualReturn = returnSinceInception / numberOfAuctionYears - DONE

• Total % change since inception (beginning) for top 10 artists - (i) group by year, artist, (ii) sort by total end price, (iii) calculate % change from first year to last year, returnSinceInception = (p(endYear) - p(beginYear))/p(beginYear) - DONE Two tables for price % change (return), two tables for Volume % change - DONE

• Add comma delimiters - TODO

• Investigate why the colours on overbidding % do not make sense for certain; maybe use max % change ja min (0) as boundaries for Plotly inputs; drop outliers if necessary; do pandas describe - DONE

• Label axes with user friendly names: art_work age -> Art work age etc - DONE

• Show aggregated numbers only, no breakdown per gallery - DONE

• Add table titles: DONE 1/ Table - Historical Price Performance 2/ Table - Historical Volume Growth

• Add graph titles: DONE 1/ Figure - Historical Price Performance (2001 - 2021) 2/ Figure - Historical Volume Growth (2001 - 2021) 3/ Figure - Art Sales by Category and Artist (2001 - 2021) 4/ Table - Top Ten Best Performing Artists (2001-2021) 5/ Table - Volume Growth for Top Ten Artists (2001-2021) 6/ Figure - Age of Art Work vs Price 7/ Figure - Size of Art Work vs Price

Change the footer text: DONE Copyright: Kanvas.ai Authors: Markus Sulg, Julian Kaljuvee Source: Estonian auctions (2001-2021)

[kaljuvee]

FYI https://www.masterworks.io/

[kaljuvee]

allee_calculations.xlsx