
Closed
Posted
Paid on delivery
I keep a substantial Excel 2021 workbook that tracks hundreds of tickers, blending technical and fundamental data. Michael Saunders’ Stock Connector add-in works, but its quotes are delayed and that makes my intraday models unreliable. I’m looking for a straightforward replacement that brings true real-time data straight into the existing sheets. The feed must cover NYSE and NASDAQ symbols as well as Russell, S&P and Dow constituents plus a few preferred shares. Both price/volume fields (open, high, low, last, bid/ask, volume) and key fundamentals (market cap, EPS, dividend, etc.) have to refresh automatically—ideally every few seconds, certainly no slower than once per minute. I’m flexible on the provider; Alpha Vantage, IEX Cloud and Yahoo Finance aren’t carved in stone and I’m happy to license another API if it delivers reliable streaming. What matters is that the new connection slips into my current workbook with minimal disruption, either by mirroring the Stock Connector function syntax or by giving me an easy, clearly documented migration path. Scope • Integrate a real-time market-data API with Excel 2021 via VBA, Power Query or a lightweight add-in. • Map incoming fields to my existing columns so dashboards, pivot tables and charts remain intact. • Allow simultaneous refresh of at least 200 tickers without freezing Excel. • Package the solution so I can move it to another PC (instructions, commented code, any required DLLs or COM objects). Acceptance Criteria 1. Quotes and fundamentals update within the same minute they appear on the exchange feed. 2. No broken formulas after migration. 3. Clear documentation covering setup, API key management and routine maintenance. If you’ve already connected Excel to streaming market data and know how to dodge API throttling, I’d love to see your approach.
Project ID: 39747817
52 proposals
Remote project
Active 7 mos ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
52 freelancers are bidding on average $483 USD for this job

As a seasoned Full Stack Developer with 7+ years of experience, including extensive work on various aspects of Excel, VBA and data processing, I am confident that I have the right skillset to meet and exceed your expectations for this project. I have a proven track record of developing custom solutions to streamline data processes for organizations like Metlife GOSC and DXC Technologies, which showcases my dedication towards improving data management and automation. Having worked extensively with APIs and web scraping, I understand the importance of a reliable real-time market-data feed for dynamic models. I assure you not only the integration of a suitable API into your current workbook with minimal disruption but also an effective system to sidestep API throttling to ensure no interruption in data retrieval. Moreover, my competency extends to packaging solutions for easy relocation, providing commentated code for better understanding and also in delivering clear and complete documentation for seamless maintenance. Couple this with my unwavering commitment towards employer satisfaction and you can be assured of getting a solution that caters to your specific needs while maintaining the integrity of your existing spreadsheets.
$500 USD in 7 days
8.6
8.6

Hello, As a seasoned team of developers and engineers, we understand the paramount importance of real-time data in market analysis. I am Mirza Muhammad of Live Experts®, and I have specialized expertise in data analysis, with a specific focus on using Excel and VBA for complex financial modeling. My proficiency in Visual Basic, Excel VBA, Data Processing, and Financial Analysis make me the ideal choice to integrate a vital real-time market-data API with your existing Excel 2021 workbook. To ensure that your intraday models remain reliable, I am well-versed in dodging API throttling by optimizing queries and implementing efficient solutions. Though Michael Saunders’ Stock Connector is functional, I understand how its delayed quotes hinder the efficacy of your models. With my skills and experience, I guarantee to create a more efficient and seamless stock feed within your current workbook that aligns with Alpha Vantage, IEX Cloud or any other API you prefer for live, accurate streaming. Moreover, our professionalism extends beyond just delivering quality work; we prioritize clear documentation ensuring that setups, API key management, and routine maintenance are all clearly instructed. Furthermore, the solution we'll provide will safeguard your excel formulas from breaking during migration. Overall, my extensive experience in real-time data management combined with my range of technological proficiencies makes me an ideal fit for this project. Thanks!
$750 USD in 6 days
7.0
7.0

HI, I create reliable and efficient Excel automation using VBA macros and advanced formulas customized to fit your exact needs and workflow. What I Can Help You With: Excel Automation & VBA Development VBA Development Excel Macros Automation Complex Formulas Custom Functions Dynamic dashboards, charts, and visual reports Pivot tables & data summaries Automating Repetitive Excel Processes with VBA Macros Custom Excel spreadsheets tailored to your needs Generating PDF Reports from Excel Data Converting PDFs to Excel Worksheet
$500 USD in 7 days
6.7
6.7

Hello, I understand you need a solution to bring real-time stock data into your Excel 2021 workbook efficiently. You want to replace the delayed feed from Michael Saunders’ Stock Connector with a reliable API that delivers timely updates for various tickers, including NYSE and NASDAQ symbols. My approach will include integrating a suitable market-data API using VBA or Power Query, ensuring that all necessary fields refresh automatically without disrupting your existing format. I'll map the incoming data to your existing columns to maintain the function of your dashboards and pivot tables, allowing for a seamless transition. It's essential that the new solution updates quickly and avoids freezing when refreshing multiple tickers. I will provide clear documentation for easy setup and future maintenance as well as instructions for transferring the solution to another PC with minimal hassle. What specific APIs are you currently considering for real-time stock data integration? Thanks, Shamshad
$750 USD in 22 days
6.5
6.5

Hi paradigmktg, Thank you for considering my proposal. With over 8 years of experience in Excel, I am confident in my ability to assist you with your project. I have carefully reviewed your requirements for integrating real-time stock feeds into Excel 2021 and ensuring seamless data updates. I would like to further discuss your project in detail and explore how I can help you achieve your goals. Please feel free to connect with me via chat to discuss the specifics of your project. Regards
$250 USD in 1 day
6.1
6.1

Hello sir, Did go through your job description and glad to share that I have enormous experience in working with Excel Real-Time Stock Feeds I'm a seasoned programmer and Engineer with quality experience in Flutter, React, Node.JS, SpringBoot, Frontend and Backend Development, Python, Matlab, R studio, C, C++, C#, OpenCV, OpenGL, Tesseract OCR, google vision, Statistical programming/R progamming data analysis Computing for Data Analysis Time Series & Econometric, Machine learning, AI, Deep learning, Matlab and Mathematica, 3D modeling, CAD, SolidWorks, Unity 3D, PCB, Electronics, Arduino, Automation, Embedded and Firmware , IOT, Electrical/Mechanical Engineering I am a TOP Rated Freelancer, and you can check my reviews here as well: https://www.freelancer.com/u/mzdesmag. Looking forward to potentially working together on this project. Thanks and Best regards, Adekunle.
$250 USD in 2 days
4.9
4.9

As an accomplished data analyst and a seasoned Excel user, I cannot think of a more fitting project for me than your comprehensive stock tracking on Excel 2021. I've worked with complex datasets before, employing a blend of technical skills and analytical power. The fact that you require real-time data and that your existing model and dashboards remain intact after migration aligns perfectly with my proficiencies. With years spent working directly with VBA, Power Query and extensive add-in experience, I can guarantee efficient integration of a dependable real-time market-data API into your workbook. Migrating from Michael Saunders’ Stock Connector add-in will be not only smooth but significantly improve the reliability of your intraday models. Moreover, my knack for providing comprehensive documentation will ensure you're well-equipped to manage your stock feeds and maintain the system effortlessly. Lastly, let me highlight my proficiency in managing large datasets without freezing Excel; crucial when you need interrogation of over 200 tickers simultaneously. The key to successful implementation in this project's case lies in the seamless synergy between the chosen API provider and your specific requirements; something I'm adept at doing. Your requirement is unique but not unfeasible; making me eager to take up this challenge & deliver a tailored solution for you.
$500 USD in 7 days
4.4
4.4

Hello Michael, I understand the importance of real-time data in your Excel 2021 workbook to ensure the reliability of your intraday models. I can create a seamless integration of a market-data API that will automatically refresh your price and fundamental data for hundreds of tickers, covering NYSE, NASDAQ, and more. Utilizing VBA and Power Query, I will ensure that the incoming data maps perfectly to your existing columns, preserving your dashboards and pivot tables. My approach will allow simultaneous refreshes of at least 200 tickers without any freezing or delay, ensuring your calculations remain accurate and timely. Moreover, I'll provide comprehensive documentation for setup, API key management, and routine maintenance to ensure a smooth transition to the new system. I’m confident that together we can enhance your current setup significantly without disrupting your workflow. What specific APIs are you currently considering, and do you have a preferred one among Alpha Vantage, IEX Cloud, or Yahoo Finance? Thanks, MAKSYM
$500 USD in 5 days
2.5
2.5

Hello, I can help you replace the Stock Connector add-in with a true real-time market data integration inside Excel 2021. ? Experience: I’ve built Excel VBA/Power Query solutions that connect to APIs (financial, logistics, CRM) and update dashboards automatically without breaking existing formulas. I’m comfortable handling 200+ simultaneous tickers with stable refresh performance. ? Approach: Connect to a reliable API (IEX Cloud, Alpha Vantage, or alternative low-latency provider). Map price/volume fields + fundamentals (OHLC, bid/ask, volume, market cap, EPS, dividend, etc.) to your current workbook structure. Ensure refresh frequency is every few seconds (≤1 minute), with no freezing on large ticker sets. Provide clear documentation and commented code so you can migrate the solution to another PC easily. ? Outcome: Seamless migration from Stock Connector (no broken formulas). Real-time feeds that keep your dashboards and pivot tables intact. A lightweight, reliable, and maintainable solution. Would you like me to also suggest the best API provider (cost vs. reliability) so you can minimize subscription fees while still meeting intraday performance needs? Best regards, Deepanshu
$450 USD in 7 days
2.2
2.2

I am a perfect fit for your project. I understand the need for real-time market data integration in Excel without disruptions. I offer expertise in connecting APIs seamlessly to Excel, ensuring live updates for over 200 tickers. While new to freelancing, I bring extensive off-site experience to deliver clean, professional solutions. I would love to chat more about your project! Regards, Byarne
$400 USD in 14 days
1.9
1.9

⭐Hi, I’m ready to assist you right away!⭐ I believe I’d be a great fit for your project since I’ve built Excel integrations that stream market data into live workbooks without breaking formulas. I can deliver a working prototype in 5–7 days and a full, documented migration in 2–3 weeks while keeping costs predictable. I’ve integrated real-time feeds (IEX, Polygon, and commercial vendors) into Excel using VBA, RTD/COM add-ins, and lightweight background services. I’ve also implemented batching, caching, and throttling strategies so hundreds of tickers refresh smoothly without freezing Excel. Right now your models suffer from delayed quotes and unreliable intraday signals. This causes bad decisions and wasted time. My solution will map real-time price and fundamental fields into your existing columns so dashboards, pivot tables, and charts keep working. I’ll focus on non-blocking updates for ~200+ tickers, detailed before/after testing, and step-by-step migration docs you can reuse on another PC. If you have any questions, would like to discuss the project in more detail, or would like to know how I can help, we can schedule a meeting. Thank you. Maxim
$500 USD in 7 days
2.0
2.0

I've successfully integrated real-time market data into Excel for high-frequency models using APIs like IEX Cloud and custom VBA add-ins, enabling fast, multi-ticker updates with minimal lag. I’ll connect a reliable, low-latency data source to your existing workbook with mapped fields that preserve your dashboards and formulas. Updates will auto-refresh within 60 seconds across 200+ tickers without freezing Excel, and I’ll provide full migration instructions with documented code for easy setup on any machine.
$500 USD in 7 days
0.6
0.6

Hi paradigmktg, I have carefully read your job description and I am confident I can handle this project successfully. With my skills and experience in Statistics, I will ensure the work is completed with accuracy, professionalism, and delivered on time. I always focus on providing quality results that meet client expectations and add real value. I have worked on similar projects before and understand the importance of clear communication, attention to detail, and reliability throughout the process. You can expect full dedication, regular updates, and a smooth workflow from my side. I am ready to get started right away and would be glad to discuss the project details with you. Best regards, Sidra
$500 USD in 7 days
0.0
0.0

Hello paradigmktg, I am Vishal Maharaj, with 20 years of experience in API Integration. I have carefully read your requirement for integrating a real-time market-data API with Excel 2021. To achieve this, I propose to use a combination of VBA and Power Query to seamlessly integrate the API with your existing workbook. By mapping incoming fields to your current columns, I will ensure that your dashboards, pivot tables, and charts remain intact. The solution will allow for the simultaneous refresh of at least 200 tickers without causing Excel to freeze. I will also provide detailed documentation for setup, API key management, and routine maintenance to ensure a smooth transition and operation. Please initiate a chat to discuss further details and get started on this project. Cheers, Vishal Maharaj
$500 USD in 5 days
0.0
0.0

Hi paradigmktg, I noticed your need for a seamless real-time market-data solution for your Excel workbook. This is right up my alley, having extensive experience integrating APIs for live data feeds into Excel for efficient trading models. This project aligns perfectly with my expertise in VBA and Power Query to ensure smooth integration and continuous updating of price/volume data and key fundamentals for over 200 tickers. I've successfully implemented similar solutions off-platform and can provide reliable real-time data without disrupting your current sheets. If this sounds like a good fit, I’d be happy to dive deeper into your ideas! Cheers, Leon Boshoff
$400 USD in 7 days
0.0
0.0

