CarlosOliveira1988 / Investment_Portfolio_Analysis

This repository is useful to perform some financial analysis in Investment Portfolio
4 stars 0 forks source link

Include the "Adjusted Dividend Yield" column in the opened stock position table #75

Closed CarlosOliveira1988 closed 2 years ago

CarlosOliveira1988 commented 2 years ago

Is your feature request related to a problem? Please describe.

The 'Dividend Yield' information is useful when we want to compare different type of investments. Since the 'Dividend Yield' is related to the stock market values, it's useful to have such data proportional to our portfolio, considering the 'Mean Buy Price'.

Describe the solution you'd like

Get the information from Status Invest website, using the same web scrapping method that we use to get information from 'Tesouro Direto'. Then, adjust the data according to the "Mean Buy Price". Example:

PETR3 DY = 25% @ MarketPrice:R$25,00 PETR3 ADY = 31,25% @ MeanBuyPrice:R$20,00 (DY*MarketPrice/MeanBuyPrice)

Describe alternatives you've considered

I've developed a small script to collect such data from Status Invest website, using "HTML selectors". Please, check the dividend.txt file.

Additional context

N/A

CarlosOliveira1988 commented 2 years ago

This ticket is resolved by the commit 41e3ff3. Please, check the results.