Price Predictions (Feature Request)

[shawnholbrook]

Is there anyway we can pull in data from WalletInvestor or a site similar to it for price predictions?
Here is one of their pages that has 3 numbers listed: current price, 1-year forecast price, and 5-year forecast price
https://walletinvestor.com/forecast/bitcoin-prediction
I'd like to be able to pull in these numbers on to a separate sheet. Lastly, I appreciate the work everyone has already done. I use the sheet daily.

[LesterCovax]

Thanks for the kind words!

You could do it by using XPath queries if they don't have an API available with that data. Here's an example of how I used that originally to grab prices.
https://github.com/LesterCovax/crypto-sheets/blob/develop/scripteditor.js#L432

[shawnholbrook]

I hate to ask you to be more specific, but to be honest I'm not good at all with the script stuff. How exactly can I do that?

[LesterCovax]

@shawnholbrook better late than never for a reply I guess (whoops)....

You can start learning about them here: https://www.w3schools.com/xml/xpath_intro.asp

Then use the examples I linked to in the code, and start reading about how it's handled in Google Scripts: http://lmgtfy.com/?q=google+script+xpath

It's a PITA thanks to google scripts, so the major trick will be finding the correct XPATH to use and then applying it to the existing code. If you use Chrome/Firefox dev tools in inspect mode, you can usually right click on an element and get the XPATH.