Since this is a ticker collection application we want this to run every now and again. At first I thought about using excel to schedule itself, but too many things generally go wrong with that, and we want to make this completely unattended. Let's say every hour, 24 hours a day.
We'll use the windows task scheduler - and we'll also put the workbook on Google Drive. That way, some PC somewhere can take care of updating, and any other PC can access the latest version, courtesy of google drive.
We can write a simple windows script to open a workbook, run something, and save the updated file. It looks like this , and will take the argument of the workbook name, and the function to run.
Next we'll create a windows batch file, that calls it, with the appropriate arguments.
The point of doing all of this is so that we can run the thing automatically. For that we'll use the windows scheduler. You can bring that up on windows 8 by typing "schedule tasks" at the metro interface. We create a task that will eventually look like this
Without doing anything else, this will be synchronized to Google Drive. I've shared it out publicly, so you can access the latest update at the link below.
For more on this see. Data driven VBA apps with JSON
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > excel to json and back > Data driven VBA apps with JSON >