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

$12-30 SGD

Đã đóng

Đã đăng vào

gần 4 năm trước

$12-30 SGD

Thanh toán khi bàn giao

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

Mã dự án: 26532881

Về dự án

8 đề xuất

Dự án từ xa

Hoạt động 4 năm trước

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

Địa chỉ email

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

8 freelancer chào giá trung bình $24 SGD cho công việc này

@writingapp

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

$30 SGD trong 1 ngày

4,9

(65 nhận xét)

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 trong 1 ngày

5,0

(1 nhận xét)

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 trong 1 ngày

0,0

(0 nhận xét)

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 trong 7 ngày