[Data] Monthly return

[bachpx195]

Tổng quan

Quan sát monthly return của các tài sản

Phương pháp tổng hợp

Lấy return của từng tháng sau đó cập nhật vào table

Công thức

(open - close)/open

Table sample

Time	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2024

[bachpx195]

BTC (id 34)

Time	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2024	$${\color{green}+0.7}$$	$${\color{green}+43.57}$$	$${\color{green}+16.6}$$	$${\color{red}-14.88}$$	$${\color{green}+11.32}$$	$${\color{red}-7.06}$$	$${\color{green}+2.96}$$	$${\color{red}-8.75}$$	$${\color{green}+7.38}$$
2023	$${\color{green}+39.8}$$	$${\color{green}+0.07}$$	$${\color{green}+23.01}$$	$${\color{green}+2.7}$$	$${\color{red}-6.92}$$	$${\color{green}+11.99}$$	$${\color{red}-4.07}$$	$${\color{red}-11.26}$$	$${\color{green}+3.94}$$	$${\color{green}+28.47}$$	$${\color{green}+8.9}$$	$${\color{green}+12.09}$$
2022	$${\color{red}-16.77}$$	$${\color{green}+12.2}$$	$${\color{green}+5.45}$$	$${\color{red}-17.31}$$	$${\color{red}-15.49}$$	$${\color{red}-37.29}$$	$${\color{green}+16.8}$$	$${\color{red}-13.94}$$	$${\color{red}-3.12}$$	$${\color{green}+5.5}$$	$${\color{red}-16.24}$$	$${\color{red}-3.63}$$
2021	$${\color{green}+14.42}$$	$${\color{green}+36.39}$$	$${\color{green}+30.15}$$	$${\color{red}-1.78}$$	$${\color{red}-35.43}$$	$${\color{red}-5.93}$$	$${\color{green}+18.31}$$	$${\color{green}+13.6}$$	$${\color{red}-6.96}$$	$${\color{green}+39.89}$$	$${\color{red}-7.09}$$	$${\color{red}-18.85}$$
2020	$${\color{green}+29.99}$$	$${\color{red}-8.86}$$	$${\color{red}-24.79}$$	$${\color{green}+34.43}$$	$${\color{green}+9.61}$$	$${\color{red}-3.28}$$	$${\color{green}+24.05}$$	$${\color{green}+2.77}$$	$${\color{red}-7.49}$$	$${\color{green}+27.97}$$	$${\color{green}+42.82}$$	$${\color{green}+46.85}$$
2019	$${\color{red}-7.22}$$	$${\color{green}+11.05}$$	$${\color{green}+7.59}$$	$${\color{green}+29.7}$$	$${\color{green}+60.75}$$	$${\color{green}+26.87}$$	$${\color{red}-7.13}$$	$${\color{red}-4.89}$$	$${\color{red}-13.55}$$	$${\color{green}+10.26}$$	$${\color{red}-17.49}$$	$${\color{red}-4.58}$$
2018	$${\color{red}-25.01}$$	$${\color{green}+0.41}$$	$${\color{red}-32.94}$$	$${\color{green}+33.57}$$	$${\color{red}-19.05}$$	$${\color{red}-14.63}$$	$${\color{green}+20.96}$$	$${\color{red}-9.37}$$	$${\color{red}-5.49}$$	$${\color{red}-3.84}$$	$${\color{red}-36.55}$$	$${\color{red}-8.37}$$
2017	$${\color{green}+10.87}$$	$${\color{red}-6.64}$$	$${\color{green}+47.61}$$	$${\color{green}+52.24}$$	$${\color{green}+52.71}$$	$${\color{green}+10.45}$$	$${\color{green}+17.92}$$	$${\color{green}+65.32}$$	$${\color{green}+52.24}$$	$${\color{green}+47.61}$$	$${\color{red}-6.64}$$	$${\color{green}+10.87}$$
2016	$${\color{red}-14.83}$$	$${\color{green}+20.08}$$	$${\color{red}-5.35}$$	$${\color{green}+7.27}$$	$${\color{green}+18.78}$$	$${\color{green}+27.14}$$	$${\color{red}-7.67}$$	$${\color{red}-7.49}$$	$${\color{green}+6.04}$$	$${\color{green}+14.71}$$	$${\color{green}+5.42}$$	$${\color{green}+30.8}$$
2015	$${\color{red}-33.05}$$	$${\color{green}+18.43}$$	$${\color{red}-4.38}$$	$${\color{red}-3.46}$$	$${\color{red}-3.17}$$	$${\color{green}+15.19}$$	$${\color{green}+8.2}$$	$${\color{red}-18.67}$$	$${\color{green}+2.35}$$	$${\color{green}+33.49}$$	$${\color{green}+19.27}$$	$${\color{green}+13.83}$$
2014	$${\color{green}+10.03}$$	$${\color{red}-31.03}$$	$${\color{red}-17.25}$$	$${\color{red}-1.6}$$	$${\color{green}+39.46}$$	$${\color{green}+2.2}$$	$${\color{red}-9.69}$$	$${\color{red}-17.55}$$	$${\color{red}-19.01}$$	$${\color{red}-12.95}$$	$${\color{green}+12.82}$$	$${\color{red}-15.11}$$
2013	$${\color{green}+44.05}$$	$${\color{green}+61.77}$$	$${\color{green}+172.76}$$	$${\color{green}+50.01}$$	$${\color{red}-8.56}$$	$${\color{red}-29.89}$$	$${\color{green}+9.6}$$	$${\color{green}+30.42}$$	$${\color{red}-1.76}$$	$${\color{green}+60.79}$$	$${\color{green}+649.35}$$	$${\color{red}-34.81}$$

