Finance 3.0 - Social Network for Finance

Smart financial thinking

Welcome!

Using Excel & VBA for Finance (308)

Featured Discussions
Treeline Business Solutions

VBA for creating a pop up alert if condition is met

hi, I have a cell which has a formula. I need to validate the formula result such that if a user inputs a number in the formula source cel…

Started by Treeline Business SolutionsLatest Reply

Ignacio Vélez Pareja

Opening xlsx (Office 2007) from Internet Explorer

Friends I have been experiencing a problem when downloading from IE browser: Excel 2007 files (xlsx) are "recognized" as .zip or .rar eithe…

Started by Ignacio Vélez ParejaLatest Reply

Ricardo Schlundt Inglês

Getting Data from Bloomberg via Excel VBA

Hello, I'm having a problem getiing data from Bloomberg via Excel VBA. I already use the DDE technology and the function from Bloomberg bu…

Started by Ricardo Schlundt InglêsLatest Reply

Discussions Replies Latest Activity
Yasir Bilal

Another challenge for Excel gurus

attached is my problem can anyone help me out? I have used data validation list for drop down but i am now stuck due to a problem. Please…

Started by Yasir Bilal

22 15 hours ago
Reply by B.Balachandran Nair
Yasir Bilal

IF function in Excel

See attached file which is self explanatory. i have solved the problem using vlookup but not able to do it with If fuction kindly see where…

Started by Yasir Bilal

4 23 hours ago
Reply by Yasir Bilal
Michael Dauda, ACCA

Match & Index functions in excel

Hi Folks, can some please explain to me how the Match and Index functions work in excel. Under what circumstance can we use the two togethe…

Started by Michael Dauda, ACCA

2 1 day ago
Reply by danyal mansoor
Rodrigo Pimenta

Amortization Schedule with Grace Period

Hi all, how does one go about setting up an amortization schedule with a grace period on the principal amount. The amounts are as follows:…

Started by Rodrigo Pimenta

3 1 day ago
Reply by Joseph Solimon
Kunal Doshi

Need help in creating a specific formula - Guys please solve my problem...

Dear Members, I want to create a model / formula to study the holding analysis of the fund. I have the holding details of one hedge fund…

Started by Kunal Doshi

3 1 day ago
Reply by Yasir Bilal
Kwadwo Nyantakyi

Converting figures to words in excel

can some help me on how to convert figures in any excel cell to words. I have tried the BAHTTEXT but it's in Thai language, i want it in en…

Started by Kwadwo Nyantakyi

1 Sep 2
Reply by danyal mansoor
Ravi Kant Chugh

fixed Assets Register

Dear All, Please send me fixed assets register template in Excel format. I need it on urgent basis. I will be grateful to all of you. T…

Started by Ravi Kant Chugh

0 Sep 1
Ricardo Schlundt Inglês

Getting Data from Bloomberg via Excel VBA

Hello, I'm having a problem getiing data from Bloomberg via Excel VBA. I already use the DDE technology and the function from Bloomberg bu…

Started by Ricardo Schlundt Inglês

9 Aug 31
Reply by Ricardo Schlundt Inglês
Fredrik Skoglund

Performance attribution spread sheet for fund-of-funds

Hi Does anyone have a spread sheet that can do performance attribution for fund-of-funds portfolios, that invest both in equities and bond…

Started by Fredrik Skoglund

0 Aug 31
PRASHANT BHANAWAT

Excel Key Board Short Cuts

Hi All, I am new to this Forum and glad to see the sharing of knowledge amongts all of us. To add to my own contribution, I am uploading…

Started by PRASHANT BHANAWAT

110 Aug 29
Reply by Vajirapanie Bandaranayake

RSS

© 2010   Created by Finance 3.0.

Badges  |  Report an Issue  |  Terms of Service

Sign in to chat!