Messages In This Digest (15 Messages)

1a.: option symbol From: ghlentz2000
1b.: Re: option symbol From: Randy Harmelink

2a.: smfPricesBetween - does not seem to work for 52-week low From: krisha_mehta
2b.: Re: smfPricesBetween - does not seem to work for 52-week low From: Randy Harmelink
2c.: Re: smfPricesBetween - does not seem to work for 52-week low From: krisha_mehta
2d.: Re: smfPricesBetween - does not seem to work for 52-week low From: Randy Harmelink
2e.: Re: smfPricesBetween - does not seem to work for 52-week low From: krisha_mehta

3a.: Problems with smfGETADVFNElement... From: zenodk_2
3b.: Re: Problems with smfGETADVFNElement... From: Randy Harmelink

4a.: MSN 2 Errors? Stock Scouter From: barbiegirl
4b.: Re: MSN 2 Errors? Stock Scouter From: Randy Harmelink

5a.: Re: for us Canadians - any way to pull TSX/TSE specific data from Go From: staspmr
5b.: Re: for us Canadians - any way to pull TSX/TSE specific data from Go From: Randy Harmelink

6a.: WSJ CDS table From: newengwongpeggy
6b.: Re: WSJ CDS table From: Randy Harmelink

View All Topics | Create New Topic

Messages

1a.: option symbol

Posted by: "ghlentz2000" ghlentz2000@yahoo.com ghlentz2000

Wed Nov 23, 2011 7:26 am (PST)

Hi

I can't seemed to get the correct option symbol for spy DEC 4Q. I get an error using =smfGetOptionQuotes(A10,"b",3,"ox")where a10 refers to the symbol.
I've tried spy 12/31 2011, spy Q4 2011 and spy 12/31 2011 with no result.

Thanks

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
1b.: Re: option symbol

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Nov 23, 2011 8:08 am (PST)

Sorry, but it appears none of the add-in option quotes functions will get
the quarter-end quotes -- the add-in functions assign the date to be the
end of the quarter: 12/31/2011. However, the actual options are expiring on
12/30/2011.

I just uploaded a new beta versions of the add-in to the "Works in
Progress" folder:

RCH_Stock_Market_Functions-2.1.2011.11.23.zip

It corrects the quarter-end date if it falls on a Saturday or Sunday. I'm
wondering, though, if this is a change because of the new weekly options,
to make it expire on a Friday to replace the weekly? What is going to
happen if the quarter-end option expires on a Thursday?

On Wed, Nov 23, 2011 at 6:39 AM, ghlentz2000 <ghlentz2000@yahoo.com> wrote:

>
> I can't seemed to get the correct option symbol for spy DEC 4Q. I get an
> error using =smfGetOptionQuotes(A10,"b",3,"ox")where a10 refers to the
> symbol.
> I've tried spy 12/31 2011, spy Q4 2011 and spy 12/31 2011 with no
> result.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

2a.: smfPricesBetween - does not seem to work for 52-week low

Posted by: "krisha_mehta" krisha_mehta@yahoo.com krisha_mehta

Wed Nov 23, 2011 9:36 am (PST)

Hi Randy,

I am again having some issues with the formula..
=smfPricesBetween(A62,NOW()-365, NOW(),"06")
in Excel.

For example, TRI ( used in cell A62) shows the 52-week low = 25.83
or INP shows 52-week low = 48.99

None of them is the correct value. Please advise what's missing.
Thanks!
Maunang

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
2b.: Re: smfPricesBetween - does not seem to work for 52-week low

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Nov 23, 2011 10:25 am (PST)

They look correct to me. Keep in mind that they are based on historical
adjusted quotes. So, right now, you would be seeing the 52-week low AS OF
the yesterday. It cannot include today's values. For the function, the
NOW() value is not today, but yesterday.

Also, note that you are doing 365 days, that may not be equivalent to 52
weeks. They might be doing "rolling" weeks that end at a weekend, typically
Friday.

On Wed, Nov 23, 2011 at 10:36 AM, krisha_mehta <krisha_mehta@yahoo.com>wrote:

