This exports 13F data from aggregate13Fs mongo database to excel for easy filtering and pivoting.
Every quarter runs from this tool will be posted at: Guru Forms
Disclaimer: I take no responsibility for the correctness or use of this tool. Use it at your own risk.
You need to have the following installed:
You must have the following running:
If you haven't run Aggregate 13Fs in order to populate your mongodb with aggregated 13F form data then first run [you must be online]:
$ java -jar build/13FAggregator.jar -update
To export results to excel run [you can be offline]:
$ python excel13Fs/export13Fs.py gurus13Fdata.xlsx
To export results to excel with current share price column run [you must be online]:
$ python excel13Fs/export13Fs.py -s gurus13Fdata.xlsx