PIB data to amibroker possible?????

I request all the programmers to come up to create a free tool.
Have a look.




http://www.amibroker.com/devlog/200...ent-kit-adk-for-cc-now-available-to-everyone/

http://www.amibroker.com/devlog/2007/03/21/new-odbcsql-plugin-version-140/

This ODBC link has a function to pull live data from CSV files. But since i hav very low knowledge of programming i cudnt get thru this.

Thanks

Dear Swagat,

The better way is, to write a Java Script,
Add it from Amibroker>tools>customize>new
Call it from Amibroker>tools

You have to create Format file by Import Wizard & copy it to format folder.
.
.
Although I am not sharing my script, but I will try to make the ways easier for others.

Regards.

Omkar

Dear Omkar
Hello

Thanks for sharing your idea.
Java script will work fine. however i just want to know that since data is added with evry tick to the files in PIB directory, are u deleting the file after script update - or deleteing the data - otherwise whole data ha to be processed every time and that will eat resources
Regards
Rajeev

Dear Rajeev,

You made me rethink,

I thought,
Amibroker's built in Importers, only updates the updated lines in CSV., even when you Import whole file.
[I have tested my scipt by adding quotes mannualy in files & I am not sure about system resources front]

But if it's consuming system resources,

Another way of deleting the file & appending to newer one is always open.

You even do not have to create OR append to newer one as you can always export from Amibroker when you want.

Regards
Omkar

Dear Rajeev,

Another idea is to keep refresh interval bit bigger suppose 20 seconds,
1] In this case you are not going to miss a single quote because unlike Yahoo, it's stored in your csv file.
2] Amobroker will take suppose 1 sec to update full CSV. (if it does so)
3] You can watch PIB itself meanwhile for breakouts etc. (depends on your trading style)

Omkar

Dear Omkar,
Hi

There are 2 points why i wrote
1. Even though for us Amibroker will look like addeing new quotes but in fact it may be happening that amibroker is overwritiing all the quotes that is why i stated system resources. And it may be having more and more heavy as the day progress. Moreover is we are having some exploration also running at the same time this may become a major issue.
2. Deleting the csv files may be possible but then it may compromise with the integrity of data and ther can be a rare chance of clash within the system

Now i look at it in difrent way - as PIB software has somthing to write on the disk can we have a system where by we just catch it and put all in one file instead of many files. If that can be possible then DDE can help us making a good integrated system
Rajeev

There are two crude methods of doing it.
1. you can use copy function of Command Prompt to merge the files into one file and use this file.

2. MS-Access can be used to pull all the data into one table which may also be exported to .txt, .csv or .xls formats.

But I have no idea how this can be done in real time at specific time intervals.
I have used access method in real time but it was limited to 1-2 stocks. Even tthe copy function has been used but only after market hours.

Best Regards,
--Ashish

Dear Ashish,

Thanks for the quick reply
I was having a different idea in mind - i.e. to intercept dump from the PIB client and then write that in the access/ or anyother RDBMS
We will keep exploring different possiilities till we can find a solution

Regards
Rajeev

I will think every way suggested by both of & try to do in limits of my knowledge. (as I am not trained in programming. just learned from internet on try n error basis).

I will post here if anything I find new,faster,convenient.

Thanks to both of you.

Omkar

Dear Omkar,

Hello.

I too have very little knowledge - do a bit of ASP and asl some VB. I we can pool our knowledge we can make 1 & 1 = 11.
Let us work towards it
Ragards
Rajeev