>
> I am again having some issues with the formula..
> =smfPricesBetween(A62,NOW()-365, NOW(),"06")
> in Excel.
>
> For example, TRI ( used in cell A62) shows the 52-week low = 25.83
> or INP shows 52-week low = 48.99
>
> None of them is the correct value. Please advise what's missing.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
2c.: Re: smfPricesBetween - does not seem to work for 52-week low

Posted by: "krisha_mehta" krisha_mehta@yahoo.com krisha_mehta

Wed Nov 23, 2011 11:56 am (PST)

Maybe I am not using this right. For example, when I look at interactive graph on Yahoo Finance the price lower/close to current was sometime in
July 13, 2009 and not within last 365 days.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> They look correct to me. Keep in mind that they are based on historical
> adjusted quotes. So, right now, you would be seeing the 52-week low AS OF
> the yesterday. It cannot include today's values. For the function, the
> NOW() value is not today, but yesterday.
>
> Also, note that you are doing 365 days, that may not be equivalent to 52
> weeks. They might be doing "rolling" weeks that end at a weekend, typically
> Friday.
>
> On Wed, Nov 23, 2011 at 10:36 AM, krisha_mehta <krisha_mehta@...>wrote:
>
> >
> > I am again having some issues with the formula..
> > =smfPricesBetween(A62,NOW()-365, NOW(),"06")
> > in Excel.
> >
> > For example, TRI ( used in cell A62) shows the 52-week low = 25.83
> > or INP shows 52-week low = 48.99
> >
> > None of them is the correct value. Please advise what's missing.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
2d.: Re: smfPricesBetween - does not seem to work for 52-week low

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Nov 23, 2011 12:20 pm (PST)

The previous low for TRI was hit on Oct 4, 2011.

http://finance.yahoo.com/q/bc?s=TRI&t=3m&l=on&z=l&q=c&c=

On Wed, Nov 23, 2011 at 12:56 PM, krisha_mehta <krisha_mehta@yahoo.com>wrote:

> Maybe I am not using this right. For example, when I look at interactive
> graph on Yahoo Finance the price lower/close to current was sometime in
> July 13, 2009 and not within last 365 days.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
2e.: Re: smfPricesBetween - does not seem to work for 52-week low

Posted by: "krisha_mehta" krisha_mehta@yahoo.com krisha_mehta

Wed Nov 23, 2011 5:56 pm (PST)

Sorry Randy for not being very clear.

Let me take an example for INP, the current price is about 49.38. If you check Yahoo graphs, I don't see anything lower than 49.38 in past 365 days - the lowest is 53.35, Sept 22 2011. Yet, the formula shows the 365 day low as 48.99.

Also, can you please explain how can I extract the date for which it shows 48.99 using smfPricesBetween.

Thanks in advance for your insight.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The previous low for TRI was hit on Oct 4, 2011.
>
> http://finance.yahoo.com/q/bc?s=TRI&t=3m&l=on&z=l&q=c&c=
>
> On Wed, Nov 23, 2011 at 12:56 PM, krisha_mehta <krisha_mehta@...>wrote:
>
> > Maybe I am not using this right. For example, when I look at interactive
> > graph on Yahoo Finance the price lower/close to current was sometime in
> > July 13, 2009 and not within last 365 days.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

3a.: Problems with smfGETADVFNElement...

Posted by: "zenodk_2" madsdsl@gmail.com zenodk_2

Wed Nov 23, 2011 10:02 am (PST)

Hey,

I have used a spreadsheet for months where I rely heavily on the use of smfGETADVFNElement...

Then all of a sudden yesterday, the spreadsheet didn't return anything on that command anymore. All my smfGETADVFNElement returns "Error". How could that be? I haven't changed anything in the spreadsheet at all.

An example of my syntax:
=smfGetADVFNElement(B186,"A",$U$1,">Total Revenue<")

All other functions in the spreadsheet works. For example =RCHGetYahooQuotes("DV","r")... but for smfGETADVFNElement, I only get "error"....

Any advice would be very much appreciated..

Thanks,

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3b.: Re: Problems with smfGETADVFNElement...

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Nov 23, 2011 11:16 am (PST)

I just tried your example function with ticker symbols DV and MMM and both
worked fine here.

As a possible solution/problem, check out the AdvFN item in the "Links"
area of the group...

On Wed, Nov 23, 2011 at 11:02 AM, zenodk_2 <madsdsl@gmail.com> wrote:

>
> I have used a spreadsheet for months where I rely heavily on the use of
> smfGETADVFNElement...
>
> Then all of a sudden yesterday, the spreadsheet didn't return anything on
> that command anymore. All my smfGETADVFNElement returns "Error". How could
> that be? I haven't changed anything in the spreadsheet at all.
>
> An example of my syntax:
> =smfGetADVFNElement(B186,"A",$U$1,">Total Revenue<")
>
> All other functions in the spreadsheet works. For example
> =RCHGetYahooQuotes("DV","r")... but for smfGETADVFNElement, I only get
> "error"....
>
> Any advice would be very much appreciated..
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

4a.: MSN 2 Errors? Stock Scouter

Posted by: "barbiegirl" pgh2377@yahoo.com pgh2377

Wed Nov 23, 2011 11:20 am (PST)

Is anyone else having problems retrieving the stock scouter ratings on MSN 2? I cannot get any ratings and I believe it is because they changed their layout.

Any input is greatly appreciated.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4b.: Re: MSN 2 Errors? Stock Scouter

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Nov 23, 2011 11:31 am (PST)

Element #543 is working for me right now, with ticker MMM. The other
StockScouter items are no longer available.

Are you using the new MSN element definitions from the "Works in Progress"
folder? I had to redefine and obsolete a number of elements earlier this
year because of the MSN redesign.

2011-01-26 RCHGetElementNumber Updated the element definitions in file
smf-elements-1.txt because MSN made changes to their web pages.
-- Too many were changed to mention them all.
-- Elements #2, #541-542, #544-546, and #551-552 were obsoleted.
On Wed, Nov 23, 2011 at 12:20 PM, barbiegirl <pgh2377@yahoo.com> wrote:

> Is anyone else having problems retrieving the stock scouter ratings on MSN
> 2? I cannot get any ratings and I believe it is because they changed their
> layout.
>
> Any input is greatly appreciated.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

5a.: Re: for us Canadians - any way to pull TSX/TSE specific data from Go

Posted by: "staspmr" staspmr@yahoo.ca staspmr

Wed Nov 23, 2011 3:27 pm (PST)

strange, I tried exactly that, and even copied your exact formula, and it still gives me an error.

I am located in Toronto, don't think that should be a problem. Come to think of it, it doesn't even work for us stocks, e.g. ibm

What version of the tools are you using? i just updated again to the 2.1.2011.11.23 version, and still same problem....

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The AdvFN element definitions don't use the "ca" prefix on the URL items.
> However, this does work for me:
>
> =RCHGetElementNumber("tse:rim", 5716)
>
> ...but I have seen reports that AdvFN does some "default country"
> processing based on the location of your IP address, so what works for me
> may not work for you? I don't know all the details, since I don't run into
> the problem.
>
> On Tue, Nov 22, 2011 at 8:21 PM, staspmr <staspmr@...> wrote:
>
> > I have no trouble with msn, just add ".to" at the end. You can use "&" in
> > excel to add it automatically.
> >
> > However, I do have trouble with ADVfn, I tried every format imaginable,
> > including tse:, tsx:, .to, -t, etc
> >
> > e.g.
> >
> > http://ca.advfn.com/p.php?pid=cafinancials&btn=annual_reports&mode=&symbol=TSE%3ARIM
> >
> > =RCHGetElementNumber("rim.to", 5716) Annual Income Statement -- Basic
> > EPS -- Continuing -- FY1
> >
> > returns error for every permutation of the ticker label
> >
> > any solutions?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
5b.: Re: for us Canadians - any way to pull TSX/TSE specific data from Go

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Nov 23, 2011 6:18 pm (PST)

Take a look at the "Links" area of the group. There is an AdvFN link there
about a Windows Update that stops AdvFN from working. But you can change
your Internet settings. Hopefully, that's the issue?

The 2.1.2011.11.23 is an exact copy of what I am using right now. I just
uploaded it this morning with all of my updated files, because of an issue
with quarter-end options retrieval that I fixed.

On Wed, Nov 23, 2011 at 4:27 PM, staspmr <staspmr@yahoo.ca> wrote:

> strange, I tried exactly that, and even copied your exact formula, and it
> still gives me an error.
>
> I am located in Toronto, don't think that should be a problem. Come to
> think of it, it doesn't even work for us stocks, e.g. ibm
>
> What version of the tools are you using? i just updated again to the
> 2.1.2011.11.23 version, and still same problem....
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)

6a.: WSJ CDS table

Posted by: "newengwongpeggy" tong82@gmail.com newengwongpeggy

Wed Nov 23, 2011 7:59 pm (PST)

hi Randy,

I was trying to use rchgettablecell to extract data from

http://online.wsj.com/mdc/public/npage/2_3023_creditdervs.html?mod=topnav_2_3021

but it does not work.

Strangely it works on other tables from the same website.

any solution would be helpful.

thx
Ant

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
6b.: Re: WSJ CDS table

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Nov 23, 2011 8:12 pm (PST)

That's because the tables aren't on that web page -- they're displayed
within frames on the web page. So you need to use the URL of the framed
page. But given the nature of the URL, I'm not sure how reliable it is. For
example, this works for me right now:

=RCHGetTableCell("
https://web.apps.markit.com/WMXAXLP?YYY2220_zJkhPN/sWPxwhzYw8K4DcqW07HfIQykbYMaXf8fTzWS1bwnxizPcTzQDeraXnfSx",1,"Markit
CDX North America Investment Grade")

...but I'm not sure if it will tomorrow. If not, an alternative would be to
extract the frame URL from the web page itself, and then use those in the
RCHGetTableCell() formulas.

Hmmm. Even now, I'm getting a different frame URL. This appears to extract
the frame URL from the main web page:

=smfStrExtr(RCHGetWebData("
http://online.wsj.com/mdc/public/npage/2_3023_creditdervs.html?mod=topnav_2_3021","<iframe
src=",200),"""","""")

On Wed, Nov 23, 2011 at 8:59 PM, newengwongpeggy <tong82@gmail.com> wrote:

>
> I was trying to use rchgettablecell to extract data from
>
>
> http://online.wsj.com/mdc/public/npage/2_3023_creditdervs.html?mod=topnav_2_3021
>
> but it does not work.
>
> Strangely it works on other tables from the same website.
>
> any solution would be helpful.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

Create New Topic | Visit Your Group on the Web

Messages | Files | Photos | Polls

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

Kamis, 24 November 2011

Messages In This Digest (15 Messages)

Messages

Posted by: "ghlentz2000" ghlentz2000@yahoo.com ghlentz2000

Wed Nov 23, 2011 7:26 am (PST)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Nov 23, 2011 8:08 am (PST)

Posted by: "krisha_mehta" krisha_mehta@yahoo.com krisha_mehta

Wed Nov 23, 2011 9:36 am (PST)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Nov 23, 2011 10:25 am (PST)

Posted by: "krisha_mehta" krisha_mehta@yahoo.com krisha_mehta

Wed Nov 23, 2011 11:56 am (PST)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Nov 23, 2011 12:20 pm (PST)

Posted by: "krisha_mehta" krisha_mehta@yahoo.com krisha_mehta

Wed Nov 23, 2011 5:56 pm (PST)

Posted by: "zenodk_2" madsdsl@gmail.com zenodk_2

Wed Nov 23, 2011 10:02 am (PST)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Nov 23, 2011 11:16 am (PST)

Posted by: "barbiegirl" pgh2377@yahoo.com pgh2377

Wed Nov 23, 2011 11:20 am (PST)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Nov 23, 2011 11:31 am (PST)

Posted by: "staspmr" staspmr@yahoo.ca staspmr

Wed Nov 23, 2011 3:27 pm (PST)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Nov 23, 2011 6:18 pm (PST)

Posted by: "newengwongpeggy" tong82@gmail.com newengwongpeggy

Wed Nov 23, 2011 7:59 pm (PST)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Nov 23, 2011 8:12 pm (PST)

Tidak ada komentar:

Posting Komentar

Followers

Blog Archive

About Me