Hi
You are describing an awful lot here and not actually indicating what
you are asking for help on.
You need to ask specific technical questions about things you can't do.
For instance, you describe your mid-point calculation. This sounds like
it should be a simple formula in an extra column, although you haven't
shown the mid points for the other days you've shown.
Is there some other way you want to present the mid point, or should it
simply go into a new column?
You are also calling it "mid point" but it is actually an average of the
high+low+close, which is certainly not a mid point, and is actually not
a meaningful number. Mid point is actually just high - low / 2.
========================
You then talk through some buy/sell strategies, but don't say anything
about what your problem is. What do you need answers to?
Remember that no one here is going to program your whole solution for
you, but we're all happy to help YOU to do it.
Regards, Dave S
________________________________
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On
Behalf Of ganesh2cbe
Sent: Monday, 16 April 2012 21:43
To: ExcelVBA@yahoogroups.com
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
----------
Visit our website at http://www.ubs.com
This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.
E-mails are not encrypted and cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender
therefore does not accept liability for any errors or omissions in the
contents of this message which arise as a result of e-mail transmission.
If verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities
or related financial instruments.
UBS reserves the right to retain all messages. Messages are protected
and accessed only in legally justified cases.
[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