[bachpx195]

LTC (id 35)

Time	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2024	$${\color{red}-8.33}$$	$${\color{green}+19.71}$$	$${\color{green}+31.38}$$	$${\color{red}-24.3}$$	$${\color{green}+4.69}$$	$${\color{red}-9.49}$$	$${\color{red}-6.88}$$	$${\color{red}-7.38}$$	$${\color{green}+2.86}$$
2023	$${\color{green}+34.15}$$	$${\color{red}-0.31}$$	$${\color{red}-4.5}$$	$${\color{red}-1.5}$$	$${\color{green}+2.47}$$	$${\color{green}+20.22}$$	$${\color{red}-15.11}$$	$${\color{red}-30.77}$$	$${\color{green}+3.27}$$	$${\color{green}+4.41}$$	$${\color{green}+0.77}$$	$${\color{green}+4.88}$$
2022	$${\color{red}-25.1}$$	$${\color{green}+3.93}$$	$${\color{green}+8.88}$$	$${\color{red}-22.68}$$	$${\color{red}-28.68}$$	$${\color{red}-21.29}$$	$${\color{green}+10.96}$$	$${\color{red}-9.88}$$	$${\color{red}-0.65}$$	$${\color{green}+2.84}$$	$${\color{green}+43.87}$$	$${\color{red}-11.38}$$
2021	$${\color{green}+4.14}$$	$${\color{green}+27.71}$$	$${\color{green}+19.02}$$	$${\color{green}+37.85}$$	$${\color{red}-30.67}$$	$${\color{red}-23.27}$$	$${\color{green}+0.04}$$	$${\color{green}+18.81}$$	$${\color{red}-10.66}$$	$${\color{green}+25.26}$$	$${\color{green}+8.29}$$	$${\color{red}-29.6}$$
2020	$${\color{green}+64.69}$$	$${\color{red}-14.66}$$	$${\color{red}-32.68}$$	$${\color{green}+18.58}$$	$${\color{red}-1.55}$$	$${\color{red}-9.71}$$	$${\color{green}+41.23}$$	$${\color{green}+4.8}$$	$${\color{red}-24.12}$$	$${\color{green}+20.45}$$	$${\color{green}+57.39}$$	$${\color{green}+41.7}$$
2019	$${\color{green}+4.98}$$	$${\color{green}+45.12}$$	$${\color{green}+32.57}$$	$${\color{green}+22.9}$$	$${\color{green}+54.22}$$	$${\color{green}+7.5}$$	$${\color{red}-19.85}$$	$${\color{red}-34.96}$$	$${\color{red}-12.83}$$	$${\color{green}+4.07}$$	$${\color{red}-19.01}$$	$${\color{red}-12.52}$$
2018	$${\color{red}-26.15}$$	$${\color{green}+22.47}$$	$${\color{red}-42.51}$$	$${\color{green}+27.85}$$	$${\color{red}-20.3}$$	$${\color{red}-31.22}$$	$${\color{red}-3.26}$$	$${\color{red}-21.38}$$	$${\color{red}-1.34}$$	$${\color{red}-18.4}$$	$${\color{red}-35.5}$$	$${\color{red}-7.11}$$

[bachpx195]

DOT (id 37)

