Đã Đóng

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

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]

Kĩ năng: XML, Google Sheets

Xem nhiều hơn: php fetch zip code google map, extract stock price java code, html code stock price, importxml div(@class), google sheets importxml imported content is empty, importxml google spreadsheet not working, google sheets importxml array, google sheets importxml refresh, google sheets importxml table, google sheets importxml limit, google sheets importxml examples, google fiance stock price chart flash, extract stock price google finance, code show companys bse stock price asp net web page, extract stock price google finance excel, stock price asp code, stock price google api xml url, ipo google stock price multiples, vba code input stock price, macro google finance stock price

Về Bên Thuê:
( 9 nhận xét ) Singapore, Singapore

ID dự án: #26532881

9 freelancer đang chào giá trung bình $23 cho công việc này

(46 Nhận xét)

Hi There, I can provide you with the required code to get the desired value from yahoo finance to the google sheet B4 column. Can share the google sheet template you wish to use for this? I am a Google Apps Script d Thêm

$30 SGD trong 1 ngày
(5 Nhận xét)

G'day Employer, I just read through your description and got very much interested in your project. So I tried out what you expected and got the result, you can view the image file of the google sheet here : https://dri Thêm

$15 SGD trong 1 ngày
(1 Nhận xét)

I can write this XPath expression to have "PREVIOUS CLOSE PRICE" as a result. Please consider my proposal, thank you.

$15 SGD trong 1 ngày
(1 Nhận xét)

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
(1 Nhận xét)

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

$30 SGD trong 1 ngày
(0 Nhận xét)

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 Thêm

$30 SGD trong 1 ngày
(0 Nhận xét)

please try this =ImportXML("[login to view URL] "&B4&"?p="&B4, "string(//*[@id='quote-summary']//table//*[contains(@data-test,'PREV_CLOSE')])")

$12 SGD trong 1 ngày
(0 Nhận xét)

I have good experience end I can do any hard work that requires knowledge of the programs listed below. ------------------------------------------------------------------------------------------------------------------ Thêm

$21 SGD trong 7 ngày
(0 Nhận xét)