5 Messages
Digest #3549
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
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.
>
>
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(
On Sat, Oct 31, 2015 at 7:03 PM, 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"
> 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
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
I have Mr. Charles Cottles'
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
>
On Sun, Nov 1, 2015 at 5:24 PM, ethanmarcotte24@
>
> Hello everyone:
>
> I have Mr. Charles Cottles'
> 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:
Posting Komentar