
Closed
Posted
I need a clear, independent audit of my stock-portfolio model that focuses strictly on performance evaluation—no compliance or risk review at this stage. You will dig into the historical trades, benchmark the returns, and validate the calculations behind metrics such as CAGR, Sharpe/Sortino ratios, alpha, beta, and drawdown figures. Your analysis should culminate in two concise deliverables: • A spreadsheet (Excel, Google Sheets, or Python notebook) that recreates the performance calculations step-by-step so I can trace every formula. • A short written report (PDF) that interprets the numbers, highlights any discrepancies you find, and offers recommendations to improve reporting accuracy. I already have transaction data, benchmark indices, and the original model logic ready to share. Familiarity with tools like Bloomberg, Morningstar, or similar data APIs will help you cross-check figures quickly, but use whatever you are most comfortable with as long as the final numbers are reproducible. When you reply, please keep it brief and focus on your direct experience auditing or back-testing equity portfolios.
Project ID: 40761831
20 proposals
Remote project
Active 21 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
20 freelancers are bidding on average ₹958 INR/hour for this job

Rebuild each metric from the raw trades independently in Python, then diff against your model so every discrepancy traces to one formula. Usual culprits I'll check first: dividends, cash flows (time- vs money-weighted), annualisation and risk-free conventions. Day 2: notebook with CAGR and drawdown for you to compare; day 7: full notebook plus PDF. 1. Were there deposits or withdrawals mid-period? 2. Daily or monthly returns in the Sharpe/Sortino calcs? Send the files over chat and I can start on them today.
₹860 INR in 7 days
7.9
7.9

Hi, CnEL India can help independently validate your stock-portfolio performance model using Python and Excel, with a focus strictly on performance calculations. Our methodology: * Review transaction data, benchmark indices and the original model logic. * Reconstruct portfolio returns and benchmark comparisons step by step. * Validate CAGR, Sharpe/Sortino ratios, alpha, beta and drawdown calculations. * Check return frequency, cash flows, missing data and formula consistency. * Compare results against the original model and document discrepancies. * Build a reproducible Excel workbook or Python notebook with traceable formulas. * Prepare a concise PDF report explaining the findings and recommendations for more accurate performance reporting. We would begin by reviewing the data structure and calculation methodology, then validate each metric and deliver the workbook and report. Regards, CnEL India
₹1,000 INR in 80 days
6.0
6.0

I will conduct an independent performance audit of your equity portfolio model, re-verifying historical trades, benchmark returns, and calculations for CAGR, Sharpe/Sortino, alpha, beta, and drawdown against the raw data. My approach: I will perform a step-by-step calculation of each metric using Python/pandas and Excel, while also reviewing benchmark alignment, cash flows, and annualization assumptions. If discrepancies arise, I will document their causes and suggest reporting improvements. The final deliverable will include a formula-traceable spreadsheet or notebook and a concise PDF report outlining findings and recommendations. A few questions: 1. Are daily/monthly returns available for the portfolio, or only transaction-level trade data? 2. Which benchmark index and risk-free rate have been used? 3. Was the original model built in Excel, Python, or another platform? I will focus on verifiable calculations, clear assumptions, and reproducible results. I will share verified examples of relevant portfolio audit experience and present conclusions based on your data.
₹750 INR in 40 days
5.7
5.7

As an experienced full-stack developer with a nuanced understanding of data science and finance, I believe I'm the perfect candidate to audit your stock portfolio performance. My track record spans across efficient data entry, data processing and manipulation using Excel and Python. Utilizing my abilities would ensure that every historical trade, from transaction data to benchmark indices, is meticulously reviewed against the original model logic for impeccable accuracy. My proficiencies in programming languages such as Python will play a key role in this task, allowing me to recreate your performance calculations in an easily traceable manner. Furthermore, my strong familiarity with platforms like Bloomberg and Morningstar brings added value by enabling me to use similar data-APIs to cross-check your figures swiftly. However, I am more than willing to use the platform you are most comfortable with minus any compromise on the precision of the final numbers.
₹750 INR in 40 days
3.0
3.0

