Jump to content

How should FIFO affect the remaining average price?


CJ_Hughes

Recommended Posts

I recently asked IG a question about the FIFO netting method they use and how it affects the average price of your remaining position?  Maybe I will have better luck getting a clearer answer from the community.

I have the following example:

2 purchases: 

1st: 8 units @ price 110

2nd: 8 units @ price 100

Therefore average price is 105 for 16 units purchased.

If I sell 4 units at 100, I assume that this sale should be netted against the 1st purchase of 8 units @ price 110, effectively meaning that this purchase is now worth 4 shares @ price 110 and I have realized a loss of of (4 x -10) = -$40 which is reflected in my capital.

My portfolio  should be left with:

1st: 4 units @ price 110 (FIFO nets my sale of 4 units against my first purchase of 8 units @ price 110)

2nd: 8 units @ price 100

Therefore, the average price of the remaining 12 units is now 103.33.

 

I would like the community to let me know if this example is correct?  My issue is that, using the above example, when I sell 4 units in a real-life situation, IG does not adjust the average price of my position in my Portfolio.  IG continue to show my average price as 105. 

                   

 

                     
                     
                     
                     
                   
Edited by CJ_Hughes
the text format changed when it was posted
Link to comment

Hi @CJ_Hughes

Thanks for reaching out, 

Assuming this is for share trading, I think the term average price can be misleading. In reality it is more of a average purchase price/ or average cost price. This does not change with each sale because ultimately your profit will be determined by the market value of your shares less your book cost. Book cost is determined by average price x number of shares. 

Thus looking at your example, regardless of how many you sell. On average the shares cost you 105, i.e. When you sell 4 units, your average price remains 105. However your book cost will adjust from 1680 (105 x 16) to 1260 (105 x 12). 

Having said this the book cost is editable, and this will automatically change the average price. So should you prefer you are welcome to edit it on your end to reflect your preferred valuation. Please details on how to this from the following link: https://www.ig.com/uk/help-and-support/investments/share-dealing-and-isas/how-do-i-edit-my-book-cost

All the best, 

Anda

 

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • General Statistics

    • Total Topics
      22,087
    • Total Posts
      92,936
    • Total Members
      42,475
    • Most Online
      7,522
      10/06/21 10:53

    Newest Member
    IPS Temp Admin
    Joined 06/10/22 15:40
  • Posts

    • Elliott Wave Analysis TradingLounge Daily Chart, 31 May 23,   Bitcoin/U.S.dollar(BTCUSD) BTCUSD Elliott Wave Technical Analysis Function: Reactionary(Counter Trend) Mode: Corrective Structure: Zigzag Position: Wave(C) Direction Next higher Degrees: wave ((2)) of Motive Details: Wave ((2)) is likely to end at the level of 25874.30. A five-wave rise will confirm this idea. Wave Cancel invalid level: 25874.30 Bitcoin/U.S. dollar (BTCUSD)Trading Strategy: Bitcoin has recovered well from the 25874.30 level and can still hold above the MA200 line, leading us to expect Wave 2 to end at 25874.30, the price is returning to an upward trend, and a five-wave rise will support this idea. Bitcoin/U.S.dollar(BTCUSD)Technical Indicators: The price is above the MA200 indicating an Uptrend MACD and RSI are bullish momentum. TradingLounge Analyst: Kittiampon Somboonsod, CEWA Source : Tradinglounge.com get trial here!       Elliott Wave Analysis TradingLounge 4H Chart, 31 May 23,   Bitcoin/U.S.dollar(BTCUSD) BTCUSD Elliott Wave Technical Analysis Function: Follow Trend Mode: Motive Structure: Impulse Position: Wave 5 Direction Next higher Degrees: wave (C) of Zigzag Details: Wave (C) is likely to end at the level of 25874.30. A five-wave rise will confirm this idea. Wave Cancel invalid level: 25874.30 Bitcoin/U.S. dollar (BTCUSD)Trading Strategy: Bitcoin has recovered well from the 25874.30 level and can still hold above the MA200 line, leading us to expect Wave 2 to end at 25874.30, the price is returning to an upward trend, and a five-wave rise will support this idea. Bitcoin/U.S.dollar(BTCUSD)Technical Indicators: The price is above the MA200 indicating an Uptrend MACD and RSI are bullish momentum.
    • Commodity Markets: Forex, Bonds, US Gold, Silver, Iron Ore,Copper Lithium,Nickel, Crude Oil, Natural Gas. Elliott Wave   Commodities Market Summary: The USD DXY USDJPY are heading higher into Wave iii) and iv) corrections so are the FX pairs and so are GDX and US Spot Gold. So, there are no larger trends, just corrections.   Trading Strategies: No strategies as markets are in small corrective patterns.   Video Chapters 00:00 US Gov Bonds 10 Yr Yields 00:44 US Dollar Index DXY USDJPY, EURUSD, AUDUSD 05:50 US Spot Gold / GDX ETF 08:41 US Spot Silver 11:20 US Copper / Lithium / Nickel / Iron Ore 19:01 Crude Oil 21:21 Natural Gas 27:11 End   Analyst Peter Mathers TradingLounge™ Australian Financial Services Licence - AFSL 317817   Source: tradinglounge com Access Trial here... buy 1 month Get 3 months              
    • Hi @AndaIG, Please could the [LOUP] Innovator Deepwater Frontier Tech ETF be listed and made available for the ISA tax wrapper, pretty please? Many thanks, Sam
×
×
  • Create New...