Formula to work out average entry

Hello

I would like to ask a few questions about averaging…

I know Oanda has an option for AVERAGE entry. So if you entered a few positions (same or different lot sizes) at different prices then you would know exactly where is your average entry.

Is there an option like that on MT4 maybe an indicator or something?

I know how to work out the formula using a calculator on averaging using same position size on different prices but I dont know how to work out averaging on different lot sizes and different prices.

EXAMPLE

buy first position 1000 units @ 1.2274
buy second position 1000 units @ 1.2223
buy third position 1000 units @ 1.2200
buy fourth position 3000 units @ 1.2165

What would my average position be?

Can someone give me the formula, spreadsheet or indicator that gives you averaging on different prices and different lot sizes?

Thanking in advance

To work out the average you just need to multiply the number of units by the price and sum them, and then divide the sum by the total number of units:

Units Price Units x Price
1,000 1.2274 1,227.40
1,000 1.2223 1,222.30
1,000 1.2200 1,220.00
3,000 1.2165 3,649.50
6,000 7,319.20

Average 1.2199 (7,319.20 divided by 6,000 units)

Andy

The pyramiding is bad tactic…