Dear Michael, I am excited about the opportunity to integrate a real-time market-data API into your comprehensive Excel workbook for tracking stock tickers. Your requirement for seamless, immediate updates to both price and fundamental data aligns perfectly with my expertise in API integration and Excel VBA. With my experience in creating efficient solutions for data-heavy applications, I will ensure that the API can refresh up to 200 tickers simultaneously without impacting performance. I will also provide thorough documentation to streamline setup and future migration. Warmest regards, Helen
$600 USD in 7 days
0.0
0.0

Hello , I have carefully reviewed your post and understand your requirements. You are seeking a developer with strong expertise in the skills relevant to this project. With over 10 years of experience in Excel, Excel VBA, Data Processing, Statistics, Financial Analysis, Data Analysis, Visual Basic and API Integration, I am confident that I possess the knowledge and abilities to contribute effectively. I am highly adaptable, a strong team player, and committed to delivering successful outcomes for your project. I am available to start immediately and can dedicate myself full-time to this role. I look forward to the opportunity to collaborate with you. Thank you for your time and consideration. Best regards, Rudolf
$555 USD in 4 days
0.0
0.0

Hello, As much as it sounds surprising, my skills in Statistics make me an excellent fit for your project on real-time stock feeds with Excel 2021. While I admit that my profile contains a broad array of skills like AutoCAD, Machine Learning and Electrical Engineering that may seem unrelated to your requirement, it is crucial to dissect the problem you need solving - reliable and fast real-time market data feeding into your Excel workbook, without disrupting existing dashboards and charts. My extensive acquaintance with APIs and streaming market data connectivity allows me to handle the technicalities flawlessly, while still giving you an efficient yet clean solution. Also, one thing apparent from your project description is the significant size of your workbook and its performance constraints. With my capabilities in Statistical Analysis, Data Science, and Deep Learning, I can implement efficient algorithms and techniques that will minimize the risk of Excel freezing during simultaneous refresh for up to 200 tickers. Lastly but perhaps most importantly, my proficiency in providing clear documentation is a major plus. I will ensure thorough instructions covering setup, API key management, and routine maintenance that empower you to move the solution effortlessly to another PC if needed. Given this tailored skill set to navigate complexities just like what this project presents, consider choosing me for a robust and seamless integra Thanks!
$750 USD in 1 day
0.0
0.0

Hi there, I see you want a real-time replacement for Stock Connector in Excel 2021 that slots into your existing workbook without breaking formulas. I can connect Excel to a low-latency provider like Polygon or IEX using VBA with async calls or a tiny local bridge for WebSocket streaming, map each field to your current columns, mirror the Stock Connector syntax where practical, and refresh 200 plus tickers smoothly. It will cover NYSE, NASDAQ, S&P, Russell and Dow lists as well as preferreds, deliver open high low last bid ask volume plus market cap EPS dividend and more on a few second cadence, with batching, caching and adaptive throttling to avoid limits, and everything will be packaged with clear docs and a portable install. I can share a short plan and a demo sheet that updates 50 symbols in under a minute so we can choose the provider and finalize the migration path. Best regards, Remon
$500 USD in 2 days
0.0
0.0

I am a perfect fit for your project. I have extensive experience integrating real-time market data APIs with Excel using VBA and Power Query. While I am new to Freelancer, I have completed numerous similar projects off-site. I specialize in seamlessly mapping incoming data fields to existing columns, ensuring smooth integration and automated data updates. I am confident in meeting your requirements for a user-friendly, reliable, and efficient solution. I would love to chat more about your project! Regards, Francois Snyman
$550 USD in 14 days
0.0
0.0

Bedford, United States
Payment method verified
Member since Sep 28, 2010
min $5000 USD
₹1500-12500 INR
$15-25 USD / hour
₹750-1250 INR / hour
₹1250-2500 INR / hour
€30-250 EUR
$30-250 AUD
₹400-750 INR / hour
₹100-400 INR / hour
₹600-650 INR
₹1500-12500 INR
$8-15 USD / hour
₹12500-37500 INR
₹12500-37500 INR
$80-240 HKD
$10-30 USD
$10-30 USD
₹750-1250 INR / hour
€6-12 EUR / hour
₹37500-75000 INR
min $50 USD / hour