Using this spreadsheet you csn create your own portfolio trading any combination of the 72 contracts reported below and immediately review 2014-2022 performance.
-
- Download and enable editing (allow 15-45 seconds)
- Enter markets and number of contracts traded in columns I-K rows 19-43
- Minimum start balance shows in cell H-29 or enter your own in cell H-19
- Cumulative profit net of all spreads and fees, cell H-20
- Drawdown cell H-22
- Risk tolerance (what you should be prepared to risk) cell H-30
- Monthly and annual performance columns B-H
- Performance by market columns l-IX
2) Individual market Jan 2014-Oct 2022 net performanc by contract & period traded
-
- Click on net gain for that market/time period example $601,321 a spreadsheet opens containing all data, calculations, trade-by-trade, monthly, and annual performance.
- Performance represented is trading a single contact deducting a minimum of $50.00 per trade for bid/ask spreads and brokerage.
- Drawdowns are measured from the highest high to lowest low prior to recovery
| Contracts & Margins |
Current Margin | 1 Hour Net Gain |
Draw- down |
3 Hour Net Gain |
Draw- down |
5 Hour Net Gain |
Draw- down |
| ES SP 500 | $11,000 | $601,321 | ($21,239) | $408,801 | ($17,905) | $388,657 | ($28,750) |
| ET SP 500 Micro | $1,100 | $60,132 | ($2,124) | $40,880 | ($1,791) | $32,968 | ($3,773) |
| NQ Nasdaq | $16,500 | $722,590 | ($36,500) | $486,540 | ($36,315) | $352,538 | ($35,238) |
| NM Nasdaq Micro | $1,650 | $72,259 | ($3,650) | $48.654 | ($3,662) | $35,54 | ($3,524) |
| GC Gold 100 | $7,150 | $348,340 | ($14,420) | $299,710 | ($18,060) | $269,438 | ($30,000) |
| QO Gold 50 | $3,575 | $174,170 | ($7,210) | $149,855 | ($9,030) | $134,719 | ($15,000) |
| GR Gold 10 | $715 | $34,834 | ($1,442) | $29,971 | ($1,806) | $26,944 | ($3,000) |
| SI Silver 5000 | $8,250 | $437,205 | ($17,960) | $323,290 | ($29,088) | $333,378 | ($30,188) |
| QI Silver 2500 | $4,125 | $218,603 | ($8,980) | $161,645 | ($14,544) | $166,689 | ($15,189) |
| SO Silver 1000 | $1,650 | $87,441 | ($3,592) | $64,746 | ($5,817) | $71,176 | ($6,038) |
| HG Copper | $6,050 | $264,144 | ($15,043) | $153,513 | ($18,138) | $151,553 | ($17,165) |
| QC Mini Copper | $3,025 | $132,073 | ($7,521) | $76,756 | ($9,069) | $75,776 | ($8,583) |
| QL Micro Copper | $605 | $26,414 | ($1,504) | $15,351 | ($1,814) | $15,155 | ($1,717) |
| A6 AUD | $1,980 | $164,060 | ($5,980) | $92,695 | ($6,900) | $80,976 | ($5,980) |
| D6 CAD | $1,320 | $97,700 | ($4,625) | $83,005 | ($6,740) | $75,578 | ($4,705) |
| S6 CHF | $4,015 | $250,119 | ($7,800) | $143,895 | ($5,610) | $158,613 | ($11,238) |
| E6 EUR | $2,915 | $283,387 | ($6,550) | $159,293 | ($11,250) | $149,371 | ($11,444) |
| E7 Mini EUR | $1,457 | $141,694 | ($3,275) | $79,646 | ($5,652) | $74,686 | ($5,722) |
| B6 GBP | $2,475 | $175,306 | ($4,450) | $135,106 | ($7,238) | $88,158 | ($6,738) |
| J6 JPY | $3,025 | $216.494 | ($5,325) | $135,744 | ($7,388) | $108,853 | ($8,581) |
| J7 Mini JPY | $1,512 | $108,247 | ($2,663) | $67,871 | ($3,694) | $54,426 | ($4,291) |
| DX USD | $2,090 | $146,870 | ($4,295) | $109,980 | ($6,195) | $93,688 | ($5,648) |
| CL Crude Oil | $9,460 | $327,480 | ($25,330) | $296,620 | ($15,870) | $287,610 | ($20,690) |
| QM Crude Mini | $4,730 | $163,740 | ($12,665) | $148,310 | ($7,935) | $143,805 | ($10,345) |
| CY Crude Micro | $946 | $32,748 | ($2,533) | $29,662 | ($1,587) | $28,467 | ($2,069) |
| Disclosure | |||||||
3) Any allocation can be traded automatically for your account.
4) Using any reasonable maintenance balance
5) About Automated trading Accounts (ATAs) how they work and fee structure.
If you have any questions contact me.
Peter Knight Advisor
My current date and time November 26, 2022 4:28 pm
Direct VI Phone 24/7 +340 244 4310
Skype:: Peter Knight Advisor
Message me
Peter_Knight@peterknightadvisor.com
English
Arabic
Chinese (Simplified)
Chinese (Traditional)
Czech
Danish
Dutch
Finnish
French
German
Greek
Icelandic
Indonesian
Italian
Japanese
Korean
Norwegian
Portuguese
Russian
Spanish
Swedish