Time	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2024	$${\color{red}-18.88}$$	$${\color{green}+24.17}$$	$${\color{green}+16.75}$$	$${\color{red}-33.4}$$	$${\color{green}+8.73}$$	$${\color{red}-11.01}$$	$${\color{red}-13.3}$$	$${\color{red}-20.99}$$	$${\color{green}+4.06}$$
2023	$${\color{green}+45.31}$$	$${\color{green}+1.39}$$	$${\color{red}-0.09}$$	$${\color{red}-7.35}$$	$${\color{red}-9.56}$$	$${\color{red}-2.54}$$	$${\color{red}-1.37}$$	$${\color{red}-16.4}$$	$${\color{red}-3.93}$$	$${\color{green}+8.41}$$	$${\color{green}+23.04}$$	$${\color{green}+49.86}$$
2022	$${\color{red}-27.37}$$	$${\color{red}-2.27}$$	$${\color{green}+12.62}$$	$${\color{red}-32.02}$$	$${\color{red}-28.62}$$	$${\color{red}-31.85}$$	$${\color{green}+22.1}$$	$${\color{red}-18.54}$$	$${\color{red}-10.1}$$	$${\color{green}+4.58}$$	$${\color{red}-17.52}$$	$${\color{red}-21.08}$$
2021	$${\color{green}+73.97}$$	$${\color{green}+109.74}$$	$${\color{green}+9.71}$$	$${\color{red}-1.5}$$	$${\color{red}-36.28}$$	$${\color{red}-29.52}$$	$${\color{green}+2.34}$$	$${\color{green}+86.84}$$	$${\color{red}-8.68}$$	$${\color{green}+49.49}$$	$${\color{red}-11.29}$$	$${\color{red}-29.77}$$
2020	$${\color{green}+200.09}$$	$${\color{red}-30.7}$$	$${\color{red}-3.69}$$	$${\color{green}+28.53}$$	$${\color{green}+72.22}$$

[bachpx195]

LINK (id 42)

Time	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2024	$${\color{green}+3.26}$$	$${\color{green}+24.94}$$	$${\color{red}-0.53}$$	$${\color{red}-31.51}$$	$${\color{green}+40.27}$$	$${\color{red}-22.43}$$	$${\color{red}-10.15}$$	$${\color{red}-14.04}$$	$${\color{green}+7.53}$$
2023	$${\color{green}+24.7}$$	$${\color{green}+3.5}$$	$${\color{green}+5.45}$$	$${\color{red}-7.42}$$	$${\color{red}-7.79}$$	$${\color{red}-2.55}$$	$${\color{green}+19.55}$$	$${\color{red}-22.13}$$	$${\color{green}+39.35}$$	$${\color{green}+38.62}$$	$${\color{green}+26.96}$$	$${\color{green}+3.68}$$
2022	$${\color{red}-12.14}$$	$${\color{red}-11.78}$$	$${\color{green}+11.84}$$	$${\color{red}-35.25}$$	$${\color{red}-30.75}$$	$${\color{red}-17.39}$$	$${\color{green}+22.03}$$	$${\color{red}-13.4}$$	$${\color{green}+14.46}$$	$${\color{green}+3.6}$$	$${\color{red}-2.32}$$	$${\color{red}-27.34}$$
2021	$${\color{green}+100.79}$$	$${\color{green}+9.47}$$	$${\color{green}+19.12}$$	$${\color{green}+29.52}$$	$${\color{red}-15.76}$$	$${\color{red}-39.2}$$	$${\color{green}+16.38}$$	$${\color{green}+17.51}$$	$${\color{red}-10.11}$$	$${\color{green}+25.0}$$	$${\color{red}-15.63}$$	$${\color{red}-22.92}$$
2020	$${\color{green}+59.85}$$	$${\color{green}+43.6}$$	$${\color{red}-44.19}$$	$${\color{green}+63.42}$$	$${\color{green}+11.61}$$	$${\color{green}+10.53}$$	$${\color{green}+71.03}$$	$${\color{green}+99.64}$$	$${\color{red}-36.63}$$	$${\color{green}+13.72}$$	$${\color{green}+27.1}$$	$${\color{red}-21.22}$$
2019	$${\color{red}-28.44}$$	$${\color{green}+10.23}$$	$${\color{green}+20.02}$$	$${\color{red}-7.02}$$	$${\color{green}+114.51}$$	$${\color{green}+231.04}$$	$${\color{red}-34.77}$$	$${\color{red}-19.75}$$	$${\color{red}-0.62}$$	$${\color{green}+53.98}$$	$${\color{red}-17.85}$$	$${\color{red}-20.96}$$