Gary,
i have done this the buy / sell and i am not able to implement the whole logic in the excel... its literally looks like i need do every cell by cell....
I dont know VB... i am not a coder....
Just looking to do it in excel 2003/2007.......
For me its mind breaking time..... to work with the randomization formale......
rgds,
Ganesh
________________________________
From: Gary Morris <gwmorris@att.net>
To: "ExcelVBA@yahoogroups.com" <ExcelVBA@yahoogroups.com>
Sent: Monday, 16 April 2012 8:35 PM
Subject: Re: [ExcelVBA] I Need help for coding data ???? Excel 2003 / 2007
Just use a formula, like "=SUM(C2:E2)/3". I doubt you need to
do any VBA code, unless you just want to. If you don't get one
that equals an integer, either format the cell(s) to show the number
without the decimal part or add to the formula to round up or
down.
If you have some kind of special need, you may need some VBA,
but it would need to be pretty complicated!
G.
________________________________
From: ganesh2cbe <ganesh2cbe@yahoo.co.in>
To: ExcelVBA@yahoogroups.com
Sent: Monday, April 16, 2012 7:43 AM
Subject: [ExcelVBA] I Need help for coding data ???? Excel 2003 / 2007
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
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar