Silicon Investor (SI) -- The First Internet Community

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Non-Tech : CyBerCorp.com -- Ignore unavailable to you. Want to Upgrade?

To: Dugout who wrote (77)	1/17/2000 6:06:00 PM
From: lizard lick	Respond to of 1001

lol, i have had 3( the first 2 i was on hold 25 and 45 minutes respectively just to get to the help desk) conversations with Quicken, the last conversation was the most indepth and he responded that Quicken is going to simply read the data as it comes in from Penson. This doesnt helpme and the fact that they charge a 1.95 a minute to help if it gets complicated doesnt encourage me to stay on the phone with them. Anyways i know what the F problem is. It is in my post before ,, Penson is recording their transactions out of order it appears because of the inability to distinguish which trade happens first when 2 or more trades happen in the same minute. This shuffled order screws up quicken . It screws up quicken not in the sense you cant import the file into a quicken register, but after importing it,, if you run an investment transaction report or a capital gains report all those out of order or mishuffled trades that loaded create a conflict and the realized gain for that particular securtity is way way off. I'm fixing them as we speak and its a F pain in the ass. They are easy to spot if you run a captial gains report and then do it by security because you will see astronically wrong numbers on the security net total summary and then you can pinpoint the trades that the incorrect shuffling is occuring on and then rematch them up. I have already seen it occur in year 2000 in my january trades one time already so Penson is either not aware of this or doesnt care. Im still wondering though, what is it that makes quicken not able to sort through the example i gave in my previous post. Do you know? Thanks

To: Dugout who wrote (77)	1/17/2000 6:18:00 PM
From: lizard lick	Respond to of 1001

Once again the solution for using quicken now is to run an investment transaction report off of the register where you imported these thousands of trades. Then do whatevever you have to do to reclassify the investment transaction report either by month or by security to see where the crazy amounts are appearing ,, and this should eventually lead you to the trades themselves that are appearing with absurd totals and in the wrong order. You can also pull the trade history report on pensons server and compare those trades and you will see what im talking about. You will find the trades in question going off in the same minute but recorded by penson in reverse order within that minute since they seem to not be taking into account seconds. You then go in manually to the quicken register and move that lot back to its rightful order position and walah! its fixed for that one trade. AS of now for me ,,upon loading a QIF file into quicken for trading activity for Feb 1999 through Dec 31 1999 4 months were a perfect match , the last 4 of the year 4 were astronomically off march april may june 3 febuary July and August were very close to perfect off by just cents. I didnt trade in January 99 with cyber ie penson.

To: Dugout who wrote (77)	1/17/2000 11:07:00 PM
From: lizard lick	Respond to of 1001

Ok i just found a second problem that will make quicken go haywire,, the first i have already explained in the previous posts. 2nd problem,, If you are long a stock and then sell but accidentally sell more shares than you are long then you would suddenly be short some amount. I think the cyber software is supposed to prevent that but i do remember it happening once in a blue moon at some point last year on cyber 1.7. It ends up causing a problem when you import that kind of trade activity into quicken because penson doesnt list the extra shares as a new position and quicken chooses to calculate a realized gain while including the new position you picked up by mistake on the trade. Here is the example you go long 1000 shrs of XYZ on april 15th at 3:58 PM the following day sell 100 on april 16th at 9:31 AM sell 300 on april 16th at 9:31 AM sell 700 on april 16th at 9:32 AM -your last sell of 700 ended up making you short 100,, basically a new position is taken out in that same last trade. The above would be listed on Pensons account page as described above 100,300,700 and when you import it into quicken that 100 shares would never show other than being included in the 700 shr trade. And it is this that quicken can not seem to handle. It doesnt know how to match it up with the subsequent trades. Since Quicken chooses to do a realized gain in the above example after the 700 final shares are sold,,,I had to manually remove the 100 shares from the 700 shr sale and make it 600 and then it made sense with the original 1000 shares that were long. I Then took the 100 shares left over and added it to a later sell that was listed for XYC for that particular days trading on XYC and it made perfect sense. You will always find a place to add those shares at the same price they were sold at when they were included in the 700 lot. I only have one more month to fix:) but this really sucks