Hi, I can independently validate your equity portfolio performance model with a strong focus on **reproducible calculations and benchmark comparison**. I’ll review the transaction history and rebuild the performance calculations step-by-step, covering: • Portfolio and benchmark returns • CAGR and annualized returns • Sharpe and Sortino ratios • Alpha and beta • Maximum drawdown and recovery periods • Benchmark-relative performance • Treatment of cash flows, dates and compounding • Identification of formula/data discrepancies You’ll receive a transparent **Excel/Python calculation model** where each metric can be traced back to the underlying data, plus a concise PDF report explaining findings, discrepancies and recommendations for improving reporting accuracy. I’ll validate the methodology rather than simply reproducing the existing model’s output, and clearly document assumptions such as benchmark alignment, risk-free rate and return frequency. I’m ready to review your transaction data, benchmark series and current model logic.
₹1,000 INR in 40 days
1.6
1.6

I can deliver 'Audit Stock Portfolio Performance' end to end — clean architecture, tests, and deployment. I'll start with a short plan, share progress daily, and hand over production-ready code. Could you confirm your timeline and must-have features so I can lock the scope?
₹950 INR in 7 days
0.0
0.0

Validating the maths is the real job here, so I would rebuild the metrics from your trade history rather than re-checking your spreadsheet against itself. I have done this kind of work before - reconstructing a returns series from raw trades, checking that dividends, splits and fees are handled consistently, then recomputing CAGR, Sharpe, Sortino, alpha, beta and drawdown to see exactly where your model diverges from an independent calculation. Two things decide the method, and I would like your call on them: which benchmark and risk-free rate should I use, and does your trade log include fees and corporate actions? You would receive the spreadsheet with my rebuilt figures side by side with yours, plus a short written note on every formula or assumption that changes the numbers, so the difference is explainable rather than just flagged. Timeline: 4 days from receiving the trade log.
₹750 INR in 30 days
0.0
0.0

As a seasoned finance professional with an extensive 37-year career, my expertise aligns perfectly with your project needs. My proficiency in financial analysis goes hand in hand with the skills required to undertake a comprehensive and meticulous audit of your stock portfolio. In my various roles, I have developed a knack for detail-oriented work, which will allow me to accurately validate and interpret the key metrics that you require. More specifically, my experience in conducting monthly variation analysis and group audit support will lend me the necessary skills to evaluate your historical trades from multiple angles and identify potential discrepancies. The final spreadsheet and report I provide will be meticulously prepared and explained to such an extent that you can retrace every calculation made. Moreover, while I may not be directly familiar with every tool mentioned like Bloomberg or Morningstar, I assure you that I am adaptable and quick at learning new systems. Utilizing my preferred tools such as Excel or Python coupled with the API data from these tools will ensure the utmost efficiency in cross-checking figures. Transparency is crucial during auditing projects, so I promise a thorough and accessible workflow that prioritizes traceability and reproducibility. Ultimately, choosing me means opting for experience, meticulousness, and diligent professionalism every step of the way.
₹1,100 INR in 40 days
0.0
0.0

Hi, I am a public accountant and web programmer. I can review your portfolio model with a focus on traceable calculations and reporting accuracy. Using your supplied transactions, benchmarks and model logic, I would rebuild the return series, check cash flows, dividends and fees, and validate CAGR, Sharpe/Sortino, alpha, beta and drawdown under clearly documented assumptions. You would receive an Excel workbook with transparent formulas and a concise PDF explaining discrepancies and recommended reporting corrections. Please share the model structure, data volume and reporting period so we can agree the scope and delivery schedule before acceptance. My initial availability is up to 5 hours per week, with communication by messages.
₹750 INR in 5 days
0.0
0.0

The key to auditing your portfolio is reconciling trade-level returns with benchmark data before trusting CAGR, Sharpe/Sortino, alpha, beta, or drawdown figures. I’ll rebuild the calculations in Python or Excel, document each formula, align benchmark periods, and check annualization, risk-free-rate assumptions, and drawdown methodology. This helps identify calculation errors before they distort your performance report. My workflow: 1. Validate transaction data and the original model logic. 2. Recalculate metrics and compare results against the supplied benchmarks. 3. Deliver a reproducible workbook/notebook and concise PDF with discrepancies and reporting recommendations. Within 48 hours of receiving clean sample data, I can provide an initial reconciliation and confirm the full audit scope. I’ll keep every calculation traceable and distinguish verified findings from assumptions. Direct portfolio-audit experience is UNVERIFIED, so I won’t overstate it. Could you share the transaction-data format and the benchmark frequency? I can then confirm the timeline and begin with the funded review.
₹1,250 INR in 10 days
0.0
0.0

