8/17/2023 0 Comments My portfolio google finances![]() ![]() Market data can be bought to be used to track stock options, however, this proves expensive and is more commonly used by institutions for quantitative analysis and is thus expensively priced. However, google finance did not offer data for stock options. Using google sheets and the built-in google finance API I was able to build out my portfolio, tracking stocks, deposits/FX rates, and also fees incurred. I realised it was necessary to create a comprehensive portfolio tracker which would not only help with visualising allocation, risk, and returns but also with record-keeping for tax purposes. Current WorksĪ problem I quickly ran into was the fact that my portfolio was split across many different platforms with different brokers, this made it hard to track total returns and allocate capital efficiently. Thus I initiated my first options trade in 2021. However, after spending time learning specifically about American style options and their use in not only making directional bets but also in delta hedging and betting on volatility, I realised this was a way to not only achieve leverage on capital without taking on margin but also to protect your downside and manage risk if used correctly. I initially wrote derivatives off as an investment as I believed them to be too risky. ![]() In 2020 as the COVID-19 pandemic hit the world and sent us all into lockdown I stumbled across the hidden world of derivatives. This led me to learn more about the traditional financial markets and invest more and more of my own capital. Having started my personal investment education all the way back in 2015, it was not until the prevalence of low cost and easy to access brokers in 2018/19 that I was first able to buy and own securities. Tracking these assets is also not a new phenomenon as it provides clarity to the investor on their total net worth and helps them make informed decisions for a prosperous financial future. Investing in assets is not a new phenomenon and has been around for many thousands of years. This then fuels the self-fulfilling loop as more people want a share of this wealth and sign up for accounts/more information, leading to more information and tools being created. The 24/7 social media/hype cycle means that it is almost impossible to be on the internet and not hear about the massive gains achieved by retail traders/investors. This combined with more fintech companies than ever before have amounted to low-cost brokerage (sometimes even zero-fee brokerage), which is extremely attractive to retail investors. The connectivity offered by the internet has again proved to democratise access to once inaccessible information and tools. This can be primarily attributed to: an increase in the ease of access to these markets, hype/popular trends, and more spare time due to lockdowns. Information overload, I know, but if you are not constantly learning and moving forward you will be left behind.There has been a massive uptick in retail investors globally throughout the recent pandemic in both the traditional financial markets and new age markets such as cryptocurrencies. If you like this forum, I guarantee you will love the Bogleheads forum which deals with personal investments, investing, personal finance, personal consumer issues, education, etc. I have all these tools, including many others, in my financial toolbox. They are Fidelity, Maxifi Planner, Mint, Morningstar, New Retirement Planner, Personal Capital, and Yahoo. Since most of the analysis contains personal numerical data, please do not share outside of the community. Below I provide a link to a folder showing seven tools and a tiny bit of the analysis they can perform. ![]() You need tools offering much deeper analysis and sophistication that are all outside of Tiller’s wheelhouse (no disrespect intended). On the topic of portfolios, investments, position tracking, etc., Tiller should definitely not be the only tool in your financial toolbox. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |