d2jsp
Log InRegister
d2jsp Forums > Off-Topic > Computers & IT > Programming & Development > Need A Vba Financial Modelling Pro
Add Reply New Topic New Poll
Member
Posts: 13,480
Joined: May 27 2013
Gold: 74.00
Oct 3 2019 11:05am
Will pay
Member
Posts: 6,988
Joined: Apr 16 2019
Gold: 50.00
Oct 3 2019 12:04pm
Quote (Receptor @ Oct 3 2019 01:05pm)
Will pay


Might want to talk to Linux, he and I worked on some financial modeling together awhile back. To my understanding its his major, he worked out what needed to be done and I worked out all the VBA stuff.

So if you guys figure out what needs to be displayed / the math I can write up all the VBA for you guys.
Member
Posts: 13,480
Joined: May 27 2013
Gold: 74.00
Oct 3 2019 12:16pm
Quote (3oDAtlas @ Oct 4 2019 02:04am)
Might want to talk to Linux, he and I worked on some financial modeling together awhile back. To my understanding its his major, he worked out what needed to be done and I worked out all the VBA stuff.

So if you guys figure out what needs to be displayed / the math I can write up all the VBA for you guys.



Mine is simple as it’s just a forecast of PnL and balance sheet with base case and scenarios, but in vba format

The issue is that my vba knowledge is not that powerful

And I’m not a finance guy

Could start by having a sample excel with vba in a form of financial modelling the PnL

Member
Posts: 6,988
Joined: Apr 16 2019
Gold: 50.00
Oct 3 2019 02:14pm
Quote (Receptor @ Oct 3 2019 02:16pm)
Mine is simple as it’s just a forecast of PnL and balance sheet with base case and scenarios, but in vba format

The issue is that my vba knowledge is not that powerful

And I’m not a finance guy

Could start by having a sample excel with vba in a form of financial modelling the PnL


Well like I said, I've no financial knowledge lol. I can do anything you'd ever need in VBA so if you send me a spreadsheet with an example of what you need it to come out like I could probably get you where you need to be
Member
Posts: 56,878
Joined: Jan 31 2008
Gold: 22,690.90
Oct 3 2019 03:27pm
Quote (Receptor @ Oct 3 2019 11:16am)
Mine is simple as it’s just a forecast of PnL and balance sheet with base case and scenarios, but in vba format

The issue is that my vba knowledge is not that powerful

And I’m not a finance guy

Could start by having a sample excel with vba in a form of financial modelling the PnL


Sounds like a basic GUI that calculates PnL by the given timeframe?
Member
Posts: 13,480
Joined: May 27 2013
Gold: 74.00
Oct 3 2019 11:45pm
I will update when I have a look see on monday
Member
Posts: 17,591
Joined: Sep 27 2012
Gold: 3,260.00
Oct 4 2019 06:59am
My girl can do this for you

Pm me more info and what you will pay


(She is an expert with VBA, and got a master in finance)

This post was edited by ehmmkay on Oct 4 2019 07:00am
Member
Posts: 13,480
Joined: May 27 2013
Gold: 74.00
Oct 10 2019 08:30pm
Managed to do it with vba
and scenario testing

Thanks guys, thankfully this was still within my field of expertise xd
Member
Posts: 56,878
Joined: Jan 31 2008
Gold: 22,690.90
Oct 11 2019 11:22am
Quote (Receptor @ Oct 10 2019 07:30pm)
Managed to do it with vba
and scenario testing

Thanks guys, thankfully this was still within my field of expertise xd


Would I be able to see what you did? I'm very curious;
Member
Posts: 13,480
Joined: May 27 2013
Gold: 74.00
Oct 11 2019 09:39pm
Quote (Liu @ Oct 12 2019 01:22am)
Would I be able to see what you did? I'm very curious;



Nope sorry, has company’s p/l, balance sheet
quite basic codes actually of sheet1.range(“”).currentregion , and some remodificstion to the spreadsheet

Then added some variables to do sensitivity analysis ie libor, funds COF, inflation etc

This post was edited by Receptor on Oct 11 2019 09:42pm
Go Back To Programming & Development Topic List
Add Reply New Topic New Poll