Compose one-line code for Google Sheets to fetch stock price using importXML

$12-30 SGD

Closed

Posted

almost 4 years ago

$12-30 SGD

Paid on delivery

Write just one line of code using=ImportXML. For example I want to fetch the PREVIOUS CLOSE PRICE for stock symbol located in Google Sheet cell number "B4". The code would be ImportXML("[login to view URL]"&B4&"/history?p="&B4, "*write appropriate code here*"). And the data to be fetched is circled in this screenshot below. So for the example belowI would enter "[login to view URL]" in cell "B4" in my Google Sheets. And it would fetch the circled data from [login to view URL]

XML

Google Sheets

Project ID: 26532881

About the project

8 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

8 freelancers are bidding on average $24 SGD for this job

@writingapp

Hi. I have written many automation GoogleShete scripts. Ready to write your project. Will complete within 1 day

$30 SGD in 1 day

4.9

(65 reviews)

6.0

@HumanoVirtual

Hi, Dear Employer, I can do this work for you. Please, message me to discuss the details of the project. Regards, Revaz

$20 SGD in 1 day

5.0

(1 review)

0.6

@ankleshsingh

Hi, Hope you are doing good. I have gone through your requirement and I do have skill set you are looking for. I am certified advanced RPA and QA Automation Professional. I have 2+ year of experience with Automation anywhere and successfully delivered 6 bot which are live up and running in production. I also have 10+ year of expertise in Test Automation framewrok designing with Selenium+ java , UFT + VB script and Katalon Studio. I do have very good exposure working with Web,Rest and Soap service, and also desktop based application automation. I also have hands on BDD-Cucumber,Elastic Search,Excel macros, GIT, Gradle,CI CD tools Jenkins,Cloud testing with saucelabs. We can connect and discuss more about your requirements and come up with best solutions. looking forward to working with you. Regards, Anklesh Singh

$30 SGD in 1 day

0.0

(0 reviews)

0.0

@chiboshvililika

I have good experience end I can do any hard work that requires knowledge of the programs listed below. ----------------------------------------------------------------------------------------------------------------------------------- Windows, Windows Xp, Windows 7; Blogspot; Internet, Google: chrom, Drive, Docs, Sheet, Slides, Forms My Maps, Sites; Lucidchart; Microsoft Office Word; Microsoft Office Excel, Data Entry; Microsoft Office PowerPoint; Microsoft Office Publisher, PDF; Microsoft Office Access; Adobe Premiere Pro 1.5; Adobe Premiere Pro 1.6; Adobe Premiere Pro CS4; HTML, Java; Adobe Audition.

$21 SGD in 7 days