Find Jobs
Hire Freelancers

Daily Market Data PowerQuery in Excel

£20-250 GBP

Đã đóng
Đã đăng vào khoảng 1 tháng trước

£20-250 GBP

Thanh toán khi bàn giao
I need an Excel 365 PowerQuery script that can fetch daily market data and handle potential data source interruptions or changes. I will be providing a URL that contains the market data, and you'll need to replicate the Google Sheets function =INDEX(IMPORTXML("[login to view URL]" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). This function provides real-time data from the specified URL. Please note that the data is structured using HTML tags. Key requirements: - The PowerQuery should be able to be refreshed with the google sheet. - It needs to include robust error handling. If the data source is unavailable or the structure changes, the PowerQuery should not break but continue to function, ideally providing a notification that an error occurred. Ideal skills: - Proficiency in Excel 365 and PowerQuery. - Experience in web scraping and handling dynamic data sources. - Strong understanding of error handling techniques in PowerQuery.
Mã dự án: 38002499

Về dự án

43 đề xuất
Dự án từ xa
Hoạt động 26 ngày trước

Bạn muốn kiếm tiền?

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
43 freelancer chào giá trung bình £142 GBP cho công việc này
Avatar người dùng
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
£180 GBP trong 4 ngày
4,9 (645 nhận xét)
8,6
8,6
Avatar người dùng
Attention all Excel 365 and PowerQuery experts! George here, ready to take your daily market data game to the next level. With my skills in web crawling and experience in handling dynamic data sources, I am the perfect fit for your project. What's in it for you? Let me break it down: 1. I'll provide a custom PowerQuery script that will fetch daily market data from your provided URL, replicating the Google Sheets function =INDEX(IMPORTXML) for real-time data. 2. Robust error handling? No problem. My script will handle potential data source interruptions or changes like a pro, without breaking and providing notifications for any errors. 3. I come with a strong understanding of error handling techniques in PowerQuery and am proficient in Excel 365 and PowerQuery. 4. Need proof? I have successfully completed a similar project using a custom web scraping tool. Now, are you ready to elevate your market data game? Let me know if you have any questions. Looking forward to working with you! 1. Can you provide any specific requirements for the structure of the data? 2. Is there a preferred format for the notification of errors? 3. How often do you need the data to be refreshed with the Google sheet? 4. Can you share the timeline and deadline for this project?
£402 GBP trong 3 ngày
5,0 (103 nhận xét)
7,9
7,9
Avatar người dùng
Hello there, I am experienced in web scraping and to build script or a windows desktop application by using python. I am also experienced in large data scraping from the given website, by pass IP, Captcha, and anti bot or cloud flair protection. Please message me to discuss more regarding this project. Best Regards
£80 GBP trong 3 ngày
4,9 (373 nhận xét)
8,1
8,1
Avatar người dùng
Hi I have experience in Excel Power Query programming, and can develop you a script to fetch daily market data, from your target website. I'm available to discuss more details in chat and can start right away. Abdul H.
£100 GBP trong 1 ngày
5,0 (354 nhận xét)
7,5
7,5
Avatar người dùng
Hello, I can start immediately. I have 13+ years of experience and I ensure you I can complete the project within budget and timeline. I'm not just a developer; I'm your dedicated partner. I'm committed to working with you. Count on me for any upgrades or specific requirements you may have along the way. I have few questions about the requirement. Can we discuss this over chat? Looking forward to hearing from you soon. Best regards, Sneha
£189 GBP trong 7 ngày
4,9 (164 nhận xét)
7,2
7,2
Avatar người dùng
Hi there! As I have read, I see you need help creating an Excel 365 PowerQuery script to fetch daily market data with the ability to be refreshed with a Google Sheet and robust error handling. I can design a PowerQuery script that fetches the data and includes error handling to ensure the query continues to function and provides a notification if an error occurs. I could help you achieve this reliable market data fetching solution! I'm a professional Database Administrator and Analytics Engineer with more than 10 years of experience and more than 300 projects done here on this platform. I offer unlimited revisions and I don't require any payment in front. I always meet delivery deadlines working until I get the desired results. I know all the most used softwares to do this project specifically, I could even give you some other options in case you think is better to use other tools. Send me a message so I can show you my previous work and we can discuss more. Best regards, Giovanni.
£20 GBP trong 1 ngày
4,9 (60 nhận xét)
7,0
7,0
Avatar người dùng
Hi, I have got you covered. I will provide you with Excel Spreadsheets solutions using Power Query, Pivot Tables, and Power Pivot to get your data in required shape, ready for analytics: · Data Transformation and Validation · Merging Excel or CSV files · Filtering Unnecessary Data from Multiple or Single excel files · Consolidate multiple excel/CSV files with a single click · Conditional Formatting · Remove Duplicates · Data Separation into Rows / Columns · Data Filtering · Complex Formulas · Slicing, Dicing and Pivoting/Unpivoting of Data · Power Query & Power Pivot Data Modeling · Pivot Table, Charts & Slicers
£220 GBP trong 7 ngày
5,0 (33 nhận xét)
6,2
6,2
Avatar người dùng
✅ Dynamic Market Data Fetching with Excel 365 PowerQuery - Stay Ahead with Real-Time Insights! ⭐⭐⭐⭐⭐ Hi there! Hope you're doing well. I've thoroughly reviewed your project requirements and it's clear you're looking for a solution to fetch daily market data efficiently. Look no further; Zohaib is here to assist you! With our expertise in Excel 365 and PowerQuery, we'll ensure you stay ahead with real-time insights, even amidst potential data source interruptions or changes. ➡️ Why Me? With over 5 years of experience in Excel 365 and PowerQuery, we guarantee a robust solution tailored to your needs. Our proficiency extends beyond mere data fetching; we excel in crafting dynamic solutions that adapt to changing data structures and ensure uninterrupted functionality. ➡️ Let's have a quick chat to delve deeper into your project details. I'll showcase samples of our previous Excel 365 PowerQuery projects, demonstrating our expertise in handling dynamic data sources and implementing robust error handling techniques. ➡️ Skills & Experience: ✅ Excel 365 ✅ PowerQuery ✅ Data Fetching ✅ Data Transformation ✅ Error Handling ✅ Web Scraping ✅ Dynamic Data Sources ✅ Task Automation ✅ Problem Solving ✅ Communication Skills ✅ Time Management ✅ Client Satisfaction Looking forward to discussing this with you further in our chat! Best Regards, Zohaib
£135 GBP trong 2 ngày
4,9 (42 nhận xét)
6,2
6,2
Avatar người dùng
Hello Mark C., I am Sadat Saeed, an experienced professional with expertise in PHP, Web Scraping, and HTML. I have carefully reviewed your project requirements and propose to create an Excel 365 PowerQuery script to fetch daily market data, ensuring seamless functionality even in the event of data source interruptions or changes. My extensive experience and skills make me the ideal candidate for this project. Please review my portfolio at https://www.freelancer.ca/u/DGM999 and let's discuss further. Best regards, Sadat Saeed
£75 GBP trong 3 ngày
4,8 (43 nhận xét)
5,9
5,9
Avatar người dùng
Hi My Name Is Murad and I’d like to be considered for your position. I Provide certain services : 1. MS Office 2. Web Research 3. Data Entry 4. CorelDraw ,Photoshop And Illustrator 5. eCommerce , Amazon , ebay , Shopify 6. WordPress Spare a moment to take a look at my reviews. Please, let me know what is needed to secure this bid! Thank you for your consideration Murad Eltaher
£200 GBP trong 7 ngày
4,7 (79 nhận xét)
5,1
5,1
Avatar người dùng
I'm excited about your project needing an Excel 365 PowerQuery script for daily market data. I understand the challenges of handling potential interruptions or changes in data sources. With over 5 years of experience in Excel and PowerQuery, I have a knack for crafting robust solutions. I can replicate the Google Sheets function you mentioned and ensure smooth data retrieval even with HTML-structured data. What sets me apart is my focus on error handling. I'll design the script to handle data source interruptions gracefully, providing notifications instead of breaking down. Thanks Javed
£125 GBP trong 7 ngày
4,9 (36 nhận xét)
4,9
4,9
Avatar người dùng
Dear Project Manager, Happy to offer you my support. If interested in availing my support, feel free to reach out and discuss. Regards, Do visit my profile, portfolio and reviews to know a bit about my work and understand how I deal and deliver.
£125 GBP trong 1 ngày
5,0 (4 nhận xét)
4,5
4,5
Avatar người dùng
Hi, Mark C.! I have worked with similar projects so that I can provide you with a satisfied result. So I will share you my previous work similar with your project via chatting. Having confirmed the job posting "Daily Market Data PowerQuery in Excel", I truly feel that you're looking for ambitious, creative and nice people who are expert in Excel, Web Scraping, PHP and HTML. I am fully available to get started on your project immediately and you will find it interesting to discuss the project details. Regards Nina.
£150 GBP trong 5 ngày
5,0 (2 nhận xét)
4,2
4,2
Avatar người dùng
Hello, Mark C., Thank you for posting the job "Daily Market Data PowerQuery in Excel". With my extensive experience in software development, I am confident that I can deliver perfect results for your business. I have a deep understanding of the field you mentioned and have successfully completed projects of similar complexity in the past. I am available to start immediately and can assure you of high-quality work delivered with speed and efficiency. Given the opportunity to work on this project, I am committed to exceeding your expectations. I'd like to discuss further details about your project in a brief call or chat soon. Looking forward to working with you! Best regards, Derek
£150 GBP trong 6 ngày
5,0 (1 nhận xét)
4,1
4,1
Avatar người dùng
Hi there, Good evening I am Talha. I have read you project details i saw you need help with PHP, HTML, Excel and Web Scraping I am excited to submit my proposal for your project, which focuses on a comprehensive project plan. To begin, we will thoroughly understand your project's objectives and requirements, ensuring alignment on scope and goals. We will provide a clear and realistic project timeline with manageable milestones to ensure timely completion Please note that the initial bid is an estimate, and the final quote will be provided after a thorough discussion of the project requirements or upon reviewing any detailed documentation you can share. Could you please share any available detailed documentation? I'm also open to further discussions to explore specific aspects of the project. Thanks Regards. Talha Ramzan
£20 GBP trong 14 ngày
5,0 (6 nhận xét)
4,3
4,3
Avatar người dùng
Hi, there! Having confirmed the job posting, it seems like you might be looking for a senior developer for your project - Daily Market Data PowerQuery in Excel. I have worked with similar projects so that I can provide you with a satisfied result. This project really caught my attention because I have been working in this specific industry for 10 years now, and have not only gained experience or knowledge but, I have got the answer to the main problem which many clients face which is communication and I can assure that you will be satisfied and updated throughout the process, if we move forward. Can't wait to have you on chat with me, and to get started with this project. Regards
£160 GBP trong 3 ngày
5,0 (4 nhận xét)
4,0
4,0
Avatar người dùng
As a seasoned freelancer with extensive experience in Excel and web scraping, I believe I am the ideal choice for your project. Not only am I proficient in Excel 365 and PowerQuery, but I am also well-versed in using these tools to fetch data from dynamic sources like the one you mentioned. My knowledge of HTML and web scraping will enable me to understand and implement the Google Sheets function you need without a hitch. Moreover, my expertise extends beyond simply replicating the required function; I deeply understand the importance of robust error handling. This means that even if the data source becomes unavailable or its structure changes, your PowerQuery will not only remain functional but also provide clear notifications of any errors encountered along the way. My proficiency and understanding in this area will ensure a smooth and uninterrupted flow of market data into your spreadsheets. In conclusion, by choosing me for your project, you're getting far more than just a proficient Excel user. You're getting someone who understands your specific needs, is well-equipped to handle dynamic data, and can guarantee reliable performance even in unforeseen circumstances. Let's collaborate to create a PowerQuery solution that optimizes your daily market data management!
£135 GBP trong 3 ngày
4,9 (5 nhận xét)
3,5
3,5
Avatar người dùng
PLEASE DM AND HAVE A CHAT I CAN DO THIS WORK HAVE DONE LOTS OF WEBSCRAPING IN PAST With the perfect blend of creativity and technical expertise, I have been utilizing PHP to develop solutions that address complex issues just like yours. Having proficiency in Excel 365 and PowerQuery combined with my solid grasp on HTML, PHP, and web scraping, I can create a robust PowerQuery script that will smoothly handle potential data source interruptions or changes without breaking down. Rest assured, the script will be equipped with the ability to notify you of any errors encountered while providing a continuous functioning system. The key skill that sets me apart is my knack for working with dynamic data sources. I understand how unreliable data sources can be and designing solutions around their unpredictability is exactly what I excel at. By leveraging my knowledge of INDEX and IMPORTXML functions similar to your Google Sheets' function, I will ensure that my PowerQuery replicates the real-time data fetching capability while providing ironclad stability to withstand changes in structure or unavailability.
£135 GBP trong 3 ngày
5,0 (12 nhận xét)
3,2
3,2
Avatar người dùng
Hi there, I am a Data Scientist with excellent knowledge and enthusiasm for Microsoft application development. I can do advanced Excel, Word, Access, Power BI, and Outlook and create VBA macros. Advanced Array Formulas, Charts, Pivot Tables, Pivot Charts, Mail Merge, Capabilities, and Spreadsheets. Email through Outlook and Gmail, Add-in, Customized Macros. My top priority is to provide high-quality work. I am willing to devote my time and energy to improving the service with timely, accurate, and professional results. Building trust and a long-term relationship with customers is my main objective. Improving https://www.freelancer.com/u/IcsfIT789 Let's discuss this further via chat, and I'll start your project right now. Thanks IcsfIT
£50 GBP trong 3 ngày
5,0 (3 nhận xét)
3,2
3,2
Avatar người dùng
As a seasoned Excel and HTML specialist, I am more than adept at handling intricate projects like this one. With my extensive knowledge of PowerQuery and proficiency in Excel 365, I can certainly create an Excel script that emulates the Google Sheets function required for your market data sourcing. One of my major strengths is my deep understanding of error handling in PowerQuery. I believe in building solutions that not only work but have built-in mechanisms to recover from potential issues. In essence, your PowerQuery will not simply break down if there are errors with the source; rather, it will display an appropriate notification while ensuring continuation of efficient performance. Hiring me as your freelancer also gets you access to my fabulous design service (10% discounted for pet owners!). Though my core competency lies in technical tasks, I bring a unique blend of creativity and innovation to every project. Let's combine those powers for your gain! Let's hop on chat to discuss project deadline, budget and further details. https://www.freelancer.com/u/mazae7669 Thanks and Regards, Evan F
£50 GBP trong 1 ngày
5,0 (1 nhận xét)
2,1
2,1

Về khách hàng

Cờ của UNITED KINGDOM
Woodley, United Kingdom
0,0
0
Phương thức thanh toán đã xác thực
Thành viên từ thg 4 16, 2024

Xác thực khách hàng

Cảm ơn bạn! Chúng tôi đã gửi email chứa đường link để bạn lấy tín dụng miễn phí.
Đã xảy ra lỗi trong khi gửi email của bạn. Hãy thử lại.
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.