Selasa, 21 Oktober 2014

[smf_addin] Digest Number 3215

15 Messages

Digest #3215
1a
Re: RCHGetElementNumber (1,33,34) by "Kermit W. Prather" kermitpra
2a
Re: Stock Screener Template by "Kermit W. Prather" kermitpra
4.1
Option Quotes by bob_15861586
4.2
Re: Option Quotes by "Marco Deen" marco.deen
4.3
Re: Option Quotes by three100mph
4.4
Re: Option Quotes by "Randy Harmelink" rharmelink
5b
Re: Google stock screener - get the tickers? by "Randy Harmelink" rharmelink
8a
10-year Treasury rate by "Jose Jacob" pepecan47
8b
Re: 10-year Treasury rate by "Peter Urbani" purbani1
8c
Re: 10-year Treasury rate by "Randy Harmelink" rharmelink

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?


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.


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

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 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


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
>
>
>
>

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?
>
>

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?
>

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...

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/

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

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

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?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar