Kamis, 23 Oktober 2014

[smf_addin] Digest Number 3217

15 Messages

Digest #3217
1b
Re: Changes in Yahoo Option Quotes web pages by "Randy Harmelink" rharmelink
1h
Re: Changes in Yahoo Option Quotes web pages by "Randy Harmelink" rharmelink
1i
Re: Changes in Yahoo Option Quotes web pages by "Randy Harmelink" rharmelink
2a
2b
Re: AAII Sentiment Survey by "Randy Harmelink" rharmelink
4a
4b
Re: =smfGetOptionQuotes ? by "Randy Harmelink" rharmelink

Messages

Thu Oct 23, 2014 7:59 am (PDT) . Posted by:

bob_15861586


Thank you very much for this update. Will this version work with Excel 2003?


Bob

Thu Oct 23, 2014 8:29 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

As far as I know, yes.

On Thu, Oct 23, 2014 at 7:59 AM, bob_15861586@...wrote:

>
> Thank you very much for this update. Will this version work with Excel
> 2003?
>
>

Thu Oct 23, 2014 10:36 am (PDT) . Posted by:

bob_15861586

Randy,

I have just installed a fresh version of Excel 2013. If I just install your latest update without installing the base package should it work?


Thanks
Bob

Thu Oct 23, 2014 11:43 am (PDT) . Posted by:

bob_15861586

Randy,

I have upgraded to what I believe is the latest (e.g. the new beta) version of the add-in. However, the message string is still: Stock Market Functions add-in, Version 2.1.2014.01.30 (C:\SMF Add-In; ; 1)
Does that mean the upgrade did not happen? I get stock quotes but not option quotes. I am hoping you can help.

I am now using the 2013 version of Excel.

Bob

Thu Oct 23, 2014 1:14 pm (PDT) . Posted by:

bob_15861586

Randy,

I reinstalled your "new package" again and this time it worked. I am not sure why it did not work the first time. Most of the functions, including the option pricing, appears to be working. However, the following use to
work:
=smfGetYahooOptionQuote("BRK-B", "P", DATE(2016,1,15), 105,"a")
This is suppose to return the value of a put on BRK-B. However, in my spread sheet in produces
an error. I will be happy to upload a simple spread sheet showing the error if that would help you.




Thanks
Bob

Thu Oct 23, 2014 1:19 pm (PDT) . Posted by:

bob_15861586

Randy,

I reinstalled your "new package" again and this time it worked. I am not sure why it did not work the first time. Most of the functions, including the option pricing, appears to be working. However, the following use to
work:
=smfGetYahooOptionQuote("BRK-B", "P", DATE(2016,1,17), 105,"a")
This is suppose to return the value of a put on BRK-B. However, in my spread sheet in produces
an error. I will be happy to upload a simple spread sheet showing the error if that would help you.




Thanks
Bob

Thu Oct 23, 2014 4:56 pm (PDT) . Posted by:

paulo_million

Randy.

Thanks for the work.


the function =smfGetOptionQuotes("SPG"&" "&"jan"&" "&2015&" "&"$170.00"&" "&"put";"s")


does not work. It doesn't give the strike price but the Last option price.


Thanks.

Thu Oct 23, 2014 5:16 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Add-ins are only loaded when you start up EXCEL, so if you installed the
"new package" with EXCEL open, the changes wouldn't have been picked up
until EXCEL was closed and restarted. Hopefully, that was the issue?

The reason BRK-B isn't working is that Yahoo is using "BRK-B" as the ticker
symbol for the list of options quotes, but each option quote is just using
"BRKB" instead. I'll have to put something in to handle that special
situation, and strip out hyphens when looking for the individual option
contracts.

On Thu, Oct 23, 2014 at 1:19 PM, bob_15861586@...wrote:

>
> I reinstalled your "new package" again and this time it worked. I am not
> sure why it did not work the first time. Most of the functions, including
> the option pricing, appears to be working. However, the following use to
> work:
> =smfGetYahooOptionQuote("BRK-B", "P", DATE(2016,1,17), 105,"a")
> This is suppose to return the value of a put on BRK-B. However, in my
> spread sheet in produces
> an error. I will be happy to upload a simple spread sheet showing the
> error if that would help you.
>
>

Thu Oct 23, 2014 5:20 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Ouch. Sorry about that. I thought I had checked that one out, but I had the
wrong offset for the lookup column.

I'll be uploading a new ZIP file in a short time.

Thanks for the heads up.

On Thu, Oct 23, 2014 at 3:57 PM, milliongoal@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> the function =smfGetOptionQuotes("SPG"&" "&"jan"&" "&2015&" "&"$170.00"&"
> "&"put";"s")
>
> does not work. It doesn't give the strike price but the Last option price.
>
>

Thu Oct 23, 2014 5:26 pm (PDT) . Posted by:

bob_15861586

Randy,

I had to uninstall the old one and then install the new one.. I then had to close and restart EXCEL twice. I do
not understand why I had to do it twice. Maybe I made a mistake. Maybe when I was quitting EXCEL I
just closed the file. I am just not sure.


A few minutes ago, I tried the following command:
=smfGetYahooOptionQuote("BRKB", "P", DATE(2016,1,15),105,"a")

This came up with an error. Would you like me to upload the spread sheet?


Bob




Thu Oct 23, 2014 10:11 am (PDT) . Posted by:

zacharycal

Hello,


I am on the site where the historical data for the survey is located - Sentiment Survey | AAII: The American Association of Individual Investors http://www.aaii.com/sentimentsurvey.


http://www.aaii.com/sentimentsurvey

Sentiment Survey | AAII: The American Association of Ind... http://www.aaii.com/sentimentsurvey AAII's Investor Sentiment Survey shows the percentage of investors who are market bullish, bearish, or neutral on stocks



View on www.aaii.com http://www.aaii.com/sentimentsurvey
Preview by Yahoo




The link to download the CSV is at the bottom of page and I tried to import via =smfGetCSVFile(http://www.aaii.com/files/surveys/sentiment.xls); however, after a do the array nothing is populated.


Has anyone had any luck with this?


Thanks.

Zach

Thu Oct 23, 2014 5:36 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The smfGetCSVFile() function won't work -- the link is to an XLS workbook,
not a CSV file.

But you don't need the add-in to get the data -- instead, you can just use
a normal EXCEL workbook reference. For example, array-entering something
like this over a range:

='http://www.aaii.com/files/surveys/[sentiment.xls]SENTIMENT'!A4:M48

Will return the data from range A4:M48 of that workbook and the specified
worksheet.

On Thu, Oct 23, 2014 at 10:11 AM, zabrams@... wrote:

>
> I am on the site where the historical data for the survey is located - Sentiment
> Survey | AAII: The American Association of Individual Investors
> <http://www.aaii.com/sentimentsurvey>.
> [image: image] <http://www.aaii.com/sentimentsurvey>
> Sentiment Survey | AAII: The American Association of Ind...
> <http://www.aaii.com/sentimentsurvey>
> AAII's Investor Sentiment Survey shows the percentage of investors who are
> market bullish, bearish, or neutral on stocks
> View on www.aaii.com <http://www.aaii.com/sentimentsurvey>
> Preview by Yahoo
>
> The link to download the CSV is at the bottom of page and I tried to
> import via =smfGetCSVFile(http://www.aaii.com/files/surveys/sentiment.xls);
> however, after a do the array nothing is populated.
>
> Has anyone had any luck with this?
>
>

Thu Oct 23, 2014 2:01 pm (PDT) . Posted by:

steven_rourk

Not quite because that formula only will give the first data over 5%. But the first data is not always the top. Anyway I have (kind of) figure it out with a couple of formulas using an array entered INDEX and MATH function and an IF and AND function. The data being in E4:E2707 for example in row 2603 I have:
· Column H: array entered formula =E2603/INDEX(K2604:K2969,MATCH (TRUE,K2604:K2969>0,0))-1 …. This gives the % change since the last bottom
· Column I: =IF(AND(H2603>5%,E2603>E2604),E2603,0) … this gives the new top
· Column J: array entered formula =E2604/INDEX(I2605:I2970,MATCH (TRUE,I2605:I2970>0,0))-1 … This gives the % change since the last top
· Column K: =SI(Y(J2604<$J$1,E2604<E2605,H2604<0),E2604,0) … this gives the new bottom
In most cases it´s working but I´m still having some trouble when prices surpass de 5% increase, goes down again (but not enough to form a bottom) and up again. … I guess I´ll figure it out in a couple of days. Anyway thanks for the tips.

Thu Oct 23, 2014 4:55 pm (PDT) . Posted by:

bill_d_tx

Hopefully this is not a duplicate.. having trouble posting. I see the issues with the Yahoo options quote add-in but I use the more generic -smfgetoptionquotes to get quotes for positions I hold. I usually pull them from Google, using the 'switch&#39;. None of these switches work now (Yahoo,MMSN,Optionsxpress etc.)


is this all related to Yahoo format change? Does this add-in require a change of some kind?


Thanks for your help.

Thu Oct 23, 2014 5:05 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

For Yahoo, see:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/27208

For MSN, see:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/27031

But I can't think of why Google and OptionsXPress would be an issue. Hmm.
Both of these worked for me (I'm using the latest updates for Yahoo
processing mentioned above):

=smfGetOptionQuotes("SPY 10/24 2014 $195 Call","b",,"Y")
=smfGetOptionQuotes("SPY 10/24 2014 $195 Call","b",,"OX")

However, this did not:

=smfGetOptionQuotes("SPY 10/24 2014 $195 Call","b",,"G")

When I checked, it's because Google only has SPY options for the 12/20/2014
expiration date. So, this did work:

=smfGetOptionQuotes("SPY 12/20 2014 $195 Call","b",,"G")

PS: The reason you had trouble posting is that everyone is on moderated
status when they first join. I put them on unmoderated status after the
first message is sent and aproved. That's so spammers won't join just to
send out spam to everyone.

On Thu, Oct 23, 2014 at 10:59 AM, wmd0914@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Hopefully this is not a duplicate.. having trouble posting. I see the
> issues with the Yahoo options quote add-in but I use the more generic
> -smfgetoptionquotes to get quotes for positions I hold. I usually pull them
> from Google, using the 'switch&#39;. None of these switches work now
> (Yahoo,MMSN,Optionsxpress etc.)
>
> is this all related to Yahoo format change? Does this add-in require a
> change of some kind?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar