0

I want to import data from following link into Google Spreadsheet

https://www.google.com/finance/getprices?q=BANKBARODA&x=NSE&i=900&p=1d&f=v&df=cpct&auto=1&ts=1266701290218

Which formula is appropriate to import?

  • Can you link to any documentation for those query parameters? – Michael Scheper Jul 12 '18 at 14:22
1

=GOOGLEFINANCE() is appropriate. But you can also use IMPORTDATA()

  • importdata is better option. Thanks – neo269 Mar 9 '18 at 13:22
  • Any Idea on how to get the IMPORTDATA() function auto-refresh every 5 or 15 minutes using Google Script? – neo269 Mar 12 '18 at 10:14
  • You might wanna just try changing recalculation in settings. If that doesn't work,stackoverflow.com/questions/40069891/… – TheMaster Mar 12 '18 at 11:54
  • Recalulation settings doesnt work for IMPORTDATA() function. – neo269 Mar 12 '18 at 17:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.