I'm looking to design an app/website running on a python program that creates a ranked scorecard of stocks. Ideally using an API firstly for the Australian Stock Market, but then more broadly the US, London and Europe and Asia. The calculations are quite straight forward and repetitive so it lends itself to a python script. The key is getting the right API and accurate data. There are about 33 metrics I use from the Stock Doctor service in Australia (don't think they have an API). But they do have a csv export so perhaps first draft is creating some code to run this process in excel until the best API can be sourced. I've uploaded the excel file I currently use to tun the calculations, see sheet QAV_updated.