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

$12-30 SGD

Chiuso

Pubblicato

quasi 4 anni fa

$12-30 SGD

Pagato al completamento

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

Rif. progetto: 26532881

Info sul progetto

8 proposte

Progetto a distanza

Attivo 4 anni fa

Hai voglia di guadagnare un po'?

Indirizzo Email

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze

Fatti pagare per il lavoro svolto

Delinea la tua proposta

La registrazione e le offerte sui lavori sono gratuite

8 freelance hanno fatto un'offerta media di $24 SGD

@writingapp

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

$30 SGD in 1 giorno

4,9

(65 valutazioni)

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 giorno

5,0

(1 valutazione)

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 giorno

0,0

(0 valutazioni)

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 giorni