DRAG INTO EXCEL – 100 ROW MAX LIMIT?

• 11/30/2016 at 2:10 PM #17556
  GraHal

  I’m drag & drop my Order List into Excel and then pivot into a Table, sort then to see which is the best performing Demo AutoBot.

  Unless I am missing a trick (?) there is a 100 row limit on drag & drop into Excel from PRT?

  It’s annoying there’s no way within PRT to see which Demo AutoBot is the best performer?

  Bots get stopped (for PRT reasons) and a restart loses previous profit / loss so I saw a pivot as an easy way to compare performance for up to 1 year / 500 rows … but seems I have been thwarted even in this??

  Comments / suggestions welcome please.

  GraHal

  

  GraHal

  Participant

  Topics: 211

  Replies: 8774

  Been thanked: 2180 times
  12/01/2016 at 7:30 PM #17678
  Elsborgtrading

  I also encountered that limit.

  Kasper

  

  Elsborgtrading

  Participant

  Topics: 37

  Replies: 359

  Been thanked: 154 times
  12/02/2016 at 7:53 AM #17690
  Nicolas

  I can drag more than 100 rows from the historical performance of any of the running strategies in my platform, I’m Premium, you?

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  12/02/2016 at 1:30 PM #17712
  GraHal

  I am running v10.2 with IG

  I just ran a Demo Bot and got 369 orders and sure enough all 369 Orders dragged into Excel.

  When I drag from my Executed Order List for all Bots + Manual Trades (Orders List shows 500 limit) then the limit is 100 rows dragged into Excel.

  I just double checked this to make sure and the 100 executed Orders dragged into Excel have been executed in the last 28 hours.

  Nicolas,  I’d appreciate it if you could drag from your Executed Order List as maybe the 100 row limit is an ‘IG Thing’.

  Thank You

  GraHal

  

  GraHal

  Participant

  Topics: 211

  Replies: 8774

  Been thanked: 2180 times
  12/02/2016 at 2:09 PM #17717
  Nicolas

  You mean the first tab list? “Executed”? I just successfully exported 500 lines from the list .. another Premium benefit maybe? PRT version is 10.2 – 1.8.0_45 (from 25th Nov) here, what is yours?

   

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  12/02/2016 at 3:58 PM #17723
  GraHal

  Yes thats the List … screen shot  attached.

  Same version also … screen shot for benefit of others following.

  I will email IG and ask why cant I drag more than 100 rows now I know its not a PRT imposed limitation.

  Thank You Master 🙂

  GraHal

   

   

  

  GraHal

  Participant

  Topics: 211

  Replies: 8774

  Been thanked: 2180 times
  12/06/2016 at 5:07 PM #17881
  GraHal

  Here’s the answer from IG …

  Thanks for your patience.
  

  I am sorry to say that the IG ProRealTIme platform does not allow more than 100 lines to be copied.

  

  GraHal

  Participant

  Topics: 211

  Replies: 8774

  Been thanked: 2180 times
  12/06/2016 at 5:20 PM #17882
  Nicolas

  So you’ll get more with a PRT-CFD account like mine.

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  12/07/2016 at 2:03 PM #17931
  GraHal

  Ha … yes I am tempted on a PRT CFD account, but Spread Betting is more straighforward re tax rules!
  Also Spread Betting is always in GBP no matter what market is being traded. Also a few other easier matters re Contracts and Point Values. I do run an IG CFD Account side by side with IG Sprad Betting.

  Anyway I have asked IG as follows …

  Is the ‘100 row limit drag into Excel’ on Executed Orders a limit that satisfies some IG Requirement?
  OR – as is more likely (?)
  Is the 100 row limit just some default setting that has never been looked at / reset to the 500 rows allowed by the Executed Order List … see embedded screen shot top row for the 500 row limit.

   

  

  GraHal

  Participant

  Topics: 211

  Replies: 8774

  Been thanked: 2180 times
  12/07/2016 at 5:53 PM #17953
  GraHal

  Ha I sent IG a 20 second screen shot video of me doing the drag and drop … to make sure they understood the issue!

  It appears that PRT as Platform Provider impose the 100 row limit! See below … latest answer from IG

  Thanks for your email. I understand this from your perspective, believe me I do. I agree completely with you – it will make life easier if you could simply drag and drop in one go.

  ProRealTime is a third party platform, who provide the service for a very small fee of £30 a month, in which IG will refund you for if you place 4 trades per month. You can get more drag and drop limits if you use PRT Premium, which you can only get directly from PRT. Unfortunately, our version of PRT will not be changed – as this is not our platform and they have control over what we can provide, it makes it a little difficult. I hope this helps.

   

  

  GraHal

  Participant

  Topics: 211

  Replies: 8774

  Been thanked: 2180 times
• Author
  Posts