Can't you just use the Bloomberg excel tools for this - it's very straight forward, there is even a wizard and plenty of existing templates which you can find with a simple search on your terminal

Fresh of the Bloomberg WAPI press - we finally have native Python support!

You could use mock objects to simulate the library

How about using Infobright as your datastore - this is optimized for big data out of the box. You can combine that with and ETL tool like Taland. You could also look at out of the box front to back BI solutions such as Pentaho or Jaspersoft. Seems crazy to re-invent the wheel.

<t>Looks like you're destined to go down a well trodden path laden with good intent but paved with awful failure. So without going into the inevitable Access is a crazy bad solution chat which others will no doubt add later;1. If you even have the lowest budget for a professional solution - go for t...

As a side note - mod_python is dead, why not use mod_wsgi..........then why not also leverage a micro web framework such as Flask or Bottle. Personally I use Django

Just so we are on the same page - here is a screener of my Pythonwin COM Makepy utility ... as well as the actual gen_py module.

The OS should not matter. Did you also install the COM data control?

The very first step is to run the PythonWin MakePy utility on the Blooomberg API COM 3.0 Type Library - have you done this step yet?

<- sticks with 2.7, leads an easy life.

As a side note - have you thought about using the new API v3?

Also you may note in the install docs for numpy that it prefers an install of cpython from python.org, not the inbuilt mac python.

Basically the 3x series of python is not greatly supported by the big libraries out there - better to stick with 2.6 or the newer 2.7 branches. Also IDLE is ok when you are learning, but on a mac you can't really beat TextMate.

What kind of mundane tasks? Firstly I would say install GnuWin32 tools on your system which will give you a whole load of command line goodness. I tend to automate things like backing up my local projects to a network server etc using a mix of python scripts and task sheduler.

How about using python win32com and rpy