Hi! Messy data from two different sources is exactly where projects go wrong — mismatched formats, duplicate entries, categories that don't align. I'll turn your website + survey data into a clean, template-ready dataset you can actually analyze. Here's exactly what I'll do: 1. Map every field from both sources into your template — no forced fits, no lost data 2. Standardize everything: date formats, category names, number formats; duplicates removed 3. Row-by-row quality check with a change log, so you can see precisely what was cleaned and why Why me: Excel data work is my daily craft — XLOOKUP, Power Query, pivot-ready structuring. You get data that's clean AND documented. I'll deliver the first cleaned batch (up to 200 rows) within 24 hours so you can verify quality before we continue — no risk on your side. One question: is your template final, or may I suggest structural improvements if I spot issues while working?
₹800 INR in 40 days
0.0
0.0

You want an independent check of your portfolio model's performance numbers (CAGR, Sharpe/Sortino, alpha, beta, drawdown) with every calculation traceable. My approach: first, load your transactions and benchmark data, rebuild the daily or monthly return series and reconcile it to your model's totals; second, recompute each metric step by step in Excel formulas (or a Python notebook if you prefer), using explicit assumptions such as risk-free rate, return frequency and benchmark; third, compare against your model's figures and flag every discrepancy with the likely cause. I work from the data you provide rather than Bloomberg or Morningstar feeds. My Freelancer portfolio has an Inventory/Purchasing Recon sample showing the same reconcile-and-flag method. Deliverables: the recreated spreadsheet, a short PDF with findings and suggestions for more accurate reporting, and a change log listing assumptions and any data corrections. I'd estimate about 10 hours. Which risk-free rate and benchmark index does your model use, and are the returns time-weighted or money-weighted?
₹1,200 INR in 10 days
0.0
0.0

Hi, keeping it brief as asked. I have no previous portfolio-audit job on Freelancer to show, so here is exactly how I'd check yours: 1. Rebuild every metric from the raw trades twice: an Excel workbook with plain step-by-step formulas (positions > daily value > returns > metrics) and an independent Python/pandas notebook. Both must match before anything goes into the report. 2. Test the usual failure points: - Deposits counted as performance. Example: 100k grows to 110k, you add 50k, the year ends at 170k. Naive return 70%, time-weighted 16.9%, Modified Dietz 16.0%. CAGR, Sharpe and drawdown belong on the time-weighted series; XIRR is reported separately as money-weighted. - Annualising: a daily Sharpe of 0.05 is 0.79 with sqrt(252), not 12.6. - Sortino using the std of losing days instead of downside deviation over all days. - Beta/alpha on misaligned dates, or a price index instead of a total-return benchmark. 3. Short PDF: each discrepancy, its size, cause and fix. First step, within 24 h of getting the data: reconcile the model's ending holdings and cash with the trade ledger, so inputs are confirmed before metrics. Is the original model in Excel or code, and roughly how many trades/years? Which risk-free rate and benchmark should the audit use, or should I verify the ones your model assumes?
₹800 INR in 10 days
0.0
0.0

Hi, I am Maryna, a full-stack developer and product manager. Your post asks for a performance check of a stock portfolio: historical trades, CAGR, Sharpe or Sortino, alpha, beta, and drawdown, delivered as a spreadsheet. It does not yet include the trade file. I can build that sheet, and I need the file before I start. Could you tell me: Can you send a sample of the trades, with dates, ticker, amount, and price? Do you already know which benchmarks to use, or should we choose them together? Do you want Excel or Google Sheets? If you have no preference, I would use Excel. I work and write in English. Let’s have a short call to agree the metrics. Fixed price ₹1,200, about 4 days after I receive the trades.
₹1,200 INR in 30 days
0.0
0.0

Mumbai, India
Member since Oct 11, 2026
₹12500-37500 INR
₹600-1500 INR
₹600-1500 INR
₹600-1500 INR
₹750-1250 INR / hour
₹12500-37500 INR
$250-750 USD
₹600-1500 INR
£250-750 GBP
€1500-3000 EUR
$15-25 USD / hour
₹12500-37500 INR
$200-600 USD
₹750-1250 INR / hour
₹750-1250 INR / hour
₹600-1500 INR
₹600-1500 INR
$2-8 USD / hour
₹150000-250000 INR
$250-750 USD