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)
OK, thanks.
I replaced the file, could you try the new one?
I corrected the typo and scanned the whole thing for ref errors and my beloved links, but that seems to be all ok. My guess would be that the stop efficiency freaked out when there are no values....changed it slightly.
You will probably get the same error message again, if so just ignore it and stick your trades into the journal tab to see if the error persists...
Nah, I think it's my mistake. Easiest would be to restore formatting afterwords. so highlight 2 rows below the pasted area, top highlighted row darker brown. click the format painter and then format the pasted area by highlighting the respective rows with the painter.
Hope that makes sense...
1. copy the fresh journal tab
2. paste special: formatting into new empty workbook
3. paste your trade record
4. copy the format you pasted into the empty workbook
5. paste special: formatting into journal tab
isnt there just a way to copy the pure data from old journal to the new journal w/o any of the formatting? also isnt that the reason the journal cells are locked so that the formatting cant be messed up?
dont believe anything you hear and only half of what you see
Not that I know of, unfortunately.
That would be nice, unfortunately it is even on a protected sheet possible to mess up the formatting of the unlocked cells (which is incredibly stupid as you can select to include or exclude formatting when protecting a sheet).
So the easiest method would be to just reapply the correct formatting.
Actually, perhaps I could do that automatically via VBA.....
ya that sucks.. im not sure if its me being thick headed in the morning here but i wasnt able to make heads or tails of your previous two options.. i guess im confused as to what the diff is between entering the trades manually and just copying and pasting over values only.. unless its just that i cant get my head around not being able to only copy entered data and no formatting whats-so-ever..
dont believe anything you hear and only half of what you see
When pasting values only, pasted formulas are turned into values.
But you are of course right, if you don't unprotect, then you can't paste any formulas.....and then pasting values is perfect....stupid me....