[notJim]

The scripting engine fetches up-to-date stock quotes and fills them in. The rest is all done using spreadsheet rules.

Here is the scripting engine part: https://gist.github.com/2717042