Senin, 02 November 2015

[smf_addin] Digest Number 3549[1 Attachment]

5 Messages

Digest #3549
1a
SMFpricesbetween by scottandrewjackson
1b
Re: SMFpricesbetween by "Randy Harmelink" rharmelink
3a
Position Dissector by ethanmarcotte24
3b
Re: Position Dissector [1 Attachment] by "Randy Harmelink" rharmelink

Messages

Sat Oct 31, 2015 7:28 pm (PDT) . Posted by:

scottandrewjackson

I am having problems with he SMFPricesBetween function:


Specifically, the data isnt populating when i enter in "01" in the field portion. and then i tried to use a cell reference and the "01" won't display. it only displays"1" unless I designate the cell to display text. Here is a link to the spreadsheet, thank you in advance.


Event Study PRice Changes.xlsx https://www.dropbox.com/s/buj2gi72eyflahb/Event%20Study%20PRice%20Changes.xlsx?dl=0



https://www.dropbox.com/s/buj2gi72eyflahb/Event%20Study%20PRice%20Changes.xlsx?dl=0

Event Study PRice Changes.xlsx https://www.dropbox.com/s/buj2gi72eyflahb/Event%20Study%20PRice%20Changes.xlsx?dl=0 Shared with Dropbox



View on www.dropbox.com https://www.dropbox.com/s/buj2gi72eyflahb/Event%20Study%20PRice%20Changes.xlsx?dl=0
Preview by Yahoo




Sat Oct 31, 2015 7:34 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The date in cell I9 needs to be a serial date, and the value in cell K1 (or
K2) needs to be a string literal. The easiest way to get a string literal
that is all numbers is to enter it starting with a single quote, such as:

'01

However, you can use a number there, if you change the formula to something
like:

=smfPricesBetween(B9,I9,I9,TEXT($K$1,"00"))

On Sat, Oct 31, 2015 at 7:03 PM, scottandrewjackson@...wrote:

> I am having problems with he SMFPricesBetween function:
>
> Specifically, the data isnt populating when i enter in "01" in the field
> portion. and then i tried to use a cell reference and the "01" won't
> display. it only displays"1" unless I designate the cell to display text.
> Here is a link to the spreadsheet, thank you in advance.
>
>

Sun Nov 1, 2015 2:34 am (PST) . Posted by:

wongkayau

Hello Randy,

I have found the reason for the error. The data is too big to store in the cell. If we change it to Left(tt, 1) , then it works.

Thank you so much again for the lovely smf addin.

Cheers,
Laurent

Sun Nov 1, 2015 5:14 pm (PST) . Posted by:

ethanmarcotte24

Hello everyone:
I have Mr. Charles Cottles's position dissector. I want to add two columns which will be labeled as adjustment columns on both the put and call side. Anyone kind enough to modify the existing one with the new format?. Thank you in advance.
Warm Regards
Ethan
Attachment(s) from
1 of 1 Photo(s)

Sun Nov 1, 2015 5:23 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Wrong Yahoo group?

On Sun, Nov 1, 2015 at 5:24 PM, ethanmarcotte24@... wrote:

>
> Hello everyone:
>
> I have Mr. Charles Cottles's position dissector. I
> want to add two columns which will be labeled as adjustment columns on both
> the put and call side. Anyone kind enough to modify the existing one with
> the new format?. Thank you in advance.
>
> Warm Regards
>
> Ethan
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar