
Geschlossen
Veröffentlicht
Bezahlt bei Lieferung
I need an Excel workbook that can price every listed F&O option—both equities and indices—in a single sweep. The model must pull stock price, strike, risk-free rate, time to maturity, and volatility automatically through an external data source or API, then run the Black-Scholes formula and return the option price along with delta and gamma for each contract. You’re free to use native formulas, VBA, Office Scripts, or a combination, as long as the sheet stays responsive when thousands of rows refresh. A refresh button that triggers the API call and recalculates all results would be ideal. Deliverables: • Fully-functional Excel file with embedded or linked code • Clear setup notes covering any API keys, data-mapping, and update frequency • A short demo or screen-capture confirming that the sheet prices every contract accurately Acceptance criteria: after I paste a list of tickers and their option chains, hitting “Refresh” should fetch the latest market inputs, populate the sheet, and calculate price, delta, and gamma correctly within seconds.
Projekt-ID: 40063926
8 Vorschläge
Remote Projekt
Aktiv vor 28 Tagen
Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
8 Freelancer bieten im Durchschnitt ₹988 INR für diesen Auftrag

With my extensive experience in Excel and Excel VBA, I'm confident I can design a highly efficient workbook that meets your needs. My proficiency in creating interactive spreadsheets and streamlining processes through macros will ensure your Black-Scholes Bulk Calculator is both automated and responsive. I've successfully built similar tools before, leveraging my skills in VBA to interface with external data sources and APIs to pull real-time market data. In addition, my command over Visual Basic and Visual Basic for Applications allows me to create scripts that encompass complex functionalities like the Black-Scholes formula. This, combined with my knack for producing clean and well-documented code, ensures maintainability and scalability of the tool over time. Moreover, my background in Business Intelligence using Power BI has empowered me to use data from various sources optimally, so you can be assured that not only will the tool pull stock prices, strike rates, risk-free rates, times to maturity, and volatilities accurately but it will also calculate option prices, delta, and gamma at a breakneck speed. To wrap it all up, I'll provide detailed notes on the setup process along with a comprehensive video demo of the tool operating flawlessly. Let's streamline your option pricing process together!
₹1.050 INR in 1 Tag
2,9
2,9

I can deliver a fast, production-ready Excel Black-Scholes bulk calculator designed to handle thousands of F&O option contracts in a single refresh. I will build an optimized Excel workbook using a combination of VBA + native Excel formulas to ensure high performance and responsiveness. The sheet will automatically fetch spot price, strike, risk-free rate, time to maturity, and implied volatility via a configurable market-data API (such as NSE-compatible data providers or other financial APIs you prefer). A dedicated Refresh button will trigger the API calls, populate all inputs, and recalculate option price, delta, and gamma using the Black-Scholes model within seconds. Calculations will be vectorized and screen-updating minimized to keep the workbook responsive even with large option chains. Deliverables include: • Fully functional Excel file with clean, well-documented VBA • Clear setup instructions for API keys, data mapping, and refresh frequency • A short screen-capture demo showing bulk pricing in action I have hands-on experience building Excel-based financial models, VBA automation, and API-driven analytics, and I’ll ensure accuracy, speed, and ease of use.
₹1.050 INR in 2 Tagen
0,0
0,0

I can build a high-performance Excel workbook that prices listed equity and index options using the Black-Scholes model in a single sweep. The solution will automatically pull all required inputs (spot price, strike, risk-free rate, time to maturity, and volatility) from a reliable external data source/API, then calculate option price, delta, and gamma accurately for each contract. I will use an optimized mix of native Excel formulas and VBA/Office Scripts to ensure the sheet remains fast and responsive even with thousands of rows. A dedicated “Refresh” button will trigger the API call, update market data, and recalculate all results within seconds. Deliverables will include a clean, well-documented Excel file, clear setup notes for API keys and data mapping, and a short demo confirming correct pricing and Greeks across the full option chain. I focus on accuracy, performance, and clarity to ensure the tool is reliable and easy to maintain
₹600 INR in 7 Tagen
0,0
0,0

i can solve it by any of the method as u like as i am pro in this field since 5 year ago so i will fulfil your need in short and quick time
₹1.050 INR in 4 Tagen
0,0
0,0

Hello Sir, I have carefully read your project. I am new but very honest and hardworking. I can complete your work accurately and on time. Please give me a chance to prove myself. Thank you.
₹1.000 INR in 40 Tagen
0,0
0,0

Hyy sir , Iam a beginner in this field but if you can trust my work i did not disappoint you . Thankyou
₹600 INR in 2 Tagen
0,0
0,0

I can create an Excel-based Black-Scholes bulk option pricing calculator with accurate Call & Put pricing and support for large datasets. The model will be clean, fast, and easy to use, with clearly structured inputs and outputs. Optional Greeks and VBA automation can be included if needed. I ensure accuracy, performance, and timely delivery. Looking forward to working with you.
₹1.050 INR in 7 Tagen
0,0
0,0

Subject: High-Performance Black-Scholes Engine | VBA Array Processing | < 2s Latency Hi, I am a Financial Systems Developer with strong experience in Quantitative Finance and high-performance Excel VBA automation. I am bidding to build your Black-Scholes bulk calculator with a focus on speed, stability, and accuracy. I understand the core issue: running Black-Scholes and CDF functions on thousands of rows with live API data often freezes Excel or takes minutes to calculate. My approach: • Fetch the full option chain in a single API call using WinHttpRequest (NSE/Yahoo), avoiding slow cell-by-cell queries. • Perform all Black-Scholes calculations (d1, d2, N(d1), N(d2), Price, Delta, Gamma) entirely in memory using VBA Variant Arrays. • Write results back to the worksheet in one instant operation to keep Excel responsive. Why this works: ✔ Processes 5,000+ contracts in under 2–3 seconds ✔ Prevents “Not Responding” and crashes ✔ Uses standard cumulative normal distribution logic for precise Greeks Deliverables: • Optimized .xlsm workbook with Refresh button • Fully unlocked VBA module • API setup guide I am based in Hyderabad, Telangana (India). I usually work directly with clients and do not use Freelancer for my personal projects, so please ignore profile completeness and evaluate me by my work and technical approach. I can share a demo of a similar Greeks calculator and can start immediately. Best regards, Nirmal Siddh
₹1.500 INR in 7 Tagen
0,0
0,0

Rohtak, India
Mitglied seit Nov. 25, 2024
₹600-1500 INR
₹1500-12500 INR
₹600-1500 INR
$2-8 USD / Stunde
$250-750 AUD
₹100-400 INR / Stunde
$750-1500 USD
₹600-1500 INR
$250-750 USD
$15-25 USD / Stunde
$15-25 USD / Stunde
$15-25 USD / Stunde
₹1500-12500 INR
₹2000-6500 INR
$1500-3000 USD
$10-30 CAD
₹1500-12500 INR
₹600-1500 INR
₹600-1500 INR
₹2000-6000 INR
£20-250 GBP
₹600-1500 INR
$15-25 USD / Stunde