Dark Theme
Light Theme
Trading Articles
Article Categories
Article Tools
Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to
register in order to view the content of the threads and start contributing to our community.
It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
Updated June 2, 2023
Top Posters
looks_one
vvhg
with 354 posts (690 thanks)
looks_two
madLyfe
with 202 posts (104 thanks)
looks_3
petrmac
with 73 posts (106 thanks)
looks_4
Big Mike
with 35 posts (165 thanks)
Best Posters
looks_one
PandaWarrior
with 75 thanks per post
looks_two
Big Mike
with 4.7 thanks per post
looks_3
vvhg
with 1.9 thanks per post
looks_4
petrmac
with 1.5 thanks per post
trending_up
361,816 views
thumb_up
1,509 thanks given
group
234 followers
forum
946 posts
attach_file
252 attachments
May 13th, 2013, 04:37 PM
Northern Germany
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,583 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,824
treydog999
Thanks for reporting, could you click debug and make a screenshot ?
vvhg
May 13th, 2013, 04:39 PM
seoul, Korea
Experience: Intermediate
Platform: Multicharts
Broker: CQG, DTN IQfeed
Trading: YM 6E
Posts: 897 since Jul 2012
Thanks Given: 291
Thanks Received: 1,039
vvhg
Thanks for reporting, could you click debug and make a
screenshot ?
vvhg
here you go
[IMG]http://my.jetscreenshot.com/12147/m_20130513-fmxc-161kb.jpg[/IMG]
Edit: I was also playing with target analysis . and its not picking up my trades. it only has FDAX sample trades in there.
May 14th, 2013, 03:26 PM
Northern Germany
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,583 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,824
treydog999
I tried on my side and everything works perfect, so I don't know how to track that error down...what version of Excel are you on?
Vvhg
May 14th, 2013, 04:55 PM
seoul, Korea
Experience: Intermediate
Platform: Multicharts
Broker: CQG, DTN IQfeed
Trading: YM 6E
Posts: 897 since Jul 2012
Thanks Given: 291
Thanks Received: 1,039
vvhg
I tried on my side and everything works perfect, so I don't know how to track that error down...what version of Excel are you on?
Vvhg
Microsoft office professional plus 2010
excel version 14.0.4734.1000 32-bit
May 16th, 2013, 04:05 PM
seoul, Korea
Experience: Intermediate
Platform: Multicharts
Broker: CQG, DTN IQfeed
Trading: YM 6E
Posts: 897 since Jul 2012
Thanks Given: 291
Thanks Received: 1,039
@vvhg
I mentioned this bug earlier but I must have forgotten to take a screenshot . Basically its not picking up the trades from my instruments only showing FDAX. Is there anyway for me to refresh it that it can pick up my trades? I don't know why I am struggling so much with this new version. Sorry for the inconvenience.
May 16th, 2013, 04:39 PM
Northern Germany
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,583 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,824
treydog999
@
vvhg
I mentioned this bug earlier but I must have forgotten to take a
screenshot . Basically its not picking up the trades from my instruments only showing FDAX. Is there anyway for me to refresh it that it can pick up my trades? I don't know why I am struggling so much with this new version. Sorry for the inconvenience.
Can you not manually refresh the pivot table? If not it would be connected to the other bug which basically is a pivot table refusing to refresh as far as I can see. I will look into it once I have the time.
Vvhg
May 16th, 2013, 04:48 PM
seoul, Korea
Experience: Intermediate
Platform: Multicharts
Broker: CQG, DTN IQfeed
Trading: YM 6E
Posts: 897 since Jul 2012
Thanks Given: 291
Thanks Received: 1,039
vvhg
Can you not manually refresh the
pivot table? If not it would be connected to the other bug which basically is a pivot table refusing to refresh as far as I can see. I will look into it once I have the time.
Vvhg
Nope, even if i unprotect the sheet and refresh all. I get "Reference is not valid" error.
May 23rd, 2013, 08:38 PM
seoul, Korea
Experience: Intermediate
Platform: Multicharts
Broker: CQG, DTN IQfeed
Trading: YM 6E
Posts: 897 since Jul 2012
Thanks Given: 291
Thanks Received: 1,039
@vvhg
I think I came up with a work around. I copy a new version of journal, then i unprotect the sheet and then put in Table1 as the new source, the entire selection of the journal tab. Does that give me the correct answers in the tables?
May 24th, 2013, 02:50 PM
Northern Germany
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,583 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,824
treydog999
@
vvhg
I think I came up with a work around. I copy a new version of journal, then i unprotect the sheet and then put in Table1 as the new source, the entire selection of the journal tab. Does that give me the correct answers in the tables?
Thanks, I will look into this, maybe I can come up with a fix with this.
Do you have to do this once or every time you want to update the pivot table?
Vvhg
May 24th, 2013, 04:06 PM
seoul, Korea
Experience: Intermediate
Platform: Multicharts
Broker: CQG, DTN IQfeed
Trading: YM 6E
Posts: 897 since Jul 2012
Thanks Given: 291
Thanks Received: 1,039
vvhg
Thanks, I will look into this, maybe I can come up with a fix with this.
Do you have to do this once or every time you want to update the
pivot table?
Vvhg
I have been doing it every time because I don't use the original copy as I don't want to break it.
Last Updated on June 1, 2023