We are quite familiar with Excel use in finance; the simplest use, relevant to CFA, is building financial models for ER, IB. Can someone talk about the type of finance problems they saw where VBA use was necessary? We are talking beyond simple macros.

How about writing your own functions, like maybe doing a binary tree for american option pricing for options of an arbitrary time-to-expiration.

RExcel add-in expands Excel analytical functionality to practically everything R is capable of. http://www.r-project.org/

bchadwick Wrote: ------------------------------------------------------- > How about writing your own functions, like maybe > doing a binary tree for american option pricing > for options of an arbitrary time-to-expiration. Thanks. I am working on a similar code, but am curious about the type of problems that folks solve with VBA.

Do a search on AF - there are all kinds of problems that people solve using VBA. One huge class of problems solved by VBA are data integration problems as in the problem on GD today about doing some problem with commodities futures indexes. Suppose that you want to do some task like open your spreadsheet and have 12 futures prices loaded into it, combine them to make an index, and then add T-bill interest to it and have this updated every day on a button push That problem seems a little too simple to use a programming language and a database but a little too cumbersome to use only spreadsheet functions. Perfect for VBA.

Thanks, JD.

Used everyday to gather and manipulate data.