CSE EOD Data !

JennyFunny · 41 Re: CSE EOD Data ! Thu Jul 28, 2011 10:05 pm

JennyFunny

Senior Manager - Equity Analytics

Posts : 452
Join date : 2011-05-20

i can find the ticker names..but it only shows MCI,RSI..;(

JennyFunny · 42 Re: CSE EOD Data ! Thu Jul 28, 2011 10:13 pm

JennyFunny

Senior Manager - Equity Analytics

Posts : 452
Join date : 2011-05-20

I can get all other indicators except price graph..

webhoundx · 43 Re: CSE EOD Data ! Thu Jul 28, 2011 10:44 pm

webhoundx

Stock Analytic

Posts : 18
Join date : 2011-02-20

SanjivFund wrote:I can get all other indicators except price graph..

Guess Sanjiv is talking about something like this? Plus my symbols are strange as well. There is a symbol with the name as 7/4/2011!

CSE EOD Data ! - Page 3 Parall10

I'm also having the same issue and thought it;s just me. What I did was deleted my database and copied cubedsol's MyNewData folder to Amibroker folder...
But I must be doing something wrong. Trying to figure out whats going on Question

CubedSol · 44 Re: CSE EOD Data ! Thu Jul 28, 2011 11:15 pm

CubedSol

Manager - Equity Analytics

Posts : 144
Join date : 2011-02-06

@SANJIV : In my LAST pm , I asked you to do something and without doing that I WONT be able to HELP YOU .
(Screenshots)/

@webhoundx : Yes this DATABASE DOES Contain several ticker entries that are NOT relevant...May be they are NO MORE Listed and YES the entry mentioned ABOVE is an error . But I am doing my trading based on this database and thats it .

You may use this data at your own risk... And the way I see is that you actually DONT need to rely on the data file I upload , Because I have clearly mentioned how to do it yourselves .

Another thing MOST of the answers/Solutions you need can be found on the upper posts/comments , Or else just PM another member who faced the same issue and get some help , Cus I might not have come across all these issues . Exclamation

Also pls refer the AMI Guide by @smallville BEFORE you raise anymore questions .

http://forum.srilankaequity.com/t6823-amibroker-53-guide-for-newbies

PS : If all fails drop me a PM

Thanks 'n' Best Regards,
CubedSol

Last edited by CubedSol on Thu Jul 28, 2011 11:27 pm; edited 1 time in total (Reason for editing : Update the post link to AmiGuide .)

webhoundx · 45 Re: CSE EOD Data ! Thu Jul 28, 2011 11:32 pm

webhoundx

Stock Analytic

Posts : 18
Join date : 2011-02-20

@CubedSol : If by any means my previous post suggested I'm trying to highlight errors in the database, please pardon me.
The reason I uploaded that screenshot and raised a question was due to my pure ignorance on the subject and because I thought I must be doing something wrong to cause those errors.
I really appreciate you spending your own time to upload the database and sharing it with other members. Please pardon me again if I offended you in any way.
Will try what you have suggested about the errors I'm getting...

Thanks
webhoundx

CubedSol · 46 Re: CSE EOD Data ! Sat Jul 30, 2011 1:55 pm

CubedSol

Manager - Equity Analytics

Posts : 144
Equity Stars : 4036
Reputation : 44
Join date : 2011-02-06
Age : 32
Location : CyberSpace

NO Worries !!

Updated files containing data until 29/02/2011 are located below .

Database Backup :
RAR : 2.81MB
http://www.4shared.com/file/Mgr2p-rz/MyNewData__Updated_29_07_2011_.html
ZIP : 3.10MB
http://www.4shared.com/file/LeqWcDag/MyNewData__Updated_29_07_2011_.html

CSE DL.xlsm : 320KB
http://www.4shared.com/file/n_xtQ_DW/CSE_DL.html

CSE DL Edited CSV.csv : 106MB
Evil or Very Mad

Last edited by CubedSol on Sat Jul 30, 2011 2:32 pm; edited 2 times in total (Reason for editing : DL Links updated)

gayanr600 · 47 Re: CSE EOD Data ! Wed Aug 03, 2011 2:11 pm

gayanr600

Equity Analytic

Posts : 31
Equity Stars : 3587
Reputation : 3
Join date : 2011-06-23
Location : Kiribathgoda

@webhoundx wrote:

SanjivFund wrote:I can get all other indicators except price graph..

Guess Sanjiv is talking about something like this? Plus my symbols are strange as well. There is a symbol with the name as 7/4/2011!

I'm also having the same issue and thought it;s just me. What I did was deleted my database and copied cubedsol's MyNewData folder to Amibroker folder...
But I must be doing something wrong. Trying to figure out whats going on

I had the same problem. So I deleted all error msg displaying area by right click & close.
Then I drew charts by drag and drop from the chart column.
Now it is ok.

CubedSol · 48 Re: CSE EOD Data ! Wed Aug 03, 2011 5:36 pm

CubedSol

Manager - Equity Analytics

Posts : 144
Equity Stars : 4036
Reputation : 44
Join date : 2011-02-06
Age : 32
Location : CyberSpace

Updated files containing data until 03/08/2011 are located below .

Database Backup :

RAR : 2.8MB
http://www.4shared.com/file/wlNnyPsl/MyNewData__Updated_03_08_2011_.html

ZIP : 3.2MB
http://www.4shared.com/file/tEh3Eb9m/MyNewData__Updated_03_08_2011_.html

PS - ASPI & MPI updated until 02/08/2011

Last edited by CubedSol on Wed Aug 03, 2011 5:44 pm; edited 1 time in total (Reason for editing : Links changed.)

JennyFunny · 49 Re: CSE EOD Data ! Wed Aug 03, 2011 6:13 pm

JennyFunny

Senior Manager - Equity Analytics

Posts : 452
Equity Stars : 4079
Reputation : 12
Join date : 2011-05-20
Age : 29
Location : Colombo

thanks cubes..

smallville · 50 Re: CSE EOD Data ! Wed Aug 03, 2011 11:04 pm

smallville

Associate Director - Equity Analytics

Posts : 4119
Equity Stars : 8940
Reputation : 530
Join date : 2011-02-03
Location : Back on Earth

@webhoundx wrote:

SanjivFund wrote:I can get all other indicators except price graph..

Guess Sanjiv is talking about something like this? Plus my symbols are strange as well. There is a symbol with the name as 7/4/2011!

I'm also having the same issue and thought it;s just me. What I did was deleted my database and copied cubedsol's MyNewData folder to Amibroker folder...
But I must be doing something wrong. Trying to figure out whats going on

Your image is not clear to me to have a look at the error even..
MAy be u can remove all symbols from the database and reinsert using cubed's database.. Charts can be obtain by double clicking the chart type or drag and drop..

JennyFunny · 51 Re: CSE EOD Data ! Thu Aug 04, 2011 8:48 am

JennyFunny

Senior Manager - Equity Analytics

Posts : 452
Equity Stars : 4079
Reputation : 12
Join date : 2011-05-20
Age : 29
Location : Colombo

Guys i managed to sought the problem out..the errors we due to incorrect date format.
This is 4th August 2011,should be inserted as 20110804 (yyyymmdd)

gayanr600 · 52 Re: CSE EOD Data ! Thu Aug 04, 2011 1:44 pm

gayanr600

Equity Analytic

Posts : 31
Equity Stars : 3587
Reputation : 3
Join date : 2011-06-23
Location : Kiribathgoda

@CubedSol wrote:Updated files containing data until 03/08/2011 are located below .

Database Backup :

RAR : 2.8MB
http://www.4shared.com/file/wlNnyPsl/MyNewData__Updated_03_08_2011_.html

ZIP : 3.2MB
http://www.4shared.com/file/tEh3Eb9m/MyNewData__Updated_03_08_2011_.html

PS - ASPI & MPI updated until 02/08/2011

It is much grateful, if you can add the "CSE DL.xlsm" file too.

CubedSol · 53 Re: CSE EOD Data ! Thu Aug 04, 2011 11:52 pm

CubedSol

Manager - Equity Analytics

Posts : 144
Equity Stars : 4036
Reputation : 44
Join date : 2011-02-06
Age : 32
Location : CyberSpace

Dear Gayan ,

No worries I've uploaded the file and you may download the same from the below link .

http://www.4shared.com/file/n_xtQ_DW/CSE_DL.html

PS - IMHO , After going through all the above posts from all our fellow members it seems that the reason for all these errors is because EVERYONE is is using their own DB structure... (Eg - DATE format) . So I thout that it'd be better for everyone IF I upload a MIRROR COPY of my DB daily , So that yall can SIMPLY replace your exsisting DB folder with .

CubedSol · 54 Re: CSE EOD Data ! Fri Aug 05, 2011 12:08 am

CubedSol

Manager - Equity Analytics

Posts : 144
Equity Stars : 4036
Reputation : 44
Join date : 2011-02-06
Age : 32
Location : CyberSpace

thanks for the -REPS given to me.... Razz

xhora · 55 Re: CSE EOD Data ! Fri Aug 05, 2011 12:54 am

xhora

Senior Manager - Equity Analytics

Posts : 497
Equity Stars : 4234
Reputation : 70
Join date : 2011-04-24
Age : 32
Location : Colombo

@CubedSol wrote: thanks for the -REPS given to me....

hey keep uploading mate
+ Rep from me

smallville · 56 Re: CSE EOD Data ! Fri Aug 05, 2011 8:29 am

smallville

Associate Director - Equity Analytics

Posts : 4119
Equity Stars : 8940
Reputation : 530
Join date : 2011-02-03
Location : Back on Earth

SanjivFund wrote:Guys i managed to sought the problem out..the errors we due to incorrect date format.
This is 4th August 2011,should be inserted as 20110804 (yyyymmdd)

I've been telling this for many times.. why nobody check it first? Twisted Evil

Date format plays a huge role in plotting correct chart movements in Amibroker.. U mess it up u get all ur charts wrong..

Its very easy for me to download the daily file from CSE site and keep uploading it with this 1 minute workout of arranging the fields in Symbol-Date-Open-Hi-low-close-vol and deleting the unnecessary fields.. Its a manual workout daily..Or at least I make sure I download the file and keep it even if I dont update it daily..

Its a great pleasure if someone with programming knowledge with PHP/JS/etc.. can write a script (VB or whatever) to grab the csv file from CSE site and mail it to our mailboxes..

gayanr600 · 57 Re: CSE EOD Data ! Fri Aug 05, 2011 8:42 am

gayanr600

Equity Analytic

Posts : 31
Equity Stars : 3587
Reputation : 3
Join date : 2011-06-23
Location : Kiribathgoda

Thanx man,
You r doing a great job.
This is my +rep from me.

JennyFunny · 58 Re: CSE EOD Data ! Fri Aug 05, 2011 9:32 am

JennyFunny

Senior Manager - Equity Analytics

Posts : 452
Equity Stars : 4079
Reputation : 12
Join date : 2011-05-20
Age : 29
Location : Colombo

ha ha cubes..great uploads thanks for taking the time
+rep from me

JennyFunny · 59 Re: CSE EOD Data ! Fri Aug 05, 2011 9:33 am

JennyFunny

Senior Manager - Equity Analytics

Posts : 452
Equity Stars : 4079
Reputation : 12
Join date : 2011-05-20
Age : 29
Location : Colombo

@smallville great idea..can anyone do it?

CubedSol · 60 Re: CSE EOD Data ! Sat Aug 06, 2011 11:34 am

CubedSol

Manager - Equity Analytics

Posts : 144
Equity Stars : 4036
Reputation : 44
Join date : 2011-02-06
Age : 32
Location : CyberSpace

Updated files containing data until 05/08/2011 are located below .

Database Backup :

RAR : 2.8MB
http://www.4shared.com/file/U_FuFRaT/MyNewData__Updated_05_08_2011_.html

ZIP : 3.2MB
http://www.4shared.com/file/7VRwBobC/MyNewData__Updated_05_08_2011_.html

CSE DL.xlsm
http://www.4shared.com/file/n_xtQ_DW/CSE_DL.html

PS - ASPI & MPI updated until 05/08/2011

ssuni · 61 Re: CSE EOD Data ! Sat Aug 06, 2011 7:54 pm

ssuni

Manager - Equity Analytics

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

@CubedSol wrote:

CSE DL.xlsm
http://www.4shared.com/file/n_xtQ_DW/CSE_DL.html

PS - ASPI & MPI updated until 05/08/2011

thanks cube

CubedSol · 62 Re: CSE EOD Data ! Mon Aug 08, 2011 11:16 pm

CubedSol

Manager - Equity Analytics

Posts : 144
Equity Stars : 4036
Reputation : 44
Join date : 2011-02-06
Age : 32
Location : CyberSpace

Updated files containing data until 08/08/2011 are located below .

Database Backup :

RAR : 2.8MB
http://www.4shared.com/file/145vE99m/MyNewData__Updated_08_08_2011_.html

ZIP : 3.2MB
http://www.4shared.com/file/d6lN-rYu/MyNewData__Updated_08_08_2011_.html

CSE DL.xlsm
http://www.4shared.com/file/n_xtQ_DW/CSE_DL.html

PS - ASPI & MPI updated until 05/08/2011

webhoundx · 63 Re: CSE EOD Data ! Tue Aug 09, 2011 9:13 am

webhoundx

Stock Analytic

Posts : 18
Equity Stars : 3685
Reputation : 0
Join date : 2011-02-20

Thanks for the upload CubedSol

@smallville wrote:
Its a great pleasure if someone with programming knowledge with PHP/JS/etc.. can write a script (VB or whatever) to grab the csv file from CSE site and mail it to our mailboxes..

Currently working on this. I have a made a google spreadsheet that will auto update between 3pm-4pm every weekday with CSE site's CSV data. I was planning to test the process this week and let you guys know... Emailing part I'm currently working on. (A bit hard to find time with work and all Sad

)

JennyFunny · 64 Re: CSE EOD Data ! Tue Aug 09, 2011 9:20 am

JennyFunny

Senior Manager - Equity Analytics

Posts : 452
Equity Stars : 4079
Reputation : 12
Join date : 2011-05-20
Age : 29
Location : Colombo

thanks..
+rep

twimalasuriya · 65 Re: CSE EOD Data ! Tue Aug 09, 2011 8:22 pm

twimalasuriya

Senior Equity Analytic

Posts : 81
Equity Stars : 3645
Reputation : 6
Join date : 2011-06-28
Age : 44
Location : Colombo

@webhoundx wrote:Thanks for the upload CubedSol

@smallville wrote:
Its a great pleasure if someone with programming knowledge with PHP/JS/etc.. can write a script (VB or whatever) to grab the csv file from CSE site and mail it to our mailboxes..

Currently working on this. I have a made a google spreadsheet that will auto update between 3pm-4pm every weekday with CSE site's CSV data. I was planning to test the process this week and let you guys know... Emailing part I'm currently working on. (A bit hard to find time with work and all )

Guys.

I have already developed a similar script that run as a cron job ( a scheduler running on linux ) each day (excluding holidays) , download the EOD, data, convert to excel , and then mail it to csereports@googlegroups.com, so the members of the google group get a copy.

I have another script that hourly runs at 10am till 3pm that gives same data, for the owner of http://samueldaniel7.blogspot.com/

If anyone wants I can easily develop a script to send EOD data in metastock format itself.

If anyone is interested I can share my scripts too. Its written in php.

Sponsored content

Latest topics

CSE EOD Data !

41 Re: CSE EOD Data ! Thu Jul 28, 2011 10:05 pm

JennyFunny

42 Re: CSE EOD Data ! Thu Jul 28, 2011 10:13 pm

JennyFunny

43 Re: CSE EOD Data ! Thu Jul 28, 2011 10:44 pm

webhoundx

44 Re: CSE EOD Data ! Thu Jul 28, 2011 11:15 pm

CubedSol

45 Re: CSE EOD Data ! Thu Jul 28, 2011 11:32 pm

webhoundx

46 Re: CSE EOD Data ! Sat Jul 30, 2011 1:55 pm

CubedSol

47 Re: CSE EOD Data ! Wed Aug 03, 2011 2:11 pm

gayanr600

48 Re: CSE EOD Data ! Wed Aug 03, 2011 5:36 pm

CubedSol

49 Re: CSE EOD Data ! Wed Aug 03, 2011 6:13 pm

JennyFunny

50 Re: CSE EOD Data ! Wed Aug 03, 2011 11:04 pm

smallville

51 Re: CSE EOD Data ! Thu Aug 04, 2011 8:48 am

JennyFunny

52 Re: CSE EOD Data ! Thu Aug 04, 2011 1:44 pm

gayanr600

53 Re: CSE EOD Data ! Thu Aug 04, 2011 11:52 pm

CubedSol

54 Re: CSE EOD Data ! Fri Aug 05, 2011 12:08 am

CubedSol

55 Re: CSE EOD Data ! Fri Aug 05, 2011 12:54 am

xhora

56 Re: CSE EOD Data ! Fri Aug 05, 2011 8:29 am

smallville

57 Re: CSE EOD Data ! Fri Aug 05, 2011 8:42 am

gayanr600

58 Re: CSE EOD Data ! Fri Aug 05, 2011 9:32 am

JennyFunny

59 Re: CSE EOD Data ! Fri Aug 05, 2011 9:33 am

JennyFunny

60 Re: CSE EOD Data ! Sat Aug 06, 2011 11:34 am

CubedSol

61 Re: CSE EOD Data ! Sat Aug 06, 2011 7:54 pm

ssuni

62 Re: CSE EOD Data ! Mon Aug 08, 2011 11:16 pm

CubedSol

63 Re: CSE EOD Data ! Tue Aug 09, 2011 9:13 am

webhoundx

64 Re: CSE EOD Data ! Tue Aug 09, 2011 9:20 am

JennyFunny

65 Re: CSE EOD Data ! Tue Aug 09, 2011 8:22 pm

twimalasuriya

66 Re: CSE EOD Data !

Sponsored content