Excel to Metastock

darsh_goswami · #1 25th June 2008, 12:04 AM

Hey friends ...
Is there anybody who can convert data from Excel sheet to metastock in RT?
It requires DDE converter like DDEChartupdater.
But it is possible to code with a programme.
if any good programmer here can do this .

Regards,..
Darsh

Stokist · #2 25th June 2008, 01:14 PM

what is the format of excel? attach sample pls.....i will take a look when i get time

darsh_goswami · #3 25th June 2008, 09:42 PM

Quote:

Originally Posted by Stokist

what is the format of excel? attach sample pls.....i will take a look when i get time

Thanx Stokist ,..
Will be attaching screen shots tomorrow. When i will be able to open it during market hours.

The format is .XLS. if i will be able to save xls i will save it ,.. if i cant then will post screen shots.

Regards,..
Darsh

darsh_goswami · #4 26th June 2008, 02:35 PM

Quote:

Originally Posted by Stokist

what is the format of excel? attach sample pls.....i will take a look when i get time

http://www.mediafire.com/?ysdzjjxzyvj
http://www.mediafire.com/?znzijkjdzon

Snaps attached ,..
Plz do needful ,..

Regards,..
Darsh

darsh_goswami · #5 7th July 2008, 04:20 PM

Here it was supposed to be something happening today ??

Where r u stokist ??

Darsh

Stokist · #6 8th August 2008, 03:17 PM

here is first verison...it will convert exel data to ascii on the fly. excel file format ahs to be exactly same as the one Darsh gave earlier...next version i can make the row/column to pick OHLV values user configurable and also incorporate metastock if thsi works fine.

give excel file as input file. select output directory and click start. any changes to excel will automatically get transferred to csv file.if this works it can be made to write output in metastock format too. U need .Net 2.0 or higher.

cheers
stokist

darsh_goswami · #7 8th August 2008, 04:31 PM

Quote:

Originally Posted by Stokist

here is first verison...it will convert exel data to ascii on the fly. excel file format ahs to be exactly same as the one Darsh gave earlier...next version i can make the row/column to pick OHLV values user configurable and also incorporate metastock if thsi works fine.

give excel file as input file. select output directory and click start. any changes to excel will automatically get transferred to csv file.if this works it can be made to write output in metastock format too. U need .Net 2.0 or higher.

cheers
stokist

Dear stokist ,.. thanx alot for ur efforts ,..

Its not working , i dont know why.

Here i m sending u another snapshot of the excel sheet.

Please note that the data field to start is RAW6.

Then there r the data field requirements which anyone need to collect ,.. for any application. For metastock the Price and Incremental volume will do the job. But if any body wants bid ask along with qty.

U can try to code something using Cell Address.

hope this sheet will give u some more idea ,..

Regards,.. n best wishes.

Darsh

Stokist · #8 8th August 2008, 05:04 PM

Note that this doesn't convert static data i.e. if excel doesn't get updated with new quotes it won't convert existing data. So it starts conversion only when new ticks are updated into excel by the trading platform. So u might have to test during market hours. I don't have the odin so I did test with workaround. Started the utility and then manually updated volume/price for some stocks in the excel that opens to see if that gets converted and it did work here. it gets code (col-3),symbol(col-2), lastprice(col-12) and qty(col-11) from excel row 6 onwards.

darsh_goswami · #9 9th August 2008, 06:26 PM

Quote:

Originally Posted by Stokist

Note that this doesn't convert static data i.e. if excel doesn't get updated with new quotes it won't convert existing data. So it starts conversion only when new ticks are updated into excel by the trading platform. So u might have to test during market hours. I don't have the odin so I did test with workaround. Started the utility and then manually updated volume/price for some stocks in the excel that opens to see if that gets converted and it did work here. it gets code (col-3),symbol(col-2), lastprice(col-12) and qty(col-11) from excel row 6 onwards.

Dear Stokist ,
I tried it during market hours itself. if u can see the portfolio of the sheet is for Comodity to try out.

Then too , just do let me know when ur free enough. We can have a desktop sharing session. so that u can understand it proper way or make me understand better way if i m mistaking somewhere.
Thanx agian for ur efforts.

Darsh

The Following 3 Users Say Thank You to Stokist For This Useful Post:
darsh_goswami (8th August 2008), learn2trade08 (8th August 2008), uasish (8th August 2008)

The Following 2 Users Say Thank You to Stokist For This Useful Post:
learn2trade08 (8th August 2008), uasish (8th August 2008)