Bogus Costs shown in CDAX and DFN

lokka1 · 1 Bogus Costs shown in CDAX and DFN Wed Jun 01, 2011 10:02 am

lokka1

Manager - Equity Analytics

Posts : 132
Equity Stars : 5085
Reputation : 8
Join date : 2011-02-16

Dear Members,
Please check the cost of your shares in the CDAX and DFN. There are huge mistakes in the costs. If any of you know what caused this and the remedy please let us know. Must be one of those GILMARTs!
Lokka1

Gaja · 2 Re: Bogus Costs shown in CDAX and DFN Wed Jun 01, 2011 10:12 am

Gaja

Associate Director - Equity Analytics

Posts : 3127
Equity Stars : 9682
Reputation : 260
Join date : 2011-01-27
Age : 40
Location : Colombo

for CDAX, it shown the last purchase price as the cost of the investment, but for DFN it seems ok, i personally having excel sheet to up date my costs

ssuni · 3 Re: Bogus Costs shown in CDAX and DFN Wed Jun 01, 2011 10:19 am

ssuni

Manager - Equity Analytics

Posts : 197
Equity Stars : 5018
Reputation : 10
Join date : 2011-04-18

Gaja wrote:for CDAX, it shown the last purchase price as the cost of the investment, but for DFN it seems ok, i personally having excel sheet to up date my costs

Plz tell me,how you update your excel sheet?

do u download the quotes from DIRECTFN or from cse/lk?

If u are dwnloading from directfn where do u save them? how do u import it into excel?

Gaja · 4 Re: Bogus Costs shown in CDAX and DFN Wed Jun 01, 2011 10:38 am

Gaja

Associate Director - Equity Analytics

Posts : 3127
Equity Stars : 9682
Reputation : 260
Join date : 2011-01-27
Age : 40
Location : Colombo

ssuni wrote:

Gaja wrote:for CDAX, it shown the last purchase price as the cost of the investment, but for DFN it seems ok, i personally having excel sheet to up date my costs

Plz tell me,how you update your excel sheet?

do u download the quotes from DIRECTFN or from cse/lk?

If u are dwnloading from directfn where do u save them? how do u import it into excel?

i update it manually, adjusting for new buyes, sells dividend received, rights purchased etc, which will give me the accurate cost

hunter · 5 Re: Bogus Costs shown in CDAX and DFN Wed Jun 01, 2011 11:02 am

hunter

Moderator

Posts : 786
Equity Stars : 6938
Reputation : 114
Join date : 2011-04-27

ssuni wrote:

Gaja wrote:for CDAX, it shown the last purchase price as the cost of the investment, but for DFN it seems ok, i personally having excel sheet to up date my costs

Plz tell me,how you update your excel sheet?

do u download the quotes from DIRECTFN or from cse/lk?

If u are dwnloading from directfn where do u save them? how do u import it into excel?

That is easy:
Go to Customer > Cash statement
in Cash statement, right click the mouse and select 'export to excel'

lokka1 · 6 Update on CDAX & DFN cost per share Wed Jun 01, 2011 12:12 pm

lokka1

Manager - Equity Analytics

Posts : 132
Equity Stars : 5085
Reputation : 8
Join date : 2011-02-16

Dear Members,
I was just informed by Asia Securities that by mistake a wrong file was uploaded giving false cost per share to many members portfolios. They are in the process of correcting them and should be corrected after 5:30pm today. Let us keep our fingers crossed that it will be done.
lokka1

ssuni · 7 Re: Bogus Costs shown in CDAX and DFN Wed Jun 01, 2011 12:29 pm

ssuni

Manager - Equity Analytics

Posts : 197
Equity Stars : 5018
Reputation : 10
Join date : 2011-04-18

hunter,
Go to Customer > Cash statement
in Cash statement, right click the mouse and select 'export to excel'

It isn't available in DFN!!

thighrokker · 8 Re: Bogus Costs shown in CDAX and DFN Thu Jun 02, 2011 5:43 am

thighrokker

Manager - Equity Analytics

Posts : 102
Equity Stars : 4860
Reputation : 8
Join date : 2011-05-27

Gaja wrote:for CDAX, it shown the last purchase price as the cost of the investment, but for DFN it seems ok, i personally having excel sheet to up date my costs

In CDAX, the average cost price is shown. Not just the last purchase price.
Can someone pls confirm?