Jump to content

We have moved to Discord. Please click here to join us in the Trading Terminal Discord server.



These forums are read-only.

Search the Community

Showing results for tags 'spreadsheet'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • BEAR BULL TRADERS FORUMS
    • Bear Bull Traders - Members Only!
    • Welcome: Bear Bull Traders Forums
    • Members Introductions & Meetups
    • Day Trading
    • Swing Trading
    • Options Trading
    • Forex and Currency Markets
    • Trading Psychology
    • Off Topic
    • Success Webinar Questions
    • BBT en Español
    • Forum Support
    • BBT Trader's Challenge
  • CHI-TOWN BBT (Chicago, Illinois)'s Chicago Area BBT Topics
  • Pica Mucho BBT's Conversaciones
  • SINGAPORE's Topics
  • Denver, Colorado's Topics
  • BBT DC/DMV AREA's Topics
  • San Francisco Bay Area's Topics
  • BBT Toronto, ON's Topics
  • Texas BBT - Everything is bigger here's A club for Texas BBT members to get together
  • Texas BBT - Everything is bigger here's Let's try and organize some Meetups for the spring!
  • BBT Ottawa, Canada's Topics
  • BBT Vancouver, BC's Forums
  • BBT Australia's Topics
  • BBT - SoCal Traders's Topics
  • BBT MONTREAL, QC's Topics
  • NY Metro BBT's Topics
  • Seattle/Bellevue's Topics
  • BBT Detroit's Topics
  • Europe's Topics
  • North Carolina's Topics
  • the Ladies Lounge's Discussion
  • ARIZONA BBT's Discussions
  • BBT - United Kingdom's Topics
  • BBT - PORTUGAL's Regras
  • BBT - PORTUGAL's Apresentação
  • BBT - PORTUGAL's Geral

Marker Groups

There are no results to display.


Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Found 1 result

  1. As we progress as traders, we all develop our own ways of managing risk, establishing our rules and deciding on what trades to take. As part of my decision process, I have fairly unique way in which I decide my trade sizing that fits with my philosophy. So, let's start there. Part of risk philosophy is that I always want to take the same dollar risk on every trade, no matter the stop loss I set (or the price of the stock). In order to manage this, I have set up a simple spreadsheet (as part of my trade log) that allows me to quickly calculate the number of shares I should take to maintain a consistent risk target. A couple of notes. First, I do not take a trade based on my account size, the price of the stock or the capital required. I focus solely on the amount I am risking on the trade. I believe this allows me to balance my risk across my trades for the day and not find myself with something like 4 winners and 1 loser, but negative on the day since the loser was huge. All trades should deliver the same value, and carry the same risk. Some other traders do much the same using a concept of "trading units" or "risk units". Second, the risk I take on a any trade will always be consistent for the day and be part of my daily trading risk profile. Once I set these values pre-market, I will not change it for the day. I decide the values based on my previous performance, how I am feeling on the day, what other distractions I may have, and how long I am trading that day. (These parts of my philosophy I can explain at another time.) Here's an example. Assume for the day I have decided upon a profit target of $500 with a daily max loss of $300 and per-trade max loss of $100. Below is a sample chart. Let's say I want to go long $SQ off of the ABCD pattern presented and I am looking at taking a maximum of $100 risk (ie- max loss) on the trade, as per my plan. The current price is $90.35. A reasonable, but tight(!), stop-loss would be $90.05 (the bottom of the ABCD candles), or $0.30. Using my spreadsheet (below), I have set for the day my max $100 loss in cell C2. I simply plug the $0.30 loss target into cell C3, and cell C4 tells me I can take 330 shares. No more, no less! To deviate from this number would skew both the risk and potential reward I could expect from the trade. The only way I can change the share size is to either tighten my stop-loss (increasing the chance it'll be hit, but decreasing how far the stock has to move before I take profit), or loosening my stop-loss (which has the opposite effect). But, no matter what I decide, once I enter the trade, I WILL stick to that stop-loss target. My sheet has auto-calculated the target profit as I will always look for a trade that, at a minimum, delivers a 2:1 risk-reward ratio. This does mean that I have to be confident that $SQ has the possibility of going up at least $0.60. If not, I will pass on the trade. ) I keep this spreadsheet open in a small window on a secondary PC all day. This way, all I have to do is punch in the loss target number into C3 and it'll give me the shares I can trade. While simple, I find this keeps me focused and consistent on my share sizes and ensures I do not take a huge dollar risk on one trade and a lower risk on another. Because, as we all know, it'll be the big one that usually ends up to loser! I hope this helps. If you have questions or comments, please post them! If you have other calculators, please share! Below is a link to the spreadsheet. Remember to set your expectation low! It is simple. The spreadsheet also has a daily p&l log, a calendar that will trade you winning and losing days, and a couple of other tabs in case you find them useful. https://drive.google.com/open?id=1qqTPpgUU2sDf-t8-yKso33KIwdfmL2rF Happy trading!
[[Template core/front/global/mobileNavigation is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]]

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.