Excel to Metastock

D

darsh_goswami

Guest
#1
#1
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
 
D

darsh_goswami

Guest
#3
#3
Stokist said:
:) what is the format of excel? attach sample pls.....i will take a look when i get time
Click to expand...
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
 
D

darsh_goswami

Guest
#5
#5
Here it was supposed to be something happening today ??

Where r u stokist ??

Darsh
 
S

Stokist

Member
#6
#6
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
 
D

darsh_goswami

Guest
#7
#7
Stokist said:
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
Click to expand...
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
 
S

Stokist

Member
#8
#8
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.
 
D

darsh_goswami

Guest
#9
#9
Stokist said:
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.
Click to expand...
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
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
N Export to excel from metastock MetaStock 2
E Metastock Expert Advisor Alerts in MS EXCEL?? MetaStock 0
J Convert EXCEL to Metastock MetaStock 1
E Convert Metastock Realtime to Excel MetaStock 3
M Excel to Metastock Software 0

Similar threads