Python - Pull data from Yahoo Finance APIs into Excel file on Google Drive

Job Description:

I have a basket of stocks defined in an Excel workbook on Google Drive on Sheet 1.

This is a Yahoo Finance API job. It is not screen scraping. Excel or Google sheets. Python.

I want a Python script to go to the Yahoo Finance APIs and pull the 50-day average for the stock and use the API to pull the data to calculate the 20-day average for the same stock and return it to the Excel file at the bottom of Sheet 2.













Then sort by: Date, symbol

The delete all rows where date <> today's Date

Save workbook

I should be able to run this script from Visual Studio code: you to provide all of the library references.

You should also build in some debugging so I can see journal entries that tell me that you have collected the right data and I can compare them to what I can get from Yahoo finance directly.

Skills: Python, Excel

About the Client:
( 2 reviews ) Hendra, Australia

Project ID: #36290019

Awarded to:


Hi, I am Senior Python script developer with 10 years of experience. I can scrape Yahoo Finance APIs into Excel file by python script/bot with your instructions very short time. Can we discuss please? Thanks.

$250 AUD in 2 days
(179 Reviews)

46 freelancers are bidding on average $456 for this job


Top 1% in Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. If you More

$500 AUD in 7 days
(586 Reviews)

"Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOARD in EXCEL Advanced Level Expert. This is my field and I can comp More

$250 AUD in 1 day
(243 Reviews)

Greetings! I am an expert Full-Stack developer having 10+ years of experience in web development and scraping (Bot Scrapper, Big Data, Python, AI). I stand amongst top 2% among 58+ million freelancers. I am confident t More

$750 AUD in 7 days
(16 Reviews)

Hi there,I'm biddin on your project "Python - Pull data from Yahoo Finance APIs into Excel file on Google Drive" I have read your project description and i'm an expert in Python and machine learning therefore i can do More

$750 AUD in 3 days
(34 Reviews)

Hello, I specialize in providing trading automation solutions and do tasks like this routinely. If interested, feel free to message me to discuss details and I will be happy to help. Regards, Nanda

$275 AUD in 7 days
(58 Reviews)

Hi there! I have more than 10 years of experience as a Data Base Administrator and Analytics Engineer. I'd love to work together on your project. I'm so responsible and kind, I'll always send you the files on time and More

$250 AUD in 1 day
(53 Reviews)

I am writing to express my interest in the Python Script Developer position. As an experienced Python developer, I can help you in developing a Python script to extract data from Yahoo Finance APIs and import it into a More

$500 AUD in 7 days
(26 Reviews)

I can pull the data. Greetings, I have gone through your project description. I find myself as a perfect fit for this job. I am working as a Python Developer from last 2 year. Some of my expertise is in the fields: More

$250 AUD in 3 days
(69 Reviews)

Hello, I will work on this project until I get good results and complete all the tasks. I am prepared to handle projects requiring Excel, Python skills. Please come over chat and discuss your requirement in a detail More

$750 AUD in 7 days
(67 Reviews)

Hello, I have read your all requirements that you want a Python - Pull data from Yahoo Finance APIs into Excel file on Google Drive I am experienced in Python, API, Excel, I can do this project as per your desire hope More

$250 AUD in 2 days
(23 Reviews)

yeah i m expert with the scraping have look my profile so i can develop that script in the python ready to start work from now

$500 AUD in 2 days
(19 Reviews)

Hello I am a professional python developer. My main specializations are automation, web scrapers and bots development. I have already developed over 200 scrapers. From the simplest (for example, a competitor's price More

$250 AUD in 7 days
(9 Reviews)

Hi Hope you are doing well I am an experienced Python developer I can create a python script to pull data from Yahoo Finance API Please send me a message so that we can move forward Looking forward to working with More

$500 AUD in 7 days
(6 Reviews)

This project is really easy. We can pull data using Python and API. I can do this perfectly. I am well-versed in various programming languages, including Python, C#, and C++, and have a strong background in webscrappin More

$500 AUD in 1 day
(6 Reviews)

Hello, I have working experience of 7 years on this platform and i believe i can help u with getting this job done as i have the great knowledge of Excel and Python. So please initiate the chat and discuss with me in More

$750 AUD in 8 days
(1 Review)

I am a data scietist student and deep learning enthousiat. You wont regret working with me because i know exactly what to do

$300 AUD in 7 days
(2 Reviews)

Watch List" of stocks that I want to track. I would like a web scraping expert to write a script that will read the symbols on Sheet 1, and then go to Yahoo Finance for each symbol and scrape the following data points More

$500 AUD in 7 days
(4 Reviews)

Hashir here in developing a Python script to extract stock data from Yahoo Finance APIs, calculate the 50-day and 20-day averages, and then return the data to an Excel file on Google Sheets. To accomplish this task, I More

$500 AUD in 7 days
(2 Reviews)

Hello, Nice to meet you. I am so excited to bid on this project, as my first task. I will pull the data from Yahoo finance API and store them to Google Sheet. Although I am a newbie in freelancer, I am familiar with Go More

$700 AUD in 7 days
(2 Reviews)

Hi there! My name is Akshay, and I'm a senior python developer with +5 years of experience. I'm confident that I can provide the best solution for your project. I have a wide range of skills that can help you with you More

$500 AUD in 7 days
(2 Reviews)