+ Reply to Thread
Results 1 to 6 of 6

Help balancing my books

  1. #1
    Forum Contributor
    Join Date
    04-02-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    403

    Help balancing my books

    Hi Guys,

    I can't seem to P66 and P67 to equal the numbers that the website IG is providing. Does anyone have any ideas?
    I really don't feel confident trading unless I can get all the numbers to add up.
    Attached Files Attached Files
    Thanks,

    JimmyWilliams

  2. #2
    Forum Contributor
    Join Date
    11-20-2007
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2013, 2019
    Posts
    217

    Re: Help balancing my books

    There is no explanation of how the data is supposed to relate to P66 and P67. People here are not mind readers.

  3. #3
    Forum Contributor
    Join Date
    04-02-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    403

    Re: Help balancing my books

    Hi Glenn,

    the IG website doesnt say how they calculate the values O66 and O67 (this is the problem I am having, im not a mind reader)
    Ideally someone will help me out to figure what needs to be done to calculate O66 and O67, (these formulas would go in P66 and P67) I have figured out almost all of the other formulas, it would be nice to know how the website gets the "Book cost" and "Aggreate profit" calculations.

    Thanks

    I've tried all types of things but not having any luck.

  4. #4
    Forum Contributor
    Join Date
    11-20-2007
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2013, 2019
    Posts
    217

    Re: Help balancing my books

    So, you know the data inside out, and you can't work out how they calculate their figures? At least I know where I stand now. I'll have another look, but I not holding out much hope.

  5. #5
    Forum Contributor
    Join Date
    04-02-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    403

    Re: Help balancing my books

    Quote Originally Posted by GlennUK View Post
    So, you know the data inside out, and you can't work out how they calculate their figures? At least I know where I stand now. I'll have another look, but I not holding out much hope.
    I have had to download my history and then go through each item line by line to get the data in the right spots (everything in yellow). I'm a bit hesitant to send the data over the internet to someone (might steal my account or something)
    I super appreciate the help, so if you need any assistance or anything, let me know and I'll do my best to help you out.

  6. #6
    Forum Contributor
    Join Date
    04-02-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    403

    Re: Help balancing my books

    Quote Originally Posted by GlennUK View Post
    So, you know the data inside out, and you can't work out how they calculate their figures? At least I know where I stand now. I'll have another look, but I not holding out much hope.
    Have you had any luck?
    Last edited by JimmyWilliams; 04-02-2020 at 08:22 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Auto balancing of weights
    By Navin Agrawal in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-02-2015, 11:36 PM
  2. balancing workload
    By Rob201 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-11-2014, 05:39 AM
  3. open books,ink cells and then save books and move on to the next book
    By Desmond_Mocumi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-05-2013, 02:34 PM
  4. Producing balancing entries
    By The Phil in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-04-2013, 11:50 AM
  5. Balancing
    By reficuul in forum Excel General
    Replies: 8
    Last Post: 05-01-2010, 03:24 AM
  6. Balancing Operations
    By EH003268 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-04-2007, 02:13 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1