---
# System prepended metadata

title: Monkeybeat calculations

---

# Monkeybeat calculations

## Case 1

### 1 month returns of INFY

┌─symbol──┬────return_percent─┐
│ INFY.NS │ 7.163674060807157 │
└─────────┴───────────────────┘

### Value of Rs 1O000 invested over 30 days in INFY

```csv
"close_date","present_close","initial_close","percent_diff","current_invested"
"2022-10-18",1487.4443359375,1487.4443359375,0,10000
"2022-10-19",1469.3916015625,1487.4443359375,-1.2136746188637573,9878.632538113625
"2022-10-20",1484.6746826171875,1487.4443359375,-0.1862021491087836,9981.379785089122
"2022-10-21",1484.2789306640625,1487.4443359375,-0.21280831806337291,9978.719168193662
"2022-10-24",1501.44140625,1487.4443359375,0.941014730724561,10094.101473072456
"2022-10-25",1509.800048828125,1487.4443359375,1.502961310920905,10150.296131092091
"2022-10-27",1523.949951171875,1487.4443359375,2.4542508484101626,10245.425084841016
"2022-10-28",1513.25,1487.4443359375,1.734899480876057,10173.489948087607
"2022-10-31",1537.6500244140625,1487.4443359375,3.375298642346779,10337.529864234677
"2022-11-01",1573,1487.4443359375,5.75185652299226,10575.185652299226
"2022-11-02",1553.300048828125,1487.4443359375,4.427440496394626,10442.744049639463
"2022-11-03",1530.75,1487.4443359375,2.9114140957218066,10291.141409572181
"2022-11-04",1514,1487.4443359375,1.7853215357980177,10178.532153579801
"2022-11-07",1507.449951171875,1487.4443359375,1.344965640127027,10134.496564012703
"2022-11-09",1511.199951171875,1487.4443359375,1.5970759147368303,10159.707591473683
"2022-11-10",1501.949951171875,1487.4443359375,0.9752039040326482,10097.520390403264
"2022-11-11",1570.0999755859375,1487.4443359375,5.556889602617745,10555.688960261774
"2022-11-14",1585.300048828125,1487.4443359375,6.578781506398283,10657.878150639828
"2022-11-15",1594,1487.4443359375,7.16367406080716,10716.367406080715
```

### Conclusion

Data matches exactly when only one stock is there in portfolio.

## Case 2:

### 1 month returns of INFY and HDFC

┌─symbol──┬────return_percent─┐
│ HDFC.NS │ 14.74707233322703 │
│ INFY.NS │ 7.163674060807157 │
└─────────┴───────────────────┘

Average Returns is 10.95%

```python
>>> x=14.74707233322703+7.163674060807157
>>> x
21.910746394034184
>>> x/2
10.955373197017092
>>> 
```

### Value of Rs 1O000 invested over 30 days in INFY AND HDFC

```csv
"close_date","present_close","initial_close","percent_diff","current_invested"
"2022-10-18",3819.09423828125,3819.09423828125,0,10000
"2022-10-19",3851.191650390625,3819.09423828125,0.8404456687044245,10084.044566870443
"2022-10-20",3853.8746337890625,3819.09423828125,0.9106974936409297,10091.069749364093
"2022-10-21",3834.1788330078125,3819.09423828125,0.39497833217520156,10039.49783321752
"2022-10-24",3894.44140625,3819.09423828125,1.9729067487651033,10197.29067487651
"2022-10-25",3866.5,3819.09423828125,1.2412828477383828,10124.128284773838
"2022-10-27",3907.25,3819.09423828125,2.308289772876192,10230.82897728762
"2022-10-28",3913.699951171875,3819.09423828125,2.477176707040397,10247.71767070404
"2022-10-31",4007.4500732421875,3819.09423828125,4.931950436648701,10493.19504366487
"2022-11-01",4079.199951171875,3819.09423828125,6.8106649551461,10681.06649551461
"2022-11-02",4061.300048828125,3819.09423828125,6.341969991708757,10634.196999170876
"2022-11-03",4020.14990234375,3819.09423828125,5.264485543383275,10526.448554338327
"2022-11-04",4000.64990234375,3819.09423828125,4.753893272458433,10475.389327245843
"2022-11-07",4014.849853515625,3819.09423828125,5.1257079040414855,10512.570790404148
"2022-11-09",4014.699951171875,3819.09423828125,5.121782828240857,10512.178282824087
"2022-11-10",4006.050048828125,3819.09423828125,4.89529189075504,10489.529189075503
"2022-11-11",4221.7999267578125,3819.09423828125,10.544533948389729,11054.453394838973
"2022-11-14",4246.85009765625,3819.09423828125,11.200453109727604,11120.04531097276
"2022-11-15",4269.5,3819.09423828125,11.793523113518434,11179.352311351844
```

### Conclusion

Average Returns (10.95%) doesn't match the percentage difference 11.79% when there's more than one stock.


## Case 3

Quite a lot of difference here :disappointed: 

### 1 month returns of INFY and PAYTM

```csv
"symbol","return_percent"
"INFY.NS",7.163674060807157
"PAYTM.NS",-5.426826408721697
```

### Value of Rs 1O000 invested over 30 days in INFY and PAYTM

```csv
"close_date","present_close","initial_close","percent_diff","current_invested"
"2022-10-18",2149.8943481445312,2149.8943481445312,0,10000
"2022-10-19",2121.8416137695312,2149.8943481445312,-1.3048424635010991,9869.51575364989
"2022-10-20",2117.4246826171875,2149.8943481445312,-1.5102912175831678,9848.970878241684
"2022-10-21",2113.87890625,2149.8943481445312,-1.6752191532395262,9832.478084676048
"2022-10-24",2138.94140625,2149.8943481445312,-0.5094641931583381,9949.053580684165
"2022-10-25",2166.1500244140625,2149.8943481445312,0.7561151218226482,10075.611512182264
"2022-10-27",2173.7999267578125,2149.8943481445312,1.1119420186351476,10111.194201863515
"2022-10-28",2156.0999755859375,2149.8943481445312,0.28864801876250445,10028.86480187625
"2022-10-31",2176.050048828125,2149.8943481445312,1.2166040022463176,10121.660400224631
"2022-11-01",2215.9000244140625,2149.8943481445312,3.0701823243778246,10307.018232437782
"2022-11-02",2195.9000244140625,2149.8943481445312,2.139904051993834,10213.990405199384
"2022-11-03",2173.7999877929688,2149.8943481445312,1.1119448576191333,10111.194485761913
"2022-11-04",2164.3499755859375,2149.8943481445312,0.6723878061209005,10067.23878061209
"2022-11-07",2158.699951171875,2149.8943481445312,0.40958305857882904,10040.958305857883
"2022-11-09",2154.8499755859375,2149.8943481445312,0.23050562673850508,10023.05056267385
"2022-11-10",2128.8499755859375,2149.8943481445312,-0.9788561273606826,9902.114387263931
"2022-11-11",2202.0999755859375,2149.8943481445312,2.4282880452456825,10242.828804524568
"2022-11-14",2223.8500366210938,2149.8943481445312,3.4399685054472577,10343.996850544725
"2022-11-15",2220.5,2149.8943481445312,3.284145191432548,10328.414519143254
```