[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [amibroker] Re: OT: For Excel 2007 users



PureBytes Links

Trading Reference Links

Hi - IB displays this message when I check my statements - perhaps the fix 
they mention will take care of your problem....

Steve

Warning: Some of the cost basis calculations displayed on your 2007 annual 
statement are incorrect and a new annual statement will be generated for US 
customers by 03/10/2008 and for non-US customers by 03/28/2008. The MTM & 
FIFO P/L calculations displayed are correct even for those transactions with 
an incorrect cost basis.

----- Original Message ----- 
From: "Phsst" <phsst@xxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Tuesday, March 04, 2008 12:00 AM
Subject: [amibroker] Re: OT: For Excel 2007 users


> Thank you for the HotFix link. My Excel 2007 had the problem, which is
> now fixed.
>
> I had hoped that maybe it would resolve a discrepancy between
> Interactive Brokers Schedule-D and my own Sch-D, but no such luck.
>
> I would caution IB customers to be wary of IB's Sch-D download for
> 2007... their calcs do not appear to be reliable. Set up your own
> spreadsheet for calculating 'Gain/Loss' from Purchase/Sell prices and
> if you are like me, your Gain/Loss will not match IB's. In my case,
> there is a several thousand dollar discrepancy which would reflect
> against me if I used IB Sch-D data versus actual trading results to
> report on my tax returns.
>
>
> --- In amibroker@xxxxxxxxxxxxxxx, "Tomasz Janeczko" <groups@xxx> wrote:
>>
>> Hello,
>>
>> Since some of you are using Excel -
>> this one is just for Excel 2007 users (pre-2007 versions are not
> affected), there was a bug in Excel
>> that caused incorrect results of calculations such as 850*77.1
> (should display 65535 but Excel 2007 displayed 100000).
>> The description and fix on Microsoft pages:
>> http://support.microsoft.com/kb/943075
>>
>> Best regards,
>> Tomasz Janeczko
>> amibroker.com
>>
>
>
>
>
> Please note that this group is for discussion between users only.
>
> To get support from AmiBroker please send an e-mail directly to
> SUPPORT {at} amibroker.com
>
> For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
> http://www.amibroker.com/devlog/
>
> For other support material please check also:
> http://www.amibroker.com/support.html
>
> Yahoo! Groups Links
>
>
>
> 




Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to 
SUPPORT {at} amibroker.com

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

For other support material please check also:
http://www.amibroker.com/support.html
 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/