Real-Time Excel VWAP Calculator - 16/02/2026 09:26 EST

₹600-1500 INR

Complété

Publié il y a 20 jours

₹600-1500 INR

Payé lors de la livraison

I’m a small-cap share trader and would like an Excel-based tool that calculates Volume-Weighted Average Price (VWAP) on the fly. The sheet only needs to work with two columns fed by my data provider: trade price and corresponding volume. As new ticks stream in, the VWAP should update instantly without requiring manual refresh. Core requirements • Accept a real-time data feed (I can pipe prices and volumes into designated cells; your solution should listen to those cells). • Perform continuous VWAP calculation during the session, resetting automatically at the start of a new trading day. • Keep the workbook fast and light—no charts or extra visuals, just the running VWAP output and today’s cumulative totals. • Solution can be built with native formulas, VBA, a lightweight add-in, or Power Query—whichever delivers the smoothest live update. Please comment the code clearly so I can tweak ticker lists later. Deliverable A ready-to-use .xlsx or .xlsm file plus any supporting VBA modules or add-in files, along with a brief usage note showing where to paste my streaming data and how the daily reset is triggered. I’m happy to test with sample data the same day you send it and will confirm acceptance when the VWAP updates in real time without lag.

Software Architecture

Visual Basic

N° de projet : 40234918

Concernant le projet

6 propositions

Projet à distance

Actif à il y a 20 jours

Cherchez-vous à gagner de l'argent ?

Adresse e-mail

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais

Soyez payé pour votre travail

Surlignez votre proposition

Il est gratuit de s'inscrire et de faire des offres sur des travaux

Décerné à :

@twinkleshah09

I can build a lightweight, real-time VWAP Excel tool tailored for your small-cap trading workflow. What I’ll deliver: Clean workbook that listens to your designated Price and Volume input cells. Instant VWAP calculation using an optimized approach Automatic daily reset based on system date or market open time (fully adjustable). Running cumulative totals Minimal, fast structure — no charts, no heavy objects. You’ll also receive a short usage guide showing: Where to pipe your streaming data How the reset logic works How to modify session times if needed I focus on performance and clean logic — ideal for live intraday trading environments. Ready to start immediately.

₹1 050 INR en 2 jours

0,0

(0 commentaires)

0,0

6 freelances proposent en moyenne ₹1 583 INR pour ce travail

@kaimenyijohn5

AM READY TO START: REAL-TIME VWAP CALCULATOR FOR LIVE TRADING DATA Hello, I am John K., a full-time financial automation specialist with over fifteen years of experience. I specialize in building lightweight, high-performance Excel tools for live trading data, including real-time VWAP calculations using VBA and formula-based solutions that update instantly without lag. My understanding is: You need an Excel-based tool that accepts live price and volume data streamed into designated cells, continuously calculates VWAP, automatically resets daily, and remains fast and lightweight with no extra visuals. I will deliver: ✅ A ready-to-use .xlsm file with commented VBA code for real-time VWAP calculation. ✅ Automatic daily reset logic and smooth performance during live sessions. ✅ A clear usage note showing where to paste your streaming data and how the reset works. I am ready to build this tool. Let's connect via chat to confirm your Excel version and data feed structure—I can deliver a working version for testing today. Respectfully, John K.

₹600 INR en 1 jour

5,0

(5 commentaires)

4,2

@dineshk743

Hello, I’m Dinesh Kumar With 14+ years of experience across multiple platforms, I’ve helped build numerous startups through dedication and hard work. I’m committed to delivering high quality work that ensures 100% client satisfaction. Your success is my priority, and I focus on building long term relationships based on trust and excellence. Expertise: Web & App Development – React.js, Node.js, JavaScript, PHP, MySQL, WordPress, Magento, CodeIgniter, Shopify, .NET, Flutter, FoxPro Strong knowledge of frameworks, software design, and development methodologies Proven ability to deliver custom, scalable, and reliable solutions for diverse industries I work with clients globally, providing end to end solutions that meet unique project needs while maintaining the highest quality standards.

₹1 050 INR en 7 jours

4,0

(4 commentaires)

1,1

@keaganmini

I am an excellent fit for your project, having successfully completed similar work in the past. Your need for a clean, user-friendly Excel tool that updates VWAP seamlessly with live trade price and volume data, resetting automatically for each trading day, is clear and well within my expertise. I specialize in Excel solutions using VBA for automation and lightweight performance. Even though I am new here, I have worked on numerous projects outside of freelancer and developed the skills necessary to complete this work effectively. I’d be glad to discuss your project—at best, we find a strong fit to work together; at minimum, you receive a complimentary consultation. Regards, Keagan.

₹700 INR en 14 jours