Hi all member and moderator,
Great after noon !!!!
This is my first post on the this forum. I dont know how to code with the excel......
This is the Sample data
Date open high low close
2008.05.30 4899 4908 4832 4849
2008.06.02 4875 4890 4695 4723
2008.06.03 4655 4712 4630 4703
2008.06.04 4681 4720 4550 4568
2008.06.05 4598 4685 4530 4677
2008.06.06 4705 4705 4590 4606
2008.06.09 4497 4510 4400 4471
2008.06.10 4438 4470 4332 4435
2008.06.11 4465 4519 4450 4488
2008.06.12 4388 4525 4370 4511
See the code which i want to put in excel is like this.....
This is considered as the first data. On based on this i will go for the next day....
Date open high low close
2008.05.30 4899 4908 4832 4849
what i want to do here is ..... add the value of high+low+close / 3 = value.... i.e 4908+4832+4849 = 4863 This value i take it as midpoint.
So Mid point Value = 4863
=================================================
basically the activity is to buy or sell.......
For this action buy / sell .... is defined as entry qualifications. Once this is met. The Buy/ Sell order is placed. The order will have a Exit qualification i.e... either Loss or Profit.
one entry and one exit.
The qualification is done on based on the currend day data - namely high+low+close / 3 = midpoint.
Entry - Closed value is taken
If Close is greater than Midpoint - Buy
If Close is lesser than Midpoint - Sell
Exit for Buy
1) - If Buy, then next day Open & low must be greater than Midpoint.
Result = Previous Closed Value - current day closed value = Profit / Loss.
( i ) If Buy, then next day Open is lesser than Midpoint.
Result = Previous Closed Value - Open value = Loss.
( ii ) If Buy, then next day Open Value is greater than Midpoint but LOW Value is lesser than the Midpoint.
Result = Previous Closed Value - Midpoint = Loss.
If Close is lesser than Midpoint - Sell
Exit for Sell
1) If Sell, then next day Open & High must be lesser than Midpoint.
Result = Previous Closed Value - Current Closed Value = Profit / Loss.
( i ) If Sell, then next day Open Value is greater than Midpoint.
Result = Previous Closed Value - Open value = Loss.
( ii ) If Sell, then next day Open Value is lesser than Midpoint but High Value is greater than the Midpoint.
Result = Previous Closed Value - Midpoint = Loss.
Thanks & regards,
Ganesh
http://www.2shared.com/file/K_nkTDhB/ganesh2cbe.html
Guys i know to code this data is very tough....
Please zip all files prior to uploading to Files section.
Tidak ada komentar:
Posting Komentar