DataAnalyst_Assignment

Task 1 Output:

Total Trades: 249
Profitable Trades: 96
Loss-Making Trades: 153
Win Rate: 0.3855421686746988
Average Profit per Trade: 105.54375
Average Loss per Trade: 76.09542483660131
Risk Reward Ratio: 1.3869920593338259
Expectancy: -6.065863453815254
Average ROR per Trade: -0.019682584032109474
Sharpe Ratio: -0.191480949325724
Max Drawdown: -0.999999999328563
Max Drawdown Percentage: -99.9999999328563
CAGR: -0.11528725113647198
Calmar Ratio: -0.1152872512138801

Task 2 Output:

> db.icici_bank.find().limit(5)
{ "_id" : ObjectId("652bad9471d8e09ad65abc19"), "Timestamp" : ISODate("2023-10-12T18:30:00Z"), "Open" : 949.9500122070312, "High" : 957.4000244140625, "Low" : 944.5499877929688, "Close" : 951.2999877929688, "Volume" : 6650442 }
{ "_id" : ObjectId("652bb11871d8e09ad65abc1b"), "Timestamp" : ISODate("2023-10-12T18:30:00Z"), "Open" : 949.9500122070312, "High" : 957.4000244140625, "Low" : 944.5499877929688, "Close" : 951.2999877929688, "Volume" : 6650442 }
{ "_id" : ObjectId("652bb49c71d8e09ad65abc1d"), "Timestamp" : ISODate("2023-10-12T18:30:00Z"), "Open" : 949.9500122070312, "High" : 957.4000244140625, "Low" : 944.5499877929688, "Close" : 951.2999877929688, "Volume" : 6650442 }
{ "_id" : ObjectId("652bbf2871d8e09ad65abc1f"), "Timestamp" : ISODate("2023-10-12T18:30:00Z"), "Open" : 949.9500122070312, "High" : 957.4000244140625, "Low" : 944.5499877929688, "Close" : 951.2999877929688, "Volume" : 6650442 }
{ "_id" : ObjectId("652bc2ac71d8e09ad65abc21"), "Timestamp" : ISODate("2023-10-12T18:30:00Z"), "Open" : 949.9500122070312, "High" : 957.4000244140625, "Low" : 944.5499877929688, "Close" : 951.2999877929688, "Volume" : 6650442 }