Wiley Advanced Modelling in Finance using Excel and VBA.pdf

《Wiley Advanced Modelling in Finance using Excel and VBA.pdf》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、AdvancedModellinginFinanceusingExcelandVBAMaryJacksonandMikeStauntonJOHNWILEY&SONS,LTDChichesteržNewYorkžWeinheimžBrisbanežSingaporežTorontoCopyright2001byJohnWiley&Sons,Ltd,BaffinsLane,Chichester,WestSussexPO191UD,EnglandNational01243779777Internati

2、onal(C44)1243779777e-mail(forordersandcustomerserviceenquiries):cs-books@wiley.co.ukVisitourHomePageonhttp://www.wiley.co.ukorhttp://www.wiley.comAllRightsReserved.Nopartofthispublicationmaybereproduced,storedinaretrievalsystem,ortransmitted,inanyfor

3、morbyanymeans,electronic,mechanical,photocopying,recording,scanningorotherwise,exceptunderthetermsoftheCopyright,DesignsandPatentsAct1988orunderthetermsofalicenceissuedbytheCopyrightLicensingAgency,90TottenhamCourtRoad,LondonW1P9HE,UK,withoutthepermi

4、ssioninwritingofthepublisher.OtherWileyEditorialOfficesJohnWiley&Sons,Inc.,605ThirdAvenue,NewYork,NY10158-0012,USAWiley-VCHVerlagGmbH,Pappelallee3,D-69469Weinheim,GermanyJohnWiley&SonsAustraliaLtd,42McDougallStreet,Milton,Queensland4064,AustraliaJohnW

5、iley&Sons(Asia)PteLtd,2ClementiLoop#02-01,JinXingDistripark,Singapore129809JohnWiley&SonsCanadaLtd,6045FreemontBlvd,Mississauga,ONT,L5R4J3,CanadaBritishLibraryCataloguinginPublicationDataAcataloguerecordforthisbookisavailablefromtheBritishLibraryISBN

6、0471499226Typesetin10/12ptTimesbyLaserwordsPrivateLimited,Chennai,IndiaPrintedandboundinGreatBritainbyBookcraft(Bath)Ltd,Midsomer–NortonThisbookisprintedonacid-freepaperresponsiblymanufacturedfromsustainableforestry,inwhichatleasttwotreesareplantedfo

7、reachoneusedforpaperproduction.ContentsPrefacexiAcknowledgementsxii1Introduction11.1Financeinsights11.2Assetpriceassumptions21.3Mathematicalandstatisticalproblems21.4Numericalmethods21.5Excelsolutions31.6Topicscovered31.7RelatedExcelworkbooks51.8Comm

8、entsandsuggestions5PartOneAdvancedModellinginExcel72AdvancedExcelfunctionsandprocedures92.1AccessingfunctionsinExcel92.2Mathematicalfunctions102.3Statisticalfunctions122.3.1Usingthefrequencyfunction122.3.2Usingthequartilefunction142.3.3UsingExcel’sno