Jump to content

How should FIFO affect the remaining average price?


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
      19,989
    • Total Posts
      87,951
    • Total Members
      69,142
    • Most Online
      7,522
      10/06/21 10:53

    Newest Member
    Bobminor
    Joined 25/09/22 20:58
  • Posts

    • Hey @pravid17 I hope you're well.  In the leveraged trading industry there are brokers who don't hedge client's exposure and brokers (like ourselves) who do hedge client's exposure.  In a perfect world the exposure of short clients would net off the trades of long clients however this is not always the case. Our hedging model allows us to take an exposure in the underlying market for the remaining exposure which doesn't offset - This way we don't need to hedge every trade, worry about profits of our clients and results in lower costs for hedging in the underlying market (commissions, interest etc.). So say 60% of IG customer exposure in the ASX was long and 40% of exposure on the ASX was short. The 40% would net each other off but there's a remaining 20% of customers who need to be hedged to cover their positions. We go into the market and hedge this.  We make our money primarily through our spreads and overnight funding  with other fees making up a small proportion of our revenue. I would like to remind also that IG is regulated by several bodies globally, including top-tier regulators like the UK's FCA, Germany's BaFIN, Australia's ASIC - This should be quite reassuring from a dealing execution and transparency perspective.  I hope this helps, let me know if you have any other question 
    • A survey from Reviews.org, which featured 1000 Americans, found that as many as 1 in 4 US subscribers may quit the service in the next year.    Jeremy Naylor | Writer, London | Publication date: Friday 23 September 2022  There was an interesting breakdown, but the main reason was affordability. Only 18% said they would move to a cheaper competitor. IGTV’s Jeremy Naylor looks at the numbers. Netflix subscription woes Netflix Inc (All Sessions) could be in for a rough time ahead over the next 12 months if a new survey is anything to go by, which was conducted in the US. Out of the 1,000 adults that took part in this survey undertaken by Reviews.org, around 25% of those that were covered said that they would be cancelling their Netflix subscription within the next 12 months. Now, it says with that 25% of US subscribers to Netflix considering leaving, not to join a competitor, but mostly because of pressures on household bills. This is how it is split: rising cost of subscriptions - 40% inflation - 20% a lack of content - 22% spending more time on the services of others - 18% So you can see, a minority said they were going to other services, such as those provided by Disney Plus or Amazon Prime. The cost of Netflix has risen dramatically this year as its basic plan increased by 11% in January and its other plans by 20% to 25%. Now these were the first price increases for three years, so that itself is relatively new for a lot of subscribers. Netflix share price Let's take a look at the Netflix share price. You can see on the far left hand side of this chart the COVID lows at $290.39. We saw a whacking great increase there of 141% to the top and the record high in Netflix shares back in November 2021. And that was when subscriptions were rising, people were paying more for their services, and it was all humming beautifully. And then all of a sudden people started questioning the numbers of streaming services they were undertaking with some deciding to withdraw from Netflix. All of a sudden the big drops started coming through with profit warnings and sales warnings. We've recently hit a new low of $162.50. Since then there has been a little bit of an increase. We're currently trading at $232.75, but we are down by a margin of 1.75% in today's session, which reflects this news that we could well see a relatively large drop in subscribers for Netflix in the US within the next 12 months.
    • Market data to trade the week of 26 September: Nasdaq; NXT From the economic calendar next week IG technical analyst, Axel Rudolph, picks up on a short trade on the Nasdaq around US inflation data. Meanwhile, despite another light week of corporate data, Axel picks out the chart of Next plc (NXT) as an interesting trade to think about.          
×
×
  • Create New...