Kamis, 16 Oktober 2014

[smf_addin] Digest Number 3209[1 Attachment]

4 Messages

Digest #3209
1a
(no subject) by "Darryl Bonfessuto"
1b
Re: [1 Attachment] by "Randy Harmelink" rharmelink
1c
Re: by "Darryl Bonfessuto"

Messages

Wed Oct 15, 2014 5:08 am (PDT) . Posted by:

"Darryl Bonfessuto"

Randy,

When I try an copy the formula over and down in the month, 3 month, 6 etc
column it repeat results from week column. What am I doing wrong? Also
formula for YTD ?

Thanks Randy

Darryl

Attachment(s) from Darryl Bonfessuto
1 of 1 File(s)

Wed Oct 15, 2014 7:54 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

When you are doing the dates across a row, you don't want the TRANSPOSE()
function in there. The normal output is across a row. You only need the
TRANSPOSE() if you're changing the output of the smfPricesByDates()
function to go down a column.

For the YTD date, you could do either of:

=DATE(YEAR(C3)-1,12,31)
=EOMONTH(C3,-MONTH(C3))

On Wed, Oct 15, 2014 at 5:01 AM, Darryl Bonfessuto dmb7111@... wrote:

>
> When I try an copy the formula over and down in the month, 3 month, 6 etc
> column it repeat results from week column. What am I doing wrong? Also
> formula for YTD ?
>
>
>

Wed Oct 15, 2014 7:11 pm (PDT) . Posted by:

"Darryl Bonfessuto"

Thanks Randy

Works Great

Darryl

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, October 15, 2014 10:55 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin]

When you are doing the dates across a row, you don't want the TRANSPOSE() function in there. The normal output is across a row. You only need the TRANSPOSE() if you're changing the output of the smfPricesByDates() function to go down a column.

For the YTD date, you could do either of:

=DATE(YEAR(C3)-1,12,31)
=EOMONTH(C3,-MONTH(C3))

On Wed, Oct 15, 2014 at 5:01 AM, Darryl Bonfessuto dmb7111@... wrote:

When I try an copy the formula over and down in the month, 3 month, 6 etc column it repeat results from week column. What am I doing wrong? Also formula for YTD ?

Wed Oct 15, 2014 7:37 am (PDT) . Posted by:


Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Uploads by forum members/A-6-Realtime For 16 TICKERS v1.xlsm
Uploaded by : digsupply <picsound@gmail.com>
Description : Real time From Google For 16 tickers

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/smf_addin/files/Uploads%20by%20forum%20members/A-6-Realtime%20For%2016%20TICKERS%20v1.xlsm

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

digsupply <picsound@gmail.com>

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar