Is studying VBA worth it?

[wkdwnstjdTprtm]

I know that VBA and Excel are still used a lot in finance, especially for reporting purpose (like risk reports).

I was just wondering if learning VBA and studying it hard is worth it?

Will VBA continue to be used in finance or replaced by some other "better" and "faster" languages?

I will probably start a quant internship this summer and it looks like they use VBA a lot.

 

[Daniel Duffy]

I suppose VBA will remain but ...

These days more and more quants are using C#. I would make sure you still know some VBA.

Also this

Excel-DNA

 

[tradertanny]

@Daniel Duffy
Thank you

 

[MRoss]

VBA will exist IMO for as long as Excel will...quite a while. It is outclasses by Python (amongst others) as a scripting language and will never be used in the industry for true quant work.

However; it is built into Excel which will not go away and most firms simply use VBA for report automation, visualization, and pulling data from the firms data warehouse via SQL. Not the sexiest work, but most teams in finance need to do reporting and would love to see it on a resume.

 

[Joy Pathak]

a lot of front office tools are built in excel / vba.

 

[pingu]

a lot of front office tools are built in excel / vba.

most of the front office tools are built in Excel/VBA. I have seen Python making inroads but showing the results in Excel at the end.

 

[sergibarz]

Is there any specific online course you would recommend to learn VBA for financial applications?

 

[Daniel Duffy]

Is there any specific online course you would recommend to learn VBA for financial applications?

I don't of any. Since you know C++, a VBA course is too simple for you, so plan B

book on VBA syntax
Jackson and Staunton on VBA for finance (Wiley)

A site with VBA code for quants

some of my files ...

and Haug's book

The Complete Guide to Option Pricing Formulas: Haug, Espen Gaarder: 9780071389976: Amazon.com: Books

The Complete Guide to Option Pricing Formulas [Haug, Espen Gaarder] on Amazon.com. *FREE* shipping on qualifying offers. The Complete Guide to Option Pricing Formulas

www.amazon.com

I think you can pick up VBA pretty quickly.

A useful book is Bovey et al "Professional Excel Development"

 

[MRoss]

I don't of any.

I'm sad Dan. Now we definitely have to meet in person.

Sergibarz, definitely check out ScriptUni.com. The VBA course covers basic financial instruments, risk models, and more.

Good luck!

 

[sergibarz]

I'm sad Dan. Now we definitely have to meet in person.

Sergibarz, definitely check out ScriptUni.com. The VBA course covers basic financial instruments, risk models, and more.

Good luck!

Many thanks!!!!

 

[sergibarz]

I don't of any. Since you know C++, a VBA course is too simple for you, so plan B

book on VBA syntax
Jackson and Staunton on VBA for finance (Wiley)

A site with VBA code for quants

some of my files ...

and Haug's book

The Complete Guide to Option Pricing Formulas: Haug, Espen Gaarder: 9780071389976: Amazon.com: Books

The Complete Guide to Option Pricing Formulas [Haug, Espen Gaarder] on Amazon.com. *FREE* shipping on qualifying offers. The Complete Guide to Option Pricing Formulas

www.amazon.com

I think you can pick up VBA pretty quickly.

A useful book is Bovey et al "Professional Excel Development"

Thanks a lot for your reply, Professor Duffy, it will definitely be so useful for me!

 

[Daniel Duffy]

I'm sad Dan. Now we definitely have to meet in person.

Sergibarz, definitely check out ScriptUni.com. The VBA course covers basic financial instruments, risk models, and more.

Good luck!

Great! It would be nice.

I don't get out so much these days.