|
PureBytes Links
Trading Reference Links
|
Thanks for the replies, following gives me a number to divide by assuming
profit or loss:)
=COUNTIF(I3:I29,"<>0")
Jerry Gress
Stockton, Ca.
-----Original Message-----
From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf
Of brian_z111
Sent: Friday, December 19, 2008 2:23 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: [amibroker] Re: Off Topic: Excel Spreadsheet Question
You mean in Excel?
Column A formatted as numbers then enter Column B
A1 = isnumber(A1)
A2 = isnumber(A2)
--------------------
= countif(B1:B2,"TRUE")
You can also use sum if you want the total.
--- In amibroker@xxxxxxxxxxxxxxx, "Jerry Gress"
<pleasenospamplease@xxx> wrote:
>
> Hello All,
>
> I keep a monthly spread sheet of actual trades (notes, etc.) and
like to
> automatically do an average of the day's results. For now I divide
by the
> number of inputed days by counting number of days, but can not find
how to
> divide by the number of days that have actual data.
>
> Appreciate any help.
>
> Happy Holidays
>
> Jerry Gress
> Stockton, Ca.
>
------------------------------------
**** IMPORTANT ****
This group is for the discussion between users only.
This is *NOT* technical support channel.
*********************
TO GET TECHNICAL SUPPORT from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com
*********************
For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
For other support material please check also:
http://www.amibroker.com/support.html
*********************************
Yahoo! Groups Links
------------------------------------
**** IMPORTANT ****
This group is for the discussion between users only.
This is *NOT* technical support channel.
*********************
TO GET TECHNICAL SUPPORT from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com
*********************
For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
For other support material please check also:
http://www.amibroker.com/support.html
*********************************
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/amibroker/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:amibroker-digest@xxxxxxxxxxxxxxx
mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx
<*> To unsubscribe from this group, send an email to:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|