FYI: Yahoo! Finance started to block web parsing from its website. However, parsing is still possible via UK version, so in some cases it is possible to parse by typing "uk." before yahoo in link, for example, https://uk.finance.yahoo.com/quote/AAPL/key-statistics
One of the main issues of being investor is how to track your securities.
Some investors use apps from their brokers, others prefer third party sites.
The truth is all of them are terrible. They do not give sufficient info about portfolio, but just weights and basic graph. The ones that bring some insights to your portoflio either cost a lot or technically complicated and visually disgusting.
I think the reason is people who develop these kinds of systems are the ones who do not use them in a regular manner and the ones who actually use them experience lack of time or programming abilities to track their portfolio and positions on their own.
However, I personally think that there should not be the trade off between convenience and capabilities. The process of portfolio analysis should be straightforward where investors are provided with the necessary information for making decisions.
Having worked in trading and systems analytics, I came to idea to create if not an app but script to facilitate portfolio tracking. Current R and Python packages are not sufficient enough to obtain info and analysis, but they are powerful enough to build the right package for investing purposes.
Week by week, this repository will be filled with more advanced script.
Today my R script enables to get the following info about portfolio:
• Weights according to assets, their industries and sectors using pie plot; Barplot script enables to see securities dynamics and check Mean and Median of weights
• Comparative plots to assess portfolio dynamics with becncmarks and securities between each other (Scatter Plot, Heatmap, Treemap, Boxplot)
• Non Visualisation Capabilities include calculation of Alpha & Beta of Portfolio, its value across multiple currencies, MVaR and Portfolio Risk.
My first goal is to write powerful scripts that enable to check most necessary info for investor.
Currently under development: stock fundamentals, more advanced plots, making script suitable for using via Git
• quantmod
• timeSeries
• ggplot2
• ggrepel
• rvest
lm(formula = M$RPRF ~ M$MRKT + M$SMB + M$HML)
Min |
1Q |
Median |
3Q |
Max |
---|---|---|---|---|
-0.020934 | -0.004838 | -0.000629 | 0.003277 | 0.051802 |
Coefficients |
Estimate |
Std. Error |
t value |
Prob |
---|---|---|---|---|
Intercept |
-0.0154586 | 0.0004465 | -34.625 | < 2e-16 *** |
M$MRKT |
0.0108014 | 0.0004298 | 25.132 | < 2e-16 *** |
M$SMB |
0.0048543 | 0.0007821 | 6.207 | 1.84e-09 *** |
M$HML |
0.0040361 | 0.0005629 | 7.170 | 6.12e-12 *** |
Other |
Stats |
---|---|
Residual standard error | 0.007676 on 293 degrees of freedom |
Multiple R-squared 0.7509 | Adjusted R-squared 0.7483 |
F-statistic 294.4 on 3 and 293 DF | p-value < 2.2e-16 |
lm(formula = M$RPRF ~ M$MRKT + M$SMB + M$HML + M$RMW + M$CMA)
Min |
1Q |
Median |
3Q |
Max |
---|---|---|---|---|
-0.020861 | -0.004908 | -0.000812 | 0.003460 | 0.051695 |
Coefficients |
Estimate |
Std. Error |
t value |
Prob |
---|---|---|---|---|
Intercept |
-0.0155191 | 0.0004443 | -34.933 | < 2e-16 *** |
M$MRKT |
0.0102639 | 0.0004893 | 20.976 | < 2e-16 *** |
M$SMB |
0.0052029 | 0.0009148 | 5.687 | 3.14e-08 *** |
M$HML |
0.0037777 | 0.0008425 | 4.484 | 1.05e-05 *** |
M$RMW |
0.0013644 | 0.0009931 | 1.374 | 0.1705 |
M$CMA |
-0.0029100 | 0.0013212 | -2.203 | 0.0284 * |
Other |
Stats |
---|---|
Residual standard error | 0.007621 on 291 degrees of freedom |
Multiple R-squared 0.7561 | Adjusted R-squared 0.7519 |
F-statistic 180.4 on 5 and 291 DF | p-value: < 2.2e-16 |
2022 | 2023 | Median | Mean | |
---|---|---|---|---|
January | NA | 12.9 | 12.9 | 12.9 |
February | NA | -2.81 | -2.81 | -2.81 |
March | NA | -2.58 | -2.58 | -2.58 |
April | NA | -1.13 | -1.13 | -1.13 |
May | NA | -3.94 | -3.94 | -3.94 |
June | NA | 4.9 | 4.9 | 4.9 |
July | 8.23 | 4.85 | 6.54 | 6.54 |
August | -1.21 | -5.96 | -3.58 | -3.58 |
September | -10.55 | -1.74 | -6.14 | -6.14 |
October | 9.35 | NA | 9.35 | 9.35 |
November | 5.82 | NA | 5.82 | 5.82 |
December | -9.3 | NA | -9.3 | -9.3 |
Sum | 2.34 | 4.49 | ||
Median | 2.31 | -1.74 | ||
Mean | 0.39 | 0.5 |
Ticker | Start Date | End Date | Number |
---|---|---|---|
UNM | 2022-07-19 | 2024-07-19 | 1 |
SWBI | 2022-07-19 | 2024-07-19 | 2 |
SWBI | 2022-09-30 | 2024-07-19 | 1 |
VSTO | 2022-07-19 | 2024-07-19 | 2 |
T | 2022-07-19 | 2024-07-19 | 2 |
T | 2022-07-21 | 2024-07-19 | 1 |
WBA | 2022-07-19 | 2024-07-19 | 1 |
AMZN | 2022-07-19 | 2024-07-19 | 1 |
JEF | 2022-07-19 | 2024-07-19 | 2 |
HPQ | 2022-07-19 | 2024-07-19 | 2 |
TPH | 2022-07-21 | 2024-07-19 | 3 |
F | 2022-07-21 | 2024-07-19 | 4 |
C | 2022-07-21 | 2024-07-19 | 1 |
TSN | 2022-07-21 | 2024-07-19 | 1 |
WERN | 2022-07-21 | 2024-07-19 | 2 |
GOOGL | 2022-07-26 | 2024-07-19 | 1 |
MU | 2022-07-26 | 2024-07-19 | 1 |
AIG | 2022-07-26 | 2024-07-19 | 1 |
NRG | 2022-07-26 | 2024-07-19 | 1 |
ARCH | 2022-07-27 | 2024-07-19 | 1 |
ALLY | 2022-07-28 | 2024-07-19 | 1 |
FL | 2022-07-29 | 2024-07-19 | 2 |
VALE | 2022-07-29 | 2024-07-19 | 4 |
STLA | 2022-07-29 | 2024-07-19 | 4 |
HPE | 2022-07-29 | 2024-07-19 | 4 |
BFH | 2022-07-29 | 2024-07-19 | 1 |
PARA | 2022-07-29 | 2024-07-19 | 2 |
COF | 2022-08-01 | 2024-07-19 | 1 |
VOYA | 2022-08-01 | 2024-07-19 | 1 |
VIR | 2022-08-15 | 2024-07-19 | 1 |
VIR | 2022-09-30 | 2024-07-19 | 1 |
ZIM | 2022-08-15 | 2024-07-19 | 1 |
ZIM | 2022-08-26 | 2024-07-19 | 1 |
ZIM | 2022-09-30 | 2024-07-19 | 1 |
PVH | 2022-09-30 | 2024-07-19 | 1 |
VIRT | 2022-09-30 | 2024-07-19 | 1 |
FLGT | 2022-09-30 | 2024-07-19 | 1 |