In this world integrated with API’s, it becomes easier to interact with web based tools using the ever friendly excel. Excel based code can be written to create a vast variety of tools by connecting them to API’s and fetching data in JSON format. This data can then be easily manipulated in excel to take desired action. Using excel, we can automate trading strategies. You can place trades to any of your favorite brokers (Integrated brokers, Alpaca or anyone else who provides API endpoints for trading) and also get periodic feedback from these tools on your current portfolio value. These can then be used to create a vast variety of reports.