Hi Guys!
I have some data like this:
Month | Asset
Jan/10 0.50%
feb/10 1.50%
... ...
In Excel, you could just calculate the compund interest using:
=SUMPRODUCT(PRODUCT(b2:b1000+1)-1) Where the data range is in b2 Down
This formula is equivalent of...
Hi guys!
I have a doubt regarding Excel Data Tables.
I was wondering if it's possible to refer to it using a range. For example:
The formula is:
=COUNTIF(abcp11[Data];">=01/09/10")
I want to make the "abcp11" part variable, using the name "abcp11" in the range B5...
Hi Guys!
Is there something like F4 for data tables?
I can´t fix (lock) a certain column (witch contains the months of the data) using data tables. So, when i try to drag the formula to other cells, the reference that i wanted to be fixed moves.
Any help?
Thanks in advance!
Hi Guys!
I´ve already done all the procedures:
1. Calculate the correlation between assets
2. Find the top 5 larger values and the top 5 smaller values.
Instead, i´ve had no sucess returning what are the assets that match this top 5 correlations.
I´m sure that this is a problem of...
Hi Guys!
I have a table with the mensal variation of some assets. The period is 1999-2010.
I´d already calculated the annual compound growth for each year with sucess, using sumproduct formula to identify what the year is and then return only the data that i want.
Although, I´m having some...
Hi guys!
I´ve been trying to figure out a way for calculate compound interest in pivot tables, but haven´t found anything that works.
In this link below i´ve written some observations inside the spreadsheet (v.2007).
http://www.megaupload.com/?d=PYOBGPH0
Thanks in advance.
Excellent post Point.
I was wondering if we could bold some part of the text inside the boxes to highlight important information (like the percentage of the variation y-o-y).
Does anyone know how to do it? (bold only part of the text inside boxes)
Thanks in advance!
Hi guys!
I use the 2003 version of MS Excel. Altough, i need the use of formula (EOMONTH) in v.2007. Is there any way i can make a alternative formula in v.2003 to simulate the formula (EOMONTH) in v.2007?
Thanks for your Help!