Find Jobs
Hire Freelancers

Create an Excel doc that automatically downloads and calculates stock "Price Volume"

$250-750 USD

Dokončeno
Zveřejněno před více než 4 roky

$250-750 USD

Zaplaceno při doručení
Scan the web for the final closing price and stock volume every trading day for the following Stock Exchanges using any reliable API. NYSE NASDAQ EURONEXT Amsterdam LONDON Stock Exchange TORONTO Stock Exchange FRANKFURT Stock Exchange Create six corresponding tabs that contain data from the supplied stock market spreadsheets. Within these six tabs, populate the "Closing Price" and "Volume" columns with the matching data from a reliable API. Create a seventh tab that will list all "COMBINED" exchange data into one location. Create a column for "custom date" in the .csv file to define the date of the stock data. Once the data has been downloaded for each company into the spreadsheet, multiply the "Closing Price" and "Volume" and place the total in to a new column called "Price Volume". ("Closing Price" column should include all decimal places. Ex.: $124.32 = $124.32). ("Price Volume" column should be rounded to the nearest US Dollar. Ex.: $12345.67 = $12346 or $7654.32 = $7654). Consolidate all data in the "COMBINED" seventh tab. Save all tabs for future use. (Sorting, etc.) Automate this process so new spreadsheets can be created everyday after the market closes.
IČ projektu: 20237973

O projektu

42 nabídky
Vzdálený projekt
Aktivní před 5 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
Uděleno:
Avatar uživatele
Hello Sir, I will not disappoint you, please give me an opportunity to work with [login to view URL] pay me once the job is 100% complete. Please initiate a chat so we can discuss on this. Thanks, Jay
$440 USD v 4 dnech
5,0 (762 recenze)
8,6
8,6
42 freelanceři nabízejí v průměru $427 USD za tuto práci
Avatar uživatele
Hi there,I am Web scraping and Excel expert from Bosnia & Herzegovina,Europe. I can create Excel sheet that will scan that website using their API and scrape the data . Check out my profile and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$425 USD v 7 dnech
4,9 (175 recenze)
7,7
7,7
Avatar uživatele
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the projects, i do everything, that's why i only take what interests me and i can do it effectively. It is a complex project that requires time and dedication. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards
$700 USD v 20 dnech
5,0 (243 recenze)
7,0
7,0
Avatar uživatele
Hello, Dear How are you? I have read your project description and am ready for discussing with you about project. I have experienced in developing Excel , Web Scraping , Excel VBA, Excel Macros , Data Scraping I will work very hard and best for you. Best Regards
$500 USD v 7 dnech
5,0 (10 recenze)
5,4
5,4
Avatar uživatele
Sir, I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards Relevant Skills and Experience Data entry, excel
$422 USD v 4 dnech
4,7 (57 recenze)
5,7
5,7
Avatar uživatele
Hi. Great app writer for your projects. I have writen excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile
$250 USD v 5 dnech
4,8 (33 recenze)
5,0
5,0
Avatar uživatele
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/whitehorsetechn I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Ramesh
$400 USD v 4 dnech
4,8 (14 recenze)
5,2
5,2
Avatar uživatele
Dear sir/ Madam How are you?? I am ready to do your job right now, please give a chance to serve you. Thanks
$250 USD v 3 dnech
4,4 (59 recenze)
5,1
5,1
Avatar uživatele
100% Completion Rate and 5 Stars Dear, employer. My name is Lee, I am an experienced web developer, and web scraping expert. I have good experiences in web scraping using PHP, Python, Java and so on. I read your job description, and I am interested in your project. And I think it is not matter to perform your project, and I can satisfy you by completing your project with high quality in deadline. If you want, I can show you my projects that I had made before, and I can make demo for you. As a dedicated full stack developer, I am always available for daily communication and ready for your full response. I am free now, I can start to work in your project immediately. I would love to have an opportunity to discuss with you for further details. Skill: Python, spider, scrapy, selenium, beautifulsoup, mechanize, requests, lxml, urllib2 Best regards.
$400 USD v 7 dnech
5,0 (5 recenze)
4,7
4,7
Avatar uživatele
Excel and Scraping Expert. Hello dear. I have read your description carefully. I think that you want to find excel expert. I can show you scraping project and auto donwloading excel file project. I hope to discuss more via chatting. thanks.
$500 USD v 7 dnech
4,8 (12 recenze)
4,8
4,8
Avatar uživatele
Hi, I can easily implement this for 150 USD which is much lower than the minimum value of 250 USD you are giving. I'm an analyst and have made programs to extract stock price data on a lot of stock market based projects. If you can chat with me, I can provide you access to a highly reliable and free API (which I have used so far on all my projects) that has all requisite historic price and volume data you need for every trading day for all stock exchanges you have mentioned. Award the project to me only when I have delivered the working excel file to you that scrapes data from this API I have or any of your stock exchange APIs so that you can verify the quality of my work and are 100% satisfied I am proficient in Excel VBA and Python. I have scraped diverse range of websites in Excel VBA and Python and have built several sophisticated web scrapers quickly. I have a rich experience of building complex scraping software that can scrape financial statements of any listed company in the USA and India as you can see from excel file in my portfolio. Again, I will accept the project only when I have substantially completed your task to your satisfaction - that way you too can be sure of my commitment. You can even reach out to me for additional assistance if required after the project is over. My main goal is to provide maximum value for your money. If you hire me, you can rest assured of a 100% commitment to your project. Regards, Pranjal Kothari
$250 USD v 1 dni
5,0 (29 recenze)
4,7
4,7
Avatar uživatele
Hello Sir/Madam Thankful to you for your job post. I have carefully gone through your description. i have 3 years experience of excel formula virus task, I want to contribute to your project. Please check my portfolios and reviews for further verification. I will be looking forward to hear from you.  Regards,  Saanyia
$500 USD v 4 dnech
4,9 (47 recenze)
4,8
4,8
Avatar uživatele
Hello! How are you doing? I read your project description and I'm very glad to bid on your job posting. I hope we can work in cooperatively so I will make your project with high quality. Please invite me so that we can discuss more details through chatting. Thank you.
$500 USD v 10 dnech
5,0 (3 recenze)
4,2
4,2
Avatar uživatele
Dear sir I can help you. The Excel, excel vba, excel macros are not problem for me and I can deliver python script for web scraping dear. I am python master developer who have developed a number of web scraping projects and django website project with python. I am confident with you project sir. I am looking forward you reply. Thank you.
$500 USD v 7 dnech
4,8 (4 recenze)
3,7
3,7
Avatar uživatele
Hi there. I have read carefully through your work requirements. Hence, I am interested in completing this work as you have instructed. I have completed similar tasks using VBA. I am available to start the work now and deliver quality work within specified timeline. I hope to hear from you soon. Thanks in advance.
$250 USD v 3 dnech
4,7 (18 recenze)
3,9
3,9
Avatar uživatele
I can help you with this project. I'm expert developing applications based in Excel and VBA. I understand that you want to obtain the closing price and stock volume of the Stock Exchanges mentioned. I have done a similar extraction of data from cmegroup dot com Please do not hesitate to contact me so we can further discuss the details.
$250 USD v 7 dnech
4,2 (3 recenze)
2,9
2,9
Avatar uživatele
Hi There, honestly, what you are after is best done in Google Sheets as it has a good link to the stock exchanges. Did you want a new spreadsheet for each day, or would an 8th sheet with all of the data and a way to search this data help? If you would like, I am happy to discuss before awarding and give you a preview of how I understand you want this setup.
$450 USD v 10 dnech
5,0 (2 recenze)
2,4
2,4
Avatar uživatele
Hi, i am already having my portfolio management in the similar lines. I operate with NSE stock exchange. I can work out your requirement. My current portfolio management involves more than 20 sheets and and 10+ files getting interfaced and managed in EXCEL using VB Macros, lookups, pivottable,.......
$450 USD v 7 dnech
5,0 (4 recenze)
1,9
1,9
Avatar uživatele
Hi, I can create automatic macro in VBA for this task. Worked in VBA, SQL Server & MS Access and provide best business solutions by developing customize macros and managed back-end functions to store in database with large data and import/export data in .csv, .txt with automation. Best Regards, Vipin Garg 9650217553
$250 USD v 7 dnech
3,8 (1 recenze)
1,9
1,9
Avatar uživatele
Dear! I've checked your requirements carefully. I've rich experience in Website design, CSS, JavaScript, WordPress, PHP, E-Commerce, Woo-Commerce, Magento, Joomla, C++, C# programming, Database programming, Android App development, iOS App development. I am rated in this field as the veteran. I can start your project immediately and let me know if you would like to discuss anything further with me. If you give me an opportunity to become a business partner with a long-term relationship forever, I'll do my best to work for you. We assure you quality results. Client satisfaction is our first priority! “I can complete your project on time and within your budget.” Thank you for spending your valuable time on my proposal. 王 俊 辛
$400 USD v 3 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Hello,sir I have read your description carefully. I am interested in your project...I have wealthy experience in Web scraping. I will try to make the product you are satisfied with. And I promise to complete your project within your time and budget beyond your expectation. Let me know when we can discuss and share all. Thanks!
$500 USD v 7 dnech
0,0 (0 recenze)
0,0
0,0

O klientovi

Pochází z UNITED STATES
Pasadena, United States
5,0
2
Ověřená platební metoda
Členem od pro 31, 2017

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.