4
$\begingroup$

I am seeking to increase my knowledge in the quantitative finance field. I would be grateful if someone could point me to useful resource online, where I can find working examples of they types of applications built in Excel or Access, one can expect to find on a trading desk or in the middle office of a bank.

I already know how to program (C, C++, Python etc), but I want to familiarize myself with working applications - in preparation for interviews.

In the event that no resources are forthcoming, I would be interested in hearing from practitioners, what types of applications (or tools), they construct using Excel, VBA, and/or access. It would be useful in terms of the required functionality of the tools, so that in the event that there are no suitable resources online, I can try to build the tools myself.

$\endgroup$
  • $\begingroup$ I want this too. $\endgroup$ – jacob Sep 9 '16 at 16:47
1
$\begingroup$

In terms of end-user applications, all trading desks and middle office places I know, use either their own proprietary or expensive third party sources.

On the other hand there exists a c++ library called QuantLib that is well known among real world practitioners, probably because it contains several routines that are well tested and robust. Often pieces of this library are "copied and pasted" into the otherwise "proprietary" company's software.

Since you are looking for free access to public domain software, I would therefore suggest you take a look at quantlib. If you are more interested towards end-user spreadsheet-based analysis for yield curve building and option pricing, you may find the freeware deriscope to be a user-friendly, wizard-based interface to the QuantLib's algorithms, but I guess my last advice is unavoidably skewed due to my personal involvement with Deriscope's development.

$\endgroup$
0
$\begingroup$

Volopta has some nice examples, but not always true. Their MATLAB GARCH code was not in line with Duan's specs.

$\endgroup$
-1
$\begingroup$

Trading Tuitions has some nice examples of complete Trading systems in Excel sheet. There are some downloadable excel sheets with real time price/options data with backtesting option. I have been using Open=High, Open=Low Excel sheet from last few months and the signals are pretty accurate.

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.