3D graphics in Resolver One using OpenGL and Tao, part III: Stock prices

20 November 2009

I’ve done another 3D example in Resolver One. This one uses Yahoo! Finance to download the close prices over the last two years for every stock that’s currently in the Dow Jones index, then charts them in a 3D window which you can pan and zoom using the mouse. Here’s a video showing it in action:

Here’s how you can try it out:

  • If you didn’t already, download and install the Tao Framework, a set of multimedia libraries that (among many other things) makes it easy for .NET programs like Resolver One to call the OpenGL 3D graphics libraries. [UPDATE: Rick comments below that when he first installed Tao as a non-admin user, it didn’t work, but when it had been reinstalled by an administrator it did work. It sounds like Tao is failing silently when installed by a non-administrator, so look out for that.]
  • Again, if you don’t have it already, download Resolver One. (It’s free to try.)
  • Get the sample spreadsheet, along with its supporting Python code. Unzip this file somewhere, and then open the file 3dShares.rsl with Resolver One. (An alternative: if you’re on GitHub, you can clone a repository there that contains all of my Resolver One 3D samples so far.)

I won’t explain in depth how the spreadsheet works; there’s not actually all that much there beyond what I described in my last two posts about 3D graphics in Resolver One.

I’ll be tweaking the performance of the sheet over the next few days, and I’m keen to hook it up to the BetFair API so that we can chart gambling odds too, but before I charge ahead with that, let me leave you with a question — what could I add to make something like this truly useful to someone watching the financial markets? Would it be useful to be able to “fly around” the chart instead of just spinning it around? Perhaps clicking on things could give you information? Or anything else?

What do you think?

6 thoughts on “3D graphics in Resolver One using OpenGL and Tao, part III: Stock prices

  1. giles Post author

    That’s a really good question. I used Yahoo! because we already had a data feed that worked with it that I can adapt. I’ll have a look at Google and see what the API looks like, if would be great if I could support both.

  2. Rick Behl

    Hey Giles, trying to get this running on my work machine but having a problem. Getting an ‘Cannot add reference to Tao.gl’ error ? I’m not admin on this machine if that makes things difficult ? Have already run the Tao Framework install which didn’t error… Any ideas?

  3. Rick Behl

    Ignore that previous comment, just got it working by asking my IT helpdesk to re-install the Tao Framework using an admin account… Must say it looks cool !

  4. giles Post author

    Rick — glad you managed to get it to work! Odd that Tao didn’t error when it failed to install properly the first time, but then quite a lot of software doesn’t seem to handle non-admin accounts… I’ll put a note in the post to warn people, though.

Comments are closed.