Rolling Options Record Keeper - Starting a new trade
VloĆŸit
- Äas pĆidĂĄn 2. 08. 2024
- Rolling Options Record Keeper - Overview and Entering a new trade. This spreadsheet tracks and charts the profit/loss of adjusting options trades by extending duration, rolling out in time and altering strike selection for optimal financial performance. Most traders can benefit from the visual workflow of this sheet which tracks, multiple contracts and allows the user to track a variety of different trades with preset options strategies including diagonal spreads and Leap Options.
đ° Join the members only chat room: / drawbridgefinance
đ Purchase Custom Spreadsheets: www.etsy.com/shop/drawbridgep...
đ° All my links: www.linktr.ee/drawbridgefinance
⏠Discount to Seeking Alpha Only $99/annually âŹâŹâŹâŹâŹâŹâŹâŹâŹ
âșwww.sahg6dtr.com/2RSPJ5/R74QP/
⏠BROKERAGES I USE âŹâŹâŹâŹâŹâŹâŹâŹâŹ
âșInteractive Brokers: www.interactivebrokers.com/mk... (Paid Link)
âșWealthsimple Trade for CANADIANS: Get $10 Free when you fund and trade $100 my.wealthsimple.com/app/publi...
⏠CONTENTS âŹâŹâŹâŹâŹâŹâŹâŹâŹâŹ
0:00 Intro
1:01 Where to Download the spreadsheet
2:21 Make your copy of the spreadsheet
3:07 Options Summary: DTE and A-Z
4:21 0Trade Comparison
4:52 0Trade Custom Blank & 0Trade Rolling Blank
6:45 Notes and how to delete them
7:28 Analyzing the trade AMD in the money put
9:30 Entering a Trade into 0Trade Rolling Blank
10:54 Cells that Require Date Formatting
13:08 Choosing a Strategy from the drop down: Row 12
14:50 Troubleshooting Red Cells
16:45 Quantity of Above Trade: Cell D28
17:34 Margin USD or CAD: Row 30
18:15 Estimated Options Return on Investment: Rows 33 - 38
18:52 Buy Back Target Ranges: Rows 39 - 41
19:29 Profit/Loss Chart
21:02 Commissions: Cell H2
21:31 Closing a Trade: Rows 42 - 57
22:59 Tracking the stock price move on the chart
⏠GREAT FINANCIAL BOOKS âŹâŹâŹâŹâŹâŹâŹâŹâŹ
âș Unlucky Investorâs Guide to Options Trading(Pre Order): amzn.to/3ETWQpa
âș Think and Grow Rich: amzn.to/2t285sL
âș The Wealthy Barber: amzn.to/2sW9XTM
âș The Millionaire Next Door: amzn.to/2HB6DTk
âș Rich Dad Poor Dad: amzn.to/2y5rD4S
âș Getting Started in Options: amzn.to/2LEJzWe
âș Smart Couples Finish Rich: amzn.to/2Eu1qgr
âș The Automatic Millionaire: amzn.to/2HcC5KU
⏠Trading Computer âŹâŹâŹâŹâŹâŹâŹâŹâŹ
âș LG OLED 48â 4k TV/Monitor: amzn.to/31lJPH8
âș Samsung 28â 4k Monitors: amzn.to/32QZL4r
âș Startech USB - HDMI (3rd Monitor): amzn.to/3EMBiKX
⏠Cameras âŹâŹâŹâŹâŹâŹâŹâŹâŹ
âș My New Canon RP: amzn.to/3mQwkqf
âș My New Canon 35mm Lens:amzn.to/3mRmg0d
âș Canon 80D: amzn.to/2HxdGNLâș Canon EF-S 18-135mm: amzn.to/2FhwsXd
âș Canon EF 50mm: amzn.to/2UyB5HM
âș Canon EF 100mm: amzn.to/2SnOjEG
âș Canon EF-S 10-18mm (VLOG Lens): amzn.to/2HuQ6B4
-- As an Amazon Associate I earn from qualifying purchases --
Subscribe to Drawbridge Finance on CZcams: czcams.com/users/Drawbridgef...
My primary investment strategy is long term high yield dividend investing, index funds and reducing risk and exposure using options. I have been actively trading the stock market for over 25 years and have built most of my wealth by reinvesting my dividends and following my 14 Personal Rules of investing. I actively trade options on both the American and Canadian Stock exchanges using options strategies and buying and holding high yield dividend paying stocks.
I generate monthly income in two ways. Averaging more than an annual 7% return by collecting dividends on high yield dividend stocks that I hold. The second income stream comes from the selling of option premium and taking advantage of theta decay. I love trading strangles, Iron condors and diagonal spread for maximizing returns. Delta neutral strategies allows me to make money in both bull and bear markets and limits my risk. Both of these strategies are suitable for passive income and create a stable predictable safe passive monthly income.
Want to learn how to trade stocks and make more money? This channel is dedicated to increasing investment returns and building wealth by passively trading in the stock market. If youâre tired of poor performance then make sure you subscribe to Drawbridge Finance czcams.com/users/Drawbridgef... I produce weekly videos for the beginner trader and use simple explanations to learn how I buy and sell stocks for profit.
Letâs Get Rich Together
Levi Woods
Disclaimer: I am not a financial planner and am not offering investment advice. This is an opinion channel only and should not be taken as any form of financial advice. I receive a small commission from the purchase of any item from using the links listed above. There are financial risks involved in taking on any monetary transaction that I discuss in my videos.
#optiontrading #stockmarket #investing
Thanks for the video, Levi. Iâve been using this spreadsheet for six months since it was given to us on Patreon and itâs been great. I rarely even use the brokerage software anymore to manage and review positions because this is better.
Thanks James!!!
Great one! One small hack - if you want to insert today's date in the date cell, just hit "cmd+;" and it wi;l insert it for you. I find it even faster then typing =)
Amazing!! Thanks for that
Thanks Levi!
Thanks Pierre. Hope youâre enjoying the spreadsheet.
Levi, I appreciate what you do to help investors. You make complex things simple. I've been using your "wheel" tracker for a month or so, and have saved lots of time in data entry. On another topic, do you know which of the major trading platforms supports automation of exiting option trades? Have you published a video on this topic?
beutifull work, can this spreedsheet track the price for futures like /es and /mes.? i do nake puts and the 112 and will be nice to have them on something like this . thanks
Yes it tracks /es spot price
Maybe I've missed it - How do I enter Futures like the /MES? Do I use the "/" as some platforms use or is there other special symbols needed? Do I use just MES or MESH4?
/MES will pull data if the futures data is turned on in the .0Strategytests sheets. Reach out via email if youâre having issues getting it loaded.
Thank you Levi for the video. Please, is it possible to combinate stocks with options in this spreadsheet? If yes, i am going to buy it right away :-)
Yes you can combine stock and options in the sheet. The cheapest way to purchase is to become a options tier patron for 1 month for $50 /USD. That way you get the rolling options record keeping spreadsheet and access to my private discord for the whole month including all my trade alerts. www.patreon.com/drawbridgefinance
Hello Levi, I'm relatively new to covered calls, and am primarily selling covered calls on dividend stocks. Your spreadsheets look very interesting and I am considereing purchasing your record sheet spreadsheet. I'm most interested in daily updating of the call prices and need software that automates collecting the stock price and asking price at day's end. Does your spreadsheet do that? Thanks....
I sell two spreadsheets that would likely interest you. Both pull the last traded prices of a stock based on the values provided by yahoo finance and high are updated every 15 minutes during market hours. .
The rolling options record keeper tracks open options and is primarily for determining entry and exit for active traders. The wheel option calculator is designed for the selling of long stock/covered calls and short puts and is designed for the long term tracking for those types of positions. Both sound like they would suit your needs. If you do decide to do the rolling options record keeper, the cheapest way to purchase is to become a options tier patron for a month which gives you the record keeper plus access to the discord chat room for the month. Hope that answers your question. If not reach out again. :)
Does this spreadsheet works with Canadian Stocks Listed in TSX?
The spreadsheet works with any stock as most of the information is manually entered and tracked. The stock price is automatically generated using google finance data so most TSX symbols work. Inputting TSX:ENB would return the price of Enbridge on the TSX. There is also colour coding built into the sheet so you can quickly see the USD and CAD options. I use both CAD and USD options on the same sheet all the time.
Can I use this Rolling Options Record Keeper for Indian Stocks and also change te currency to INR ?
It is designed to pull the market data of US stocks but you could easily change the coding to pull data from another source or over ride the automation. I don't lock my sheets so they can be customized for your liking. Changing currency etc. This would require knowledge of spreadsheet formulas.
Does the spreadsheet support futures options? ie. ES,NQ,CL, etc?
It doesnât pull futures prices real time as I donât have a good data source to pull the spot price of the future. If you know of a reliable website I would love to add that function as I trade options futures as well. The sheets are not locked so you can customize to suit your needs. I use it to track /CL and just move the decimal over on my credit because the default of the sheet is to calculate 100x and not 1000x.
Hi, wld this work for a futures options seller?
I trade different futures tickers such as /cl, /es, /zb with different multipliers. Let me know thanks!
My sheet is designed to track any trading style including futures. It will pull spot futures data from investing.com with a 15 minute delay. The multipliers are pulled from a sheet included in the record keeper that can be updated easily with any parameters you like. Itâs already formatted for the common futures list. Sounds like you should consider joining the discord chat where I post weekly futures and stock trade ideas.
We all know what comisions are; No need to waste any time on that issue.
Hi Levi.. can you please check the email I just sent you? Thank you
Hope youâre having fun testing it out.