15 Messages
Digest #3215
Messages
Tue Oct 21, 2014 6:11 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Yahoo Key Statistic does not cover all stocks. I gave up using yahoo because they do not cover quite a few of the stocks I follow.
Sorry, I did not keep a list of the stocks that are not in Yahoo key statistics.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, October 20, 2014 7:30 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RCHGetElementNumber (1,33,34)
Yes, MSN elements are probably all obsolete now.
52-week low and high are within the Yahoo Key Statistic web page elements.
For company description, see: https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/27172
On Mon, Oct 20, 2014 at 12:43 PM, dcharlotte99@...wrote:
I'm getting 'Error' messages for the following 'RCHGetElementNumber' codes:
1 - Company Description
33 - 52-week Low
34 - 52-week High
I think this may be due to the new MSN format. What are the easiest replacements for these codes?
Sorry, I did not keep a list of the stocks that are not in Yahoo key statistics.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, October 20, 2014 7:30 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RCHGetElementNumber (1,33,34)
Yes, MSN elements are probably all obsolete now.
52-week low and high are within the Yahoo Key Statistic web page elements.
For company description, see: https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/27172
On Mon, Oct 20, 2014 at 12:43 PM, dcharlotte99@
I'm getting 'Error&#
1 - Company Description
33 - 52-week Low
34 - 52-week High
I think this may be due to the new MSN format. What are the easiest replacements for these codes?
Tue Oct 21, 2014 6:25 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Since you did not provide any description of what you are trying to do . Here is my suggestion.
Why not use Finbiz screener - http://www.finviz.com/screener.ashx ? Set the parms as you want them then save the URL.
Then you can invoke the URL anytime you. Once you have the results click the "Export" in the lower right hand corner, save the file and then write you code to pull from that file.
It a manual process but then how often do you screen for stocks. Once you have the file you can use links to pull selected data to your worksheet.
You don't really need any SMF ADDIN functions to do that.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, October 20, 2014 8:19 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Stock Screener Template
The add-in isn't a screening tool, but a data retrieval tool. You'd need to retrieve too much data to use it as a screening tool, which would be an unfair burden on the free data sources.
Check over the function documentation. Each should have at least one example of using the function.
On Mon, Oct 20, 2014 at 5:12 PM, robkennedy23@...wrote:
I joined awhile ago, but I really want to dig into the power of this tool. Does anyone have any stock screener examples that they wouldn't mind letting me take look at to get some ideas and see how all these codes work? I would really appreciate it.
Why not use Finbiz screener - http://www.finviz.com/screener.ashx ? Set the parms as you want them then save the URL.
Then you can invoke the URL anytime you. Once you have the results click the "Export" in the lower right hand corner, save the file and then write you code to pull from that file.
It a manual process but then how often do you screen for stocks. Once you have the file you can use links to pull selected data to your worksheet.
You don't really need any SMF ADDIN functions to do that.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, October 20, 2014 8:19 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Stock Screener Template
The add-in isn't a screening tool, but a data retrieval tool. You'd need to retrieve too much data to use it as a screening tool, which would be an unfair burden on the free data sources.
Check over the function documentation. Each should have at least one example of using the function.
On Mon, Oct 20, 2014 at 5:12 PM, robkennedy23@
I joined awhile ago, but I really want to dig into the power of this tool. Does anyone have any stock screener examples that they wouldn't mind letting me take look at to get some ideas and see how all these codes work? I would really appreciate it.
Tue Oct 21, 2014 9:30 am (PDT) . Posted by:
"Pete A" option2z
RE: "Not sure what to tell you -- elements #13865 and #13867 are working
fine
here, for ticker symbol MMM. I don't think those element definitions have
changed since I created them."
Randy,
Sorry, I worked on the original problem for more than an hour, with no luck.
THEN, a few hours later it began to work again. One of the great mysteries
of life, I guess. Thanks for taking a look.
Pete A
fine
here, for ticker symbol MMM. I don't think those element definitions have
changed since I created them."
Randy,
Sorry, I worked on the original problem for more than an hour, with no luck.
THEN, a few hours later it began to work again. One of the great mysteries
of life, I guess. Thanks for taking a look.
Pete A
Tue Oct 21, 2014 11:07 am (PDT) . Posted by:
bob_15861586
Today, I have not been able to get any quotes on either call options or put options. It was working yesterday. I am using the function smfGetYahooOptionQu
I am also using Excel 2003. I am wondering if I should go update my version of Excel? I using Version 2.1.2012.02.
Thanks
Bob
Tue Oct 21, 2014 12:08 pm (PDT) . Posted by:
"Marco Deen" marco.deen
I'm having the same issue here, so it's likely to be something at their end.
On Tue, Oct 21, 2014 at 2:07 PM, bob_15861586@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
>
> Today, I have not been able to get any quotes on either call options or
> put options. It was working yesterday. I am using the function smfGetYahooOptionQuote.
> Is Yahoo having problems today?
>
>
> I am also using Excel 2003. I am wondering if I should go update my
> version of Excel? I using Version 2.1.2012.02.02 of SMF. Is that part of
> the problem? Will the latest version of SMF work with Excel 2003?
>
>
> Thanks
>
> Bob
>
>
>
>
On Tue, Oct 21, 2014 at 2:07 PM, bob_15861586@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
>
> Today, I have not been able to get any quotes on either call options or
> put options. It was working yesterday. I am using the function smfGetYahooOptionQu
> Is Yahoo having problems today?
>
>
> I am also using Excel 2003. I am wondering if I should go update my
> version of Excel? I using Version 2.1.2012.02.
> the problem? Will the latest version of SMF work with Excel 2003?
>
>
> Thanks
>
> Bob
>
>
>
>
Tue Oct 21, 2014 1:49 pm (PDT) . Posted by:
three100mph
I'm having the same problems getting options quotes using smfGetOptionQuotes. The spreadsheet used to work great but lately can no longer get options quotes. Other RCH type functions are still working correctly but options functions are not.
Tue Oct 21, 2014 2:33 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just looked at a Yahoo option quotes page and it appears they've changed
the format of the web page.
Looks like a change to the Yahoo process will be necessary.
On Tue, Oct 21, 2014 at 11:07 AM, bob_15861586@...wrote:
> Today, I have not been able to get any quotes on either call options or
> put options. It was working yesterday. I am using the function smfGetYahooOptionQuote.
> Is Yahoo having problems today?
>
> I am also using Excel 2003. I am wondering if I should go update my
> version of Excel? I using Version 2.1.2012.02.02 of SMF. Is that part of
> the problem? Will the latest version of SMF work with Excel 2003?
>
>
the format of the web page.
Looks like a change to the Yahoo process will be necessary.
On Tue, Oct 21, 2014 at 11:07 AM, bob_15861586@
> Today, I have not been able to get any quotes on either call options or
> put options. It was working yesterday. I am using the function smfGetYahooOptionQu
> Is Yahoo having problems today?
>
> I am also using Excel 2003. I am wondering if I should go update my
> version of Excel? I using Version 2.1.2012.02.
> the problem? Will the latest version of SMF work with Excel 2003?
>
>
Tue Oct 21, 2014 2:14 pm (PDT) . Posted by:
shiraegi
Right, got it, thanks. Which sniffer did you use?
Tue Oct 21, 2014 2:34 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The HTTPFox add-on for FireFox.
On Tue, Oct 21, 2014 at 2:14 PM, shiraegi@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Right, got it, thanks. Which sniffer did you use?
>
On Tue, Oct 21, 2014 at 2:14 PM, shiraegi@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Right, got it, thanks. Which sniffer did you use?
>
Tue Oct 21, 2014 5:18 pm (PDT) . Posted by:
steven_rourk
An Excel related question, not Addin related... sorry, dont know any where else to ask.
So Im trying to set up an Excel sheet where I have a column with the daily closing price of S&P500 for the last 10 years. I want to determine all the market corrections (5% ups and downs from the peaks and the bottoms) with a moving formula. The formula should do the following:
1. validate a 5% or more move from a starting point to validate a trend
2. if for example an upward trend is validated then it has to determine which is the top, as this will be the new starting point to determine a downward trend.
3. With the new starting point validate a 5% move downward to validate the trend, once validated, determine which is the bottom,
4. Calculate the % difference between the top and bottom
5. Etc
Its easy with a chart, you just have to look at the ups and downs, and determine whether there has been a larger than 5% move up or down to validate the trend. But Im having problems determining the right formula to use in Excel in order to do this automatically. Im attaching the spreadsheet. As you can see I started doing it manually (column F and G). You can see I´ve been playing around with different formulas without luck (columns H, I, J and K). Any help of suggestion will be much appreciated.
PD: I cant attach the file...
So Im trying to set up an Excel sheet where I have a column with the daily closing price of S&P500 for the last 10 years. I want to determine all the market corrections (5% ups and downs from the peaks and the bottoms) with a moving formula. The formula should do the following:
1. validate a 5% or more move from a starting point to validate a trend
2. if for example an upward trend is validated then it has to determine which is the top, as this will be the new starting point to determine a downward trend.
3. With the new starting point validate a 5% move downward to validate the trend, once validated, determine which is the bottom,
4. Calculate the % difference between the top and bottom
5. Etc
Its easy with a chart, you just have to look at the ups and downs, and determine whether there has been a larger than 5% move up or down to validate the trend. But Im having problems determining the right formula to use in Excel in order to do this automatically. Im attaching the spreadsheet. As you can see I started doing it manually (column F and G). You can see I´ve been playing around with different formulas without luck (columns H, I, J and K). Any help of suggestion will be much appreciated.
PD: I cant attach the file...
Tue Oct 21, 2014 5:59 pm (PDT) . Posted by:
rharmelink
I've uploaded a new beta version of the add-in to the "Works in Progress" folder on the web site. Several functions needed to be updated because of changes Yahoo made to their option quotes web pages.
I had to remove all of the "xITM" and "xOTM" strike price functionality, although you can replace that with the smfGetOptionStrikes function. I also added their new data field -- implied volatility.
Note that Yahoo is not listing all contracts. I found a number that were missing. It also seemed to vary during the few hours I was making my changes.
Let me know if you run into problems with the function updates.
Date Routine Description 2014-10-21 smfGetYahooOptionQuote
smfGetOptionExpirations
smfGetOptionStrikes Updates for changes in Yahoo's option quotes pages
http://ogres-crypt.com/SMF/Works-In-Progress/ http://ogres-crypt.com/SMF/Works-In-Progress/
I had to remove all of the "xITM" and "xOTM" strike price functionality, although you can replace that with the smfGetOptionStrikes function. I also added their new data field -- implied volatility.
Note that Yahoo is not listing all contracts. I found a number that were missing. It also seemed to vary during the few hours I was making my changes.
Let me know if you run into problems with the function updates.
Date Routine Description 2014-10-21 smfGetYahooOptionQuote
smfGetOptionExpirations
smfGetOptionStrikes Updates for changes in Yahoo's option quotes pages
http://ogres-crypt.com/SMF/Works-In-Progress/ http://ogres-crypt.com/SMF/Works-In-Progress/
Tue Oct 21, 2014 8:49 pm (PDT) . Posted by:
"Jose Jacob" pepecan47
Does anyone know a source for the 10-year Treasury rate?
Regards,
Jose L. Jacob
Regards,
Jose L. Jacob
Tue Oct 21, 2014 9:38 pm (PDT) . Posted by:
"Peter Urbani" purbani1
FRED2 http://research.stlouisfed.org/fred2/series/DGS10
On Wed, Oct 22, 2014 at 4:49 PM, Jose Jacob pepecan47@yahoo.ca [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> Does anyone know a source for the 10-year Treasury rate?
>
> Regards,
> Jose L. Jacob
>
>
>
--
*Peter Urbani*
+64 6 378 0937
[image: View my profile on LinkedIn]LinkedIn Profile
<http://nz.linkedin.com/in/peterurbani>
Skype peterurbani
On Wed, Oct 22, 2014 at 4:49 PM, Jose Jacob pepecan47@yahoo.ca [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> Does anyone know a source for the 10-year Treasury rate?
>
> Regards,
> Jose L. Jacob
>
>
>
--
*Peter Urbani*
+64 6 378 0937
[image: View my profile on LinkedIn]LinkedIn Profile
<http://nz.linkedin.com/in/peterurbani>
Skype peterurbani
Tue Oct 21, 2014 9:45 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You can grab the current rate from Yahoo's Bonds page:
=RCHGetTableCell("http://finance.yahoo.com/bonds",1,">10 Year")
On Tue, Oct 21, 2014 at 8:49 PM, Jose Jacob pepecan47@... wrote:
> Does anyone know a source for the 10-year Treasury rate?
>
=RCHGetTableCell("http://finance.yahoo.com/bonds",1,"
On Tue, Oct 21, 2014 at 8:49 PM, Jose Jacob pepecan47@..
> Does anyone know a source for the 10-year Treasury rate?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar