d2jsp
d2jsp Forums > Programmer's Haven > Need A Vba Financial Modelling Pro
Add Reply New Topic New Poll
Receptor
#1 Oct 3 2019 11:05am
Group: Member
Posts: 11,744
Joined: May 27 2013
Gold: 2,165.01
Will pay
3oDAtlas
#2 Oct 3 2019 12:04pm
Group: Member
Posts: 2,298
Joined: Apr 16 2019
Gold: 5,155.94
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.
Receptor
#3 Oct 3 2019 12:16pm
Group: Member
Posts: 11,744
Joined: May 27 2013
Gold: 2,165.01
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

3oDAtlas
#4 Oct 3 2019 02:14pm
Group: Member
Posts: 2,298
Joined: Apr 16 2019
Gold: 5,155.94
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
Liu
#5 Oct 3 2019 03:27pm
Group: Member
Posts: 32,797
Joined: Jan 31 2008
Gold: 17,790.00
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?
Receptor
#6 Oct 3 2019 11:45pm
Group: Member
Posts: 11,744
Joined: May 27 2013
Gold: 2,165.01
I will update when I have a look see on monday
ehmmkay
#7 Oct 4 2019 06:59am
Group: Member
Posts: 13,738
Joined: Sep 27 2012
Gold: 16,362.20
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
Receptor
#8 Oct 10 2019 08:30pm
Group: Member
Posts: 11,744
Joined: May 27 2013
Gold: 2,165.01
Managed to do it with vba
and scenario testing

Thanks guys, thankfully this was still within my field of expertise xd
Liu
#9 Oct 11 2019 11:22am
Group: Member
Posts: 32,797
Joined: Jan 31 2008
Gold: 17,790.00
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;
Receptor
#10 Oct 11 2019 09:39pm
Group: Member
Posts: 11,744
Joined: May 27 2013
Gold: 2,165.01
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 Programmer's Haven Topic List
Add Reply New Topic New Poll