User Guide

Version 1.0.4 | July 2026

Introduction

Welcome to QuantiSizer. This User Guide explains how to install, activate and use the software for automated position sizing, automated alert based risk management and money management.

System Requirements

Installation

  1. Download the QuantiSizer workbook from Download Link.
  2. Save it to your computer.
  3. Open the workbook in Microsoft Excel.
  4. If you see a yellow bar saying "SECURITY WARNING Macros have been disabled", please click "Enable Content" to use all features.
  5. If Excel is warning you that the "source is not genuine" or "untrusted". "Unblock in File Properties” as below,
    1. Close the Excel file.
    2. Right-click the file and select Properties.
    3. In the General tab, look for the "Security" section at the bottom.
    4. Check the Unblock checkbox and click Apply/OK.
    5. Open the Excel file.
  6. Complete User Access process.
  7. Read 'INDEX' sheet to understand all subsheets after access granted.

Getting Started with

Initial Setup for Setting Expected Capital Projection Path

  1. Enter your Initial Capital, Tracker_Start_Date, average premium price selection, Daily Total Target Points, Daily Max no. of Trades and Daily Total Loss Points.
  2. Change the Broker parameters as per yours or if any change as per SEBI.
  3. Adjust Buy/Sell Premium of range you prefer and under Brokerage setting as per selected Target Points so that to adjust per trade brokerage showing in Tracking_Status for Total Trades collectively. This is getting used only to create Expected Capital Projection so not a real Numbers.
  4. Change the daily per lot size under "Tracker_Inputs" "F" Column if about to change as per SEBI from respective date.
  5. Set Initial Buying Price to Capital Default Ratio Factor in "B19" and its further increasing by Number in "R21" under "Tracker_Inputs".
  6. Set Predefined Capital Levels in "U" column of "Tracker_Inputs".These are Levels of which capital when crosses the Initial Buying Price to Capital Default Ratio factor set by you will automatically increased securing your capital more on more as it crosses every next level.
  7. Allow QuantiSizer to calculate the recommended quantity.
  8. Mention Debit % if need to keep certain amount of profit aside in record and to use whenever necessary by withdrawal else keep 0.

Daily Basis Activities

  1. Add if any Day anounced as Holiday under Holiday List in "Tracker_Inputs" so that it will excluded from the system and no Position sizing data will populate on "Daily Trade Management".
  2. Every Trading Day before starting under "Daily_Trade_Count_Tracker" Mention Todays Total Quantity being used in "N7" and keep it same throughout the day do not change even in between you observe Auto populated quantity changed under "Daily Trade Management" so that to have "Daily_Trade_Count_Tracker" smooth automated calculation.
  3. Every Trading Day before starting under "Daily_Trade_Count_Tracker" Mention per trade aproximate brokerage in "N5" and adjust after every trade so that to match automated Total Brokerage showing in "O2"
  4. You can use Time Gap if wanted to give pause between two consecutive trades by mentioning Time Gap value in "N4" of "Daily_Trade_Count_Tracker" in minutes.
  5. Record your trades using the "Daily_Trade_Count_Tracker" after each trade completion, ensure you enter Sr. No. after each trade completion only once and complete all the details related to that trade entry then go for next Sr. No. entry with trade details after next trade completion only so that all trade details autocopy smoothly in Trade_Database and no duplication happens of any single trade details.
  6. Review your daily performance and Tracking_Status.
  7. Additionally you can use Withdrawal Feature only if Debit Feature is in use that is if % amount of profit kept aside logically not in real it will show how much withdrawal you have for expense in Tracking_Status "I" column according you can withdraw by mentioning amount and date in "Tracker_Inputs" sheet ensure to enter date first. If any amount entered wrong and need to changed can be done in "N" column of "Money_Management_Tracker" sheet.
  8. At a time use either "Debit Feature" OR "Direct Capital Withdrawal" in "Tracker_Inputs" sheet. You can mention directly direct withdrawal when done in "Direct Capital Withdrawal" column against respective date.
  9. If any Tax difference in Automated calculated Tax "J" column of "Money_Management_Tracker" as per your yearly expected Profit can be adjusted in "V" column of "Tracker_Inputs" by +/- the amount.
  10. Enter Daily profit/loss post brokerage manually in "Tracker_Inputs" OR by recording Trade details directly in "Daily_Trade_Count_Tracker". Recording Trade details will automatically keep Risk control as well as automatically create Trading Journal.

Key Features

Important Notes

Support

For support, feedback, or licensing queries, please use the Contact page available on the QuantiSizer website.

← Back to Home