SERVING THE QUANTITATIVE FINANCE COMMUNITY

maths2000
Topic Author
Posts: 10
Joined: August 24th, 2004, 8:24 pm

### finance in excel

I want to learn the basics of excel (and will be using it for financial methods) - does anyone have any online sources that they could recomend?Failing that could you post an excel file which tackles some well known financial maths problem - anything for which the answer is well known (so that i am certain of what should happen) but of sufficient complexity to demonstrate the uses of excelmuch obliged (in advance)

mrblue
Posts: 79
Joined: June 23rd, 2004, 10:43 am

### finance in excel

Simon Benninga Financial Modeling is excellent, quite simple it covers many subjects in a operative way, teaching how to build model in excel through the use of visual basic for applications in excel.

GregWallace
Posts: 157
Joined: August 6th, 2004, 3:31 am
Location: United Kingdom
Contact:

### finance in excel

Hi maths2000Attached is some closing shareprice data for two Australian stocks:Amcor (AMC)Australian Gaslight (AGL)Calculate the following:the volatility of each stockthe correlation of the stocksthe covariance of the stocksthe beta of AMC to AGLthe beta of AGL to AMCEnjoy!
Attachments
Modelling.zip

Antonio
Posts: 630
Joined: June 30th, 2004, 3:13 pm
Location: Imperial College London
Contact:

### finance in excel

What kind of methods do you want to start with ? Pricing ? Simulation ? Ratios calculus ? Portfolio management ? Hedging ?

unquantifiable
Posts: 31
Joined: March 1st, 2003, 4:43 am

### finance in excel

i'm interested in the calculus bit...cheers.

BobM
Posts: 132
Joined: November 12th, 2002, 2:14 pm

### finance in excel

Jackson and Staunton's book is good for learning basic excel / vba with applications to finance...

tannourine
Posts: 1
Joined: September 3rd, 2004, 1:18 pm

### finance in excel

I was wondering if anyone knows an online ressource for vba programming under excel ?

Wilmott.com has been "Serving the Quantitative Finance Community" since 2001. Continued...

 JOBS BOARD

Looking for a quant job, risk, algo trading,...? Browse jobs here...

GZIP: On