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?

1
  • Can you link to any documentation for those query parameters? Jul 12, 2018 at 14:22

1 Answer 1

1

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

4
  • importdata is better option. Thanks
    – neo269
    Mar 9, 2018 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, 2018 at 10:14
  • You might wanna just try changing recalculation in settings. If that doesn't work,stackoverflow.com/questions/40069891/…
    – TheMaster
    Mar 12, 2018 at 11:54
  • Recalulation settings doesnt work for IMPORTDATA() function.
    – neo269
    Mar 12, 2018 at 17:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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