Minggu, 31 Januari 2016

[smf_addin] Digest Number 3621

9 Messages

Digest #3621
2b
Re: smfgetoptionquote not working by "Randy Harmelink" rharmelink
2c
Re: smfgetoptionquote not working by "Randy Harmelink" rharmelink
2e
Re: smfgetoptionquote not working by "Randy Harmelink" rharmelink
2g
Re: smfgetoptionquote not working by "Randy Harmelink" rharmelink

Messages

Sat Jan 30, 2016 8:55 am (PST) . Posted by:

ssztaba

I'm far away from my home computer, adjnd I've run into a problem that I'm hoping to use as a learning experience-- my laptop developed a problem and it's in for a repair.

But until it's hopeful repair I'm left without access to my Excel program with my VBA routines and the smf add-in . This means that I can't do my stock trading updates to my Excel prrogram. f I don't have easy access to the file, other than via a cumbersome connectin from my ipad via a GoTomyPc app to my home PC where I have a month old Excel backup .

I can solve the access to my data by storing my data on Dropbox, or some similar cloud storage facility, but that would still leave me with the problem of how to have my Excel program ( 2002 or 2003) with the VBA code and the smf add-in available to me from the cloud.

Doea anyone know of a way to put Excel, together with VBA code and the smf add-in in the cloud so that I wouldn't be put out of business if my PC were to die in the future ??

Thanks

Stan Sztaba


Sat Jan 30, 2016 4:00 pm (PST) . Posted by:

dtrynoski

Trying to just get a call option for Citigroup ("C") using their examples and its not working:


=smfgetoptionquote("C May 2016 $40 Call","zba",1)



am I missing something?


Sat Jan 30, 2016 4:15 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Working fine here. You didn't define "not working" so I have nothing to
diagnose. But I just did a copy and paste of your formula and get this:

Ticker Symbol Bid Price Ask Price
C160520C00040000 $4.30 $4.45
Are you using an older version of the add-in? I had to make a change to the
"monthly option cycle" determination early last year because they changed
the expiration date of the monthly options from Saturdays to Fridays, to
match the Friday expiration dates of the weeklies.

You can always check the version of the add-in you're using with:

=RCHGetElementNumber("Version")

If the function below works, that date processing might be the problem:

=smfgetoptionquotes("C 5/20 2016 $40 Call","zba",1)

Otherwise, you might just have gotten a bad response from Yahoo. You could
try running the smfForceRecalculation macro to get a fresh copy of the web
page from Yahoo.

On Sat, Jan 30, 2016 at 4:46 PM, dtrynoski@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Trying to just get a call option for Citigroup ("C") using their examples
> and its not working:
>
> =smfgetoptionquote("C May 2016 $40 Call","zba",1)
>
> am I missing something?
>
>

Sat Jan 30, 2016 4:33 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

PS: I said I cut and pasted your formula, but I did have to fix the
function name to get it to work...to plural "quotes".

On Sat, Jan 30, 2016 at 4:46 PM, dtrynoski@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Trying to just get a call option for Citigroup ("C") using their examples
> and its not working:
>
> =smfgetoptionquote("C May 2016 $40 Call","zba",1)
>
> am I missing something?
>

Sat Jan 30, 2016 6:20 pm (PST) . Posted by:

dtrynoski

When I type in the following formula

=smfgetoptionquotes("C 5/20 2016 $40 Call","zba",1)





I get "Ticker Symbol" returned to the cell but not the table. Is there an excel setting I need to change? I tryed the SMF recalculate worksheet and got the same result. I also tried the same formula using 5/19 with the same result.


Version returns:
Stock Market Functions add-in, Version 2.1.2015.08.13 (C:\SMF Add-In; ; ; 1)


Sat Jan 30, 2016 7:41 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You need to array-enter the formula over a range to get all the data. A
formula can only return data to cells that it has been given access to.
Since you entered it into a single cell, you just got the value from the
first row and column of the table.

On Sat, Jan 30, 2016 at 7:20 PM, dtrynoski@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> When I type in the following formula
>
> =smfgetoptionquotes("C 5/20 2016 $40 Call","zba",1)
>
> I get "Ticker Symbol" returned to the cell but not the table. Is there an
> excel setting I need to change? I tryed the SMF recalculate worksheet and
> got the same result. I also tried the same formula using 5/19 with the same
> result.
>
> Version returns:
> Stock Market Functions add-in, Version 2.1.2015.08.13 (C:\SMF Add-In; ; ;
> 1)
>
>

Sat Jan 30, 2016 8:24 pm (PST) . Posted by:

dtrynoski

I can't seem to figure out how to enter it as an array. Would I create a named range first?

Sat Jan 30, 2016 8:32 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

From the documentation for the function:

"In most cases, this will need to be an array-entered formula. To
array-enter a formula in EXCEL, first highlight the range of cells where
you would like the returned data to appear -- the number of rows for the
range should be AT LEAST the number of ticker symbols you are requesting
from the function, while the number of columns for the range should be AT
LEAST the number of data items you are requesting for each ticker symbol
from the function. Next, enter your formula and then press
Ctrl-Shift-Enter."

Since you have a header row, you'd want a 3-column by 2-row range.

On Sat, Jan 30, 2016 at 9:24 PM, dtrynoski@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I can't seem to figure out how to enter it as an array. Would I create a
> named range first?
>

Sat Jan 30, 2016 9:12 pm (PST) . Posted by:

dtrynoski

That worked, getting the expected result now. Thank you!
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar