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]