How to display P&L account data in Excel Pepperstone

How to track my Pepperstone P&L in Excel

Posted on by

Having a live view of your acount data is really important (and useful) when you are spending more and more time trading in Excel!

Here is a quick guide on setting up a live Excel view of your account data, such as profile & loss (P&L), account balance and margin.

This post assumes you have set up your account number in a named range in my other post here, if not head over and finish those steps first.

Copy the following names and cell formulas into your Excel sheet.

Currency:

=RTD("fxbluelabs.excelrtd",,AccountNumber, "currency")

Balance:

=RTD("fxbluelabs.excelrtd",,AccountNumber, "balance")

Equity:

=RTD("fxbluelabs.excelrtd",,AccountNumber, "equity")

Floating PL:

=RTD("fxbluelabs.excelrtd",,AccountNumber, "pl")

Floating PL %

=RTD("fxbluelabs.excelrtd",,AccountNumber,"pl") / RTD("fxbluelabs.excelrtd",,AccountNumber,"balance")

Used Margin:

=RTD("fxbluelabs.excelrtd",,AccountNumber, "usedmargin")

Free Margin:

=RTD("fxbluelabs.excelrtd",,AccountNumber, "freemargin")

Margin Use %:

=RTD("fxbluelabs.excelrtd",,AccountNumber,"usedmargin") / RTD("fxbluelabs.excelrtd",,AccountNumber,"equity")

Last Update:

=RTD("fxbluelabs.excelrtd",,AccountNumber, "LastUpdateTime")

And that’s it!
Take a look at our downloads section for working examples of live P&L data in Excel.

Posted in HowTo, Pepperstone.

61 Comments

  4. Greate pieces. Keep writing such kind of info
    on your page. Im really impressed by your site.

    Hi there, You’ve performed a great job. I will definitely digg it and for my part recommend to my friends.

    I’m sure they will be benefited from this website.

  7. certainly like your website however you need to
    take a look at the spelling on several of your posts.

    Several of them are rife with spelling issues and I to
    find it very troublesome to tell the reality on the other hand I’ll certainly come again again.

  9. Hi, I think your website might be having browser compatibility issues.
    When I look at your blog in Ie, it looks fine but when opening in Internet Explorer, it
    has some overlapping. I just wanted to give you a quick heads up!

    Other then that, superb blog!

  10. Excellent beat ! I would like to apprentice while you amend your site, how
    can i subscribe for a blog web site? The account aided me a acceptable deal.

    I had been a little bit acquainted of this your broadcast provided bright clear concept

  11. Then once again I realized I was talking non-stop, so I asked
    them to please tell us more about Jae’s restaurants, because I definitely wanted to
    blog about it. Then we ran a few more errands and our last stop was at, Wild Birds Unlimited, because on our way to the Post
    Office sub-station, we saw Marguerite’s car
    parked outside. If you are a regular follower,
    you must have viewed this first ATC on the challenge blog too, posted
    by Carol last Wednesday to help to inspire you for our “Bold and Bright” challenge
    this month. Basically the fresh post will be above the last post that you have
    written. This was meant to be the start of a monthly series but turned out to be quite a time-consuming
    post to put together so I’ll be making this an occasional
    series instead, taking a trip through my blog’s archive whenever I
    have a time to do so.

  15. Greetings from Los angeles! I’m bored to
    death at work so I decided to check out your
    website on my iphone during lunch break. I enjoy the knowledge you
    present here and can’t wait to take a look when I get home.
    I’m surprised at how fast your blog loaded on my mobile ..

    I’m not even using WIFI, just 3G .. Anyways, superb site!

  16. Hmm is anyone else experiencing probems with the pictures
    on thi blog loading? I’m trying to figure out if its a
    problem on my end or if it’s the blog. Any feed-back wold be greatly appreciated.

    webpage

  18. We stumbled over here by a different web address and thought I should check
    things out. I like what I see so now i am following you.
    Look forward to looking into your web page repeatedly.

  19. An interesting discussion is definitely worth comment.
    I believe that you should write more on this subject, it might not be
    a taboo subject but generally people do not talk about such subjects.
    To the next! Best wishes!!

  27. you’re truly a just right webmaster. The web site loading pace is amazing.

    It kind of feels that you’re doing any distinctive trick.
    Moreover, The contents are masterwork. you have done a
    great job in this topic!

  30. Definitely imagine that that you said. Your favourite reason seemed to be at the net the easiest factor to take note of.
    I say to you, I definitely get annoyed even as folks think about
    concerns that they plainly do not know about.
    You managed to hit the nail upon the top as well as outlined out the whole thing
    with no need side effect , people could take
    a signal. Will probably be back to get more. Thanks

  31. Someone essentially assist to make seriously articles I might
    state. That is the very first time I frequented your web page
    and thus far? I surprised with the analysis you made to make this particular post amazing.

    Wonderful job!

  34. I was pretty pleased to uncover this great site. I need to to thank you for ones time due
    to this fantastic read!! I definitely liked every bit of it and i also
    have you saved as a favorite to look at new things in your blog.

  35. prediksi bandar togel terpercaya,bandar judi togel online terpercaya,kumpulan bandar togel online terpercaya,bandar togel
    aman dan terpercaya,agen bandar togel terpercaya,bandar
    togel terpercaya,5 bandar togel terpercaya,daftar bandar togel terbesar dan terpercaya,daftar agen togel terpercaya,agen togel
    terbesar dan terpercaya,agen togel terpercaya di indonesia,agen togel online terpercaya,daftar situs togel terpercaya,kumpulan situs togel online terpercaya,situs togel
    online terpercaya,situs togel terpercaya,situs bola dan togel
    terpercaya,situs terpercaya togel

  36. bandar judi togel online terpercaya,kumpulan bandar togel online terpercaya,bandar togel aman dan terpercaya,agen bandar togel terpercaya,bandar togel terpercaya,
    5 bandar togel terpercaya,daftar bandar togel
    terbesar dan terpercaya,daftar agen togel terpercaya,agen togel terbesar dan terpercaya,agen togel terpercaya di
    indonesia,agen togel online terpercaya,daftar situs togel terpercaya,kumpulan situs togel online terpercaya,situs togel online terpercaya,
    situs togel terpercaya,situs bola dan togel terpercaya,situs terpercaya togel

  37. Hmm is anyone elsse having problems with the pictures on this blog loading?
    I’m trying to determine if its a problem on my end or if
    it’s tthe blog. Any suggestions would be greatly
    appreciated.
    web site

  38. A person necessarily lend a hand to make significantly posts I’d state.
    This is the very first time I frequented your web page and thus far?
    I surprised with the analysis you made to
    create this actual put up amazing. Fantastic activity!

  42. There are different features that web hosting or blog hosts provide.
    The posts are listed in reverse order on the resulting pages from the above links, which is just how blogs are always displayed.

    I have been asked quite a few times where my blog posts can be found.
    They see a post, which looks like the picture seen above,
    and have no idea that they can click (or tap) anywhere on the
    image to get to the blog post. The little lugs you can see protruding from the backs of the doors are the answer.
    They also can add the plugins they need to optimize their blogs.

    You also need to be able to accept that not every post is going to get your motor running.
    In 2013, I began selling on eBay again, since eBay had backed out of
    many of the negative changes that made me leave in 2009.
    Just two months ago, I wrote about my growing concerns with some of eBay’s latest changes, where they seem to
    be going back in the wrong direction. Despite everything though, we love our newest son who was God’s choice for our family and who is going to push us beyond what we thought
    we could do.

  43. I’m truly enjoying the design and layout of your site.

    It’s a very easy on the eyes which makes it much more pleasant for me to come here and visit
    more often. Did you hire out a developer to create your theme?

    Exceptional work!

  45. Write more, thats all I have to say. Literally,
    it seems as though you relied on the video to make your point.
    You clearly know what youre talking about, why throw away your intelligence on just posting videos to your site when you could be giving us
    something informative to read?

  48. You actually make it seem really easy along with your presentation but I find this matter to be really
    something that I feel I might never understand.
    It kind of feels too complex and very huge for me.
    I am taking a look ahead for your subsequent put up, I will try to get the hang of it!

  49. Hello! I could have sworn I’ve been to this blog before but after reading through some of the post
    I realized it’s new to me. Nonetheless, I’m definitely happy I found it
    and I’ll be bookmarking and checking back frequently!

  50. Hey I know this is off topic but I was wondering if you knew of any widgets
    I could add to my blog that automatically tweet my newest
    twitter updates. I’ve been looking for a plug-in like
    this for quite some time and was hoping maybe you would have some experience
    with something like this. Please let me know if you run into anything.

    I truly enjoy reading your blog and I look forward to your new updates.

  52. Hey are using WordPress for your blog platform? I’m new
    to the blog world but I’m trying to get started and create my own. Do you need
    anny html coding expertise to male your own blog? Any
    help would be greatly appreciated!
    web site

  53. Hi there, I found your site by means of Google even as looking for a similar subject, your web site got
    here up, it appears to be like great. I have bookmarked it in my google bookmarks.

    Hi there, just became alert to your weblog thru Google, and located that it
    is really informative. I am gonna watch out for brussels.

    I will be grateful for those who proceed this in future.
    Many people will be benefited out of your writing. Cheers!

  57. You actually make it appear really easy with your presentation however I to find this topic to be
    really something which I feel I’d by no means understand.
    It kind of feels too complicated and very vast for me. I am having a look forward for
    your next publish, I will attempt to get the hang of
    it!

  59. On this blog I regularly follow the progress in dark matter building.
    I built this sketch easel based on the info from your blog.
    Tasha here sharing a coffee-themed slimline card created for the Spring/Summer Coffee Lovers Blog Hop!
    This card was created with the Dare 2B Artzy Perfect Blend Stamp Set and new Retro Slimline Background Die Set.
    For the background, I wanted the hot pink (my favorite color) to pop and thought
    having a black and white background with only random pieces of hot pink and silver glitter would allow the
    pink to stand out. For the card, I used the Falling From the Clouds Die (available on Amazon)
    to string some white beads on it to simulate snow falling.
    Color the sky with 526. I used a white Uni-ball Signo Gel pen to
    add white dots to the wagon. Where is the HP Support Assistant?

    You should just click our HP Printer Support web-page to know about the printer.
    On the other end, if you feel helpless to figure out the reason for the printer issue
    then you may also click our given web-links to help.
    The first two factors are clear negatives and should lead you to mark down the value of Aramco, but the third factor may help
    provide some downside protection.

Leave a Reply

Your email address will not be published. Required fields are marked *