Importing Google Finance Data into Smartsheet?

Hi all,

I'm attempting to pull Google Finance Data for monitoring stock price movements and creating charts for projected outcomes, etc.

I'm not sure if Google Finance data is natively supported or not. I did attempt to import an existing Google Sheets spreadsheet with some formulas in it but receive an "#UNPARSEABLE" error for any formulas imported into Smartsheet.

Any tips or advice for achieving this would be greatly appreciated!

Find more posts tagged with

API and Developers

Formulas

Importing and Exporting

Comments

Mick Jordan

Hi we got round this challenge using the Smartsheet API connected to a 3rd party Finance data provider eg Google or other.

Mick

Richard Rymill SBP

Nalloyd3

This is something I have wanted to set up to monitor some minor shares I have in our Investment club but too busy looking after clients needs to spend time on it, so please persist with this, i'd be interested to know how you get on?

RichardR

Andrée Starå

Hi,

Smartsheet just released a new add-on called Data Uploader that could be an option for you.

Please see the attached link/screenshot for more information.

https://www.smartsheet.com/datauploader

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

unknown

This content has been removed.

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…