6 Replies Latest reply: Jun 2, 2011 9:05 PM by AngelaEcheverri56

# Index Price

How can I calculate index price of each product?

I have in my base number_item, date_of_purchase, unit_price and supplier.

I would like to know the firt price of purchase and the last one, to realice how the price grow betweent those dates...

any ideas?

thanks

Angela E

• ###### Index Price

It is developed in excel (see the attach)

how can we do it by QV?

some knows???

it will be really reallly helpfull....

 date_of_purchase Product product_number unitprice Var Index ene-10 A 1010101 50 - 100 feb-10 A 1010101 54 8% 108 mar-10 A 1010101 83 54% 166 ene-11 A 1010101 98 18% 196 feb-11 A 1010101 55 -44% 110 mar-11 A 1010101 71 29% 142 ene-10 BB 19191 80 - 100 feb-10 BB 19191 89 11% 111 mar-10 BB 19191 88 -1% 110 abr-10 BB 19191 80 -9% 100 ene-11 BB 19191 85 6% 106 feb-11 BB 19191 81 -5% 101 mar-11 BB 19191 87 7% 109
• ###### Re: Index Price

Hi Angela,

the following script will give you the result:

```RawData:
Product,
product_number,
unitprice,
if(Product = peek(Product), (unitprice - peek(unitprice))/peek(unitprice)) as Var,
if(Product = peek(Product), (1+Var)*peek(Index),100) as Index
FROM IndexExample.xlsx (ooxml, embedded labels, table is Hoja1);
```

Hope this helps!

Stefan

• ###### Re: Index Price

Excellent Stefan

thanks a lot...

could you give me a extra help please?

now i need to make my resume...

i mean...

i  need to evaluate last index price, avr price, first price, and last price

by year by product...

i am a begginer and if you can help would be more than great...

tahnks...

AE

• ###### Re: Index Price

Hi Angela,

see if attached file meet your requirements.

Regards!

Stefan

• ###### Re: Index Price

Stefan

Thanks toooo much.....

it was perfect !!!!!

AE

• ###### Re: Index Price

It is developed in excel (see the attach)

how can we do it by QV?

some knows???

it will be really reallly helpfull....