This content is accessible for paid members only.
ARE YOU IN A TRIAL PERIOD? Due to the intellectual property and nature of our services, Trial members are restricted to 10 videos during this period
Login To Unlock The Content!
If you are already a "Free Member", CLICK HERE to upgrade your account
Hi,
when you say “We trade weekly expirations”, you mean that you trade weekly contracts instead of monthly? Or that you track expirations on a weekly basis since you open the trades over multiple weeks?
Thanks
We put on trades which expire in 30-40 days. But we add new trades each week. That way we have trades which close out every week. We trade both monthly and weekly contracts and do not differentiate between them
It says you can put in a trading value over 10 , however won’t allow any below 50. I do some 1 point spreads below 50 , is this hard to fix. I use an an iPad so won’t let me alter. Tried changing to excel but some of the formulas aren’t compatible. Thoughts?
Hi, once you copy the spread tracker, you have full admin access to make any changes you want. Which means you can also remove any data validations in the google sheets to suit your particular needs.
The expiry dates populate for every seven days: What happens if you have trades between these weekly dates. For example I have trades expiring on Jan 05 and Jan 07. How do I insert these dates with their necessary formulas?
We trade weekly spreads, so the sheet is designed to cater for the most common use case only. You can always copy/paste the row below and manually change the date (instead of letting the formula do it for you)
Pursuant to my question Dec 6, at 11:42am,
After I add a row with a new expiry date, the formulas on the right side do not automatically populate. How do I add them please. As in excel, is there a ‘fill down’ option?
If you watch the videos on how to use the spread tracker part 2, I have mentioned there how to add new rows with formulas. This sheet is designed to take care of the most common use cases only. Feel free to tweak it according to your specific needs.
How do you enter a put spread on the tracker? All the illustrations so far are for bull call
You would simply overwrite bull call with bear put and it will work.
Great, thank you!
I thought the old spread tracker was great, but this spread tracker takes an amazing tool to a whole new level. What blows my mind is how Nishant added a profit and loss column, so one can better visualize how one’s trading performance is going. I would advise everybody to take full advantage of the new and improved spread tracker.
Nishant, I know your well-versed in using Excel/Google sheets, but I was wondering if you would ever make a video that would show us how to make various Excell/ Google sheets that would cover various scenarios that you use in a daily, monthly, or annual basis that you have not shared with the group.