Serving the Quantitative Finance Community

 
User avatar
maths2000
Topic Author
Posts: 0
Joined: August 24th, 2004, 8:24 pm

finance in excel

September 14th, 2004, 11:36 pm

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)
 
User avatar
mrblue
Posts: 0
Joined: June 23rd, 2004, 10:43 am

finance in excel

September 15th, 2004, 5:23 am

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.
 
User avatar
GregWallace
Posts: 1
Joined: August 6th, 2004, 3:31 am
Location: United Kingdom
Contact:

finance in excel

September 15th, 2004, 5:24 am

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
(6.63 KiB) Downloaded 68 times
 
User avatar
Antonio
Posts: 8
Joined: June 30th, 2004, 3:13 pm
Location: Imperial College London
Contact:

finance in excel

September 15th, 2004, 6:39 am

What kind of methods do you want to start with ? Pricing ? Simulation ? Ratios calculus ? Portfolio management ? Hedging ?
 
User avatar
unquantifiable
Posts: 0
Joined: March 1st, 2003, 4:43 am

finance in excel

September 15th, 2004, 7:10 am

i'm interested in the calculus bit...cheers.
 
User avatar
BobM
Posts: 0
Joined: November 12th, 2002, 2:14 pm

finance in excel

September 15th, 2004, 10:40 am

Jackson and Staunton's book is good for learning basic excel / vba with applications to finance...
 
User avatar
tannourine
Posts: 0
Joined: September 3rd, 2004, 1:18 pm

finance in excel

September 15th, 2004, 2:52 pm

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