Expected duration: 1 day or less I require someone to create a spreadsheet that tracks realized (completed) options trades.
*Please see below an image of what I require, with the correct formulas. I also need the data to create an equity curve (line chart showing profit/loss of the account) on another sheet showing % gain/loss and $ accumulation gain/decline. 1 chart by number of trades, and 1 chart by dates.
Please note in the example image, there is 1 last column not fully visible on the far right which is "cumalitive $" - this needs to also be included (and thus be able to create the equity curve)
"Kelly %" in the example, refers to Kelly Criterion (full) (formula can be found online). I would like an additional cell below that shows that number 1/10th below (i.e in the example it's 50.29%, therefore new cell below would also show 5.029%
I would like the same aesthetic appearence as the example (i.e colours, box seperations, etc.)
3D interior Visualization Category: 3D Design, 3D Layout, 3D Modelling, 3D Rendering, 3D Visualization, 3ds Max, Interior Design, Lighting Design, Photo Editing, Photoshop Budget: $15 - $25 USD
18-Sep-2025 16:01 GMT
Sheet Logic Specialist Needed Category: Data Analysis, Data Entry, Data Processing, Data Visualization, Excel, Google Sheets, Microsoft Office, Visual Basic Budget: ₹100 - ₹400 INR