Trading systems

mehtaka

Active Member
#1
Hello frnds...
I am looking out to make a trading systems in an excel sheet.
Can experience and senior people put some light on it. As to how to make it, if any one here can share it, for only learning purpose.

I think , systems on excel sheet, will go our trading a mechnicial way, which would again remove the emotions in the mkts.

Hope to get some help.

Thanks
 

SwingKing

Well-Known Member
#2
Hello frnds...
I am looking out to make a trading systems in an excel sheet.
Can experience and senior people put some light on it. As to how to make it, if any one here can share it, for only learning purpose.

I think , systems on excel sheet, will go our trading a mechnicial way, which would again remove the emotions in the mkts.

Hope to get some help.

Thanks
Shed some light on the kind of system you want in excel.
 

mehtaka

Active Member
#3
An excel where the datas are feed up thru odin...we can put calculation on the basis of high,low ,close...few calculation from indicators....and finally two cells which gives us strong buy /sell indicators.....
 
#4
Excel offers

VBA programming and
DDE technology
ODBC interface
Design User interface

for integration with other applications

In VBA programming you can write macros which can do processing of the data on the sheet and save it in database or send it to some other application

In DDE technology odin or reuters is running on the system then you can get the live rates from these application inside excel. you can create market watch inside your excel with live rates changing in your excel sheet itself.

In ODBC interface you can treat Excel workbook as database and sheet as table and you can write SQL queries to get data from excel.

In Design User interface you can create screens in excel sheet where you can capture data entry, put validation and then store the data in database.
 

SwingKing

Well-Known Member
#5
An excel where the datas are feed up thru odin...we can put calculation on the basis of high,low ,close...few calculation from indicators....and finally two cells which gives us strong buy /sell indicators.....
I dont know how to get data through ODIN. But yes, once the data is in, making a system is not difficult. You need to at least have the basic draft of what rules you are going to follow. Do you have them drafted ?? If yes, then please post it.

Tc.
 

mehtaka

Active Member
#6
I dont know how to get data through ODIN. But yes, once the data is in, making a system is not difficult. You need to at least have the basic draft of what rules you are going to follow. Do you have them drafted ?? If yes, then please post it.

Tc.
I am working out on the systems...but as of now..we can take any trading systems explained on Traderji...and put on excel sheet....

Reason behind the preparing systems on excel sheet..is...i have been doing trading thru charts...by putting moving averages and indicators...what happens is whenever my systems gives me a call, 2nd thougt comes is ders a resistance..so this call wont work..and i used to not attend that..only than seeing the call was good enough...

So my point is..if we see systems thru charts...there are many things which will come up....and if we get thru excel sheet...we only get nos...from where to enter and exit.
 

Similar threads