15 Messages
Digest #3217
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?
>
>
On Thu, Oct 23, 2014 at 7:59 AM, bob_15861586@
>
> 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
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
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.
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
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:
=smfGetYahooOptionQ
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
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:
=smfGetYahooOptionQ
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.
Thanks for the work.
the function =smfGetOptionQuotes
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.
>
>
"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@
>
> 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:
> =smfGetYahooOptionQ
> 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.
>
>
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
> "&"
>
> 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
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:
=smfGetYahooOptionQ
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
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?
>
>
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.
· Column H: array entered formula =E2603/INDEX(
· Column I: =IF(AND(H2603>
· Column J: array entered formula =E2604/INDEX(
· Column K: =SI(Y(J2604<
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'. 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.
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'. 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?
>
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&#
> (Yahoo,MMSN,
>
> 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:
Posting Komentar