Summary
In this chapter, we rounded out our suite of Robo-advisor capabilities by adding batch processes for dividends and fees. We started with processing dividends. First, we received a dividend payout file from the custodian. We ran through that file using pandas to extract which dividends should be allocated to which goals. This turned out as a reusable function that can be scheduled to run on a daily basis on your platform.
The second part of the chapter talked about fees. We focused on a scenario of calculating monthly platform AUM fees that we could send to the broker to extract on our behalf. We started off by calculating today’s AUM, and then expanded that to cover the average daily AUM for the last month using market data from yfinance. Finally, we calculated fees using a 10 bps AUM fee. We put all this together into a reusable function that generates a CSV file that could be sent to the broker to execute on.
The final chapter of this book will discuss the impact...
