
Suljettu
Julkaistu
I want to pull every step of my equity-only trading workflow into a single LibreOffice Calc workbook so I can size positions, control risk and monitor portfolio exposure at a glance. The sheet must work entirely with long positions in listed securities (no margin, CFDs, or other leverage) and assume capital is continually “reduced” as open risk is committed. Core logic I need built in • Risk per trade expressed simultaneously as a % of available capital and a dollar amount. • Automatic position sizing from current reduced capital so that each entry, as well as two additional pyramid entries, respects the chosen risk %. • Maximum open risk per position enforced as both a % and $ figure, with real-time checks against reduced capital. • ATR-driven stop loss, trailing stop and pyramid entry levels – default to 3×ATR but editable per trade. • Break-even price calculation that updates when pyramid units are added. • Time-based stop that flags a position X weeks after entry if neither target nor stop has triggered. Trade & portfolio tracking • Brokerage costs on both buy and sell legs. • Live P/L per trade plus an overall summary that shows: – Number of open trades – Initial capital, reduced capital, closed trade P/L and open trade P/L (open P/L referenced to current stop, not last price) – Available cash at bank and total market value. • Security ticker and name fields for every leg. • Automatic calculation of quantity to buy/sell, pyramid ATR increments and %-of-equity triggers. Sheet structure I have in mind 1. Input sheet for global parameters (initial capital, default ATR multiple, max % capital per position, etc.). 2. Trade log where I enter symbol, dates, prices and ATR; the sheet returns quantity, stop levels, pyramid triggers and risk figures. 3. Portfolio dashboard aggregating all open positions and highlighting any breaches of risk rules. Acceptance check The workbook should open in LibreOffice 7+ without macros disabled, run on native Calc formulas (no external plugins), and reproduce the calculations from three historical trades I will supply as test data within ±1 unit of quantity and ±0.01 currency variance.
Projektin tunnus (ID): 40150201
5 ehdotukset
Etäprojekti
Aktiivinen 20 päivää sitten
Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
5 freelancerit tarjoavat keskimäärin ₹950 INR/tunti tätä projektia

With a passion for data analysis and a knack for devising cutting-edge solutions, I humbly apply to develop your LibreCalc Stock Position Sizer. Having worked extensively with LibreOffice Calc and its native functionalities, I assure you compliance will remain unhindered by macro or plugin issues. Furthermore, I'm well-acquainted with equity trading workflows and risk management techniques - skills that are profoundly aligned with the core logic of your project. Your project's spreadsheet structure aligns neatly with my aptitudes. From constructing global parameters to tracking individual trades and summarizing portfolio outcomes - my attention-to-detail will ensure seamless integration between all three sheets. Moreover, my proficiency in managing databases would add even more efficiency to your tracker, leaving no room for any breach in risk rules. To demonstrate the efficacy of my implementation, I'd love to accept the acceptance check challenge you've set forth. My historically accurate analysis guarantees that the position sizing and stop levels calculated for your test trades will not deviate by more than a unit or 0.01 currency variation. Trust me with your project and let's create a Portfolio Dashboard that reflects both your expectations and trading prowess!
₹1 000 INR 40 päivässä
0,0
0,0

Hello, I can build your equity-only trading workflow into a single LibreOffice Calc (7+) workbook using native formulas only (no macros, no plugins). I understand your requirement that capital is “reduced” as open risk is committed, and all calculations must work for long-only listed securities without leverage. I will create: 1) A Global Inputs sheet (initial capital, risk %, ATR multiple defaults, max open risk rules, brokerage costs, etc.) 2) A Trade Log sheet where you enter symbol, dates, entry prices, ATR, and the sheet automatically returns: - Risk per trade in % and $ - Position sizing from reduced capital - ATR-based stop, trailing stop, and 2 pyramid entry levels (editable) - Break-even updates after pyramid adds - Time-based stop flag after X weeks - Buy/sell quantities and brokerage costs 3) A Portfolio Dashboard that aggregates open positions, shows reduced capital, open/closed P&L, market value, cash, and highlights any breaches of max risk rules in real time. I will validate the workbook against your 3 historical trades and ensure results match within ±1 unit quantity and ±0.01 currency variance. I can deliver within your timeline and keep the workbook clean, structured, and easy to use. Ready to start as soon as you share the test trades and your preferred brokerage cost model. Thank you.
₹1 000 INR 40 päivässä
0,0
0,0

With a strong background in data analysis and excel , I specialize in turning messy datasets into actionable insights. my core skills include Advanced formulas; VLOOKUP/XLOOUP, logical functions. data cleaning, visualization, iam available to start immediately and can ensure a quick turnaround with high accuracy. best regards.
₹1 000 INR 40 päivässä
0,0
0,0

I can build your complete equity-only trading workflow into a single LibreOffice Calc workbook (Calc 7+), using ONLY native formulas (no macros/plugins): reduced-capital position sizing, ATR-based stops, pyramiding entries and a portfolio dashboard. I also have relevant experience as a Management Trainee at MCX (Surveillance & Investigation), where I worked on market monitoring, analytical reporting and risk-related checks — so your risk/sizing logic is very familiar to me. What I’ll deliver: • Global Parameters sheet (capital, risk %, ATR multiple, brokerage, max risk limits, time-stop weeks) • Trade Log sheet → auto qty, risk ($ + %), stop levels, trailing stop, pyramid triggers, breakeven updates • Portfolio Dashboard → open trades, reduced capital, cash/market value, open/closed P&L (open P/L referenced to current stop), risk breach flags I’ll validate results using your 3 historical trades and ensure outputs match within ±1 qty and ±0.01 currency. Questions: 1. Brokerage: % of turnover or fixed per order (or both)? 2. Pyramids: equal risk per add or fixed fraction? Ready to start immediately. Thanks, Ankur Mahajan
₹750 INR 40 päivässä
0,0
0,0

Bhubaneswar, India
Liittynyt tammik. 15, 2026
₹12500-37500 INR
₹750-1250 INR/ tunnissa
₹12500-37500 INR
₹1500-12500 INR
$30-250 USD
$100 USD
₹1500-12500 INR
₹750-1250 INR/ tunnissa
$750-1500 USD
$10-30 CAD
₹600-1500 INR
€30-250 EUR
₹12500-37500 INR
$30-250 USD
$30-250 USD
₹400-750 INR/ tunnissa
$15-25 USD/ tunnissa
$15-25 USD/ tunnissa
₹750-1250 INR/ tunnissa
$250-750 USD
$15-25 USD/ tunnissa