Messages In This Digest (16 Messages)

1a.: Re: MSN elements not working anymore From: chris.landqvist
1b.: Re: MSN elements not working anymore From: Randy Harmelink
1c.: Re: MSN elements not working anymore From: investor952

2a.: Re: pSort problem From: nk1165
2b.: Re: pSort problem From: Randy Harmelink

3.1.: Re: smfGetAdvFNElement From: chrispycrunch
3.2.: Re: smfGetAdvFNElement From: Randy Harmelink
3.3.: Re: smfGetAdvFNElement From: Kermit W. Prather

4a.: smf-elements-1.txt From: Laurance Hill
4b.: Re: smf-elements-1.txt From: Randy Harmelink

5a.: HISTORY - MULTIPLE SYMBOLS From: grabthecashanddash
5b.: Re: HISTORY - MULTIPLE SYMBOLS From: Randy Harmelink

6.: Yahoo element 1285 not working - Next Earnings Date From: MikeM

7a.: RCHGetElementNumber(Ticker, 63) (5 yr dividend growth)..not working From: investor952
7b.: Re: RCHGetElementNumber(Ticker, 63) (5 yr dividend growth)..not work From: investor952
7c.: Re: RCHGetElementNumber(Ticker, 63) (5 yr dividend growth)..not work From: Randy Harmelink

View All Topics | Create New Topic

Messages

1a.: Re: MSN elements not working anymore

Posted by: "chris.landqvist" chris.landqvist@yahoo.com chris.landqvist

Sat Apr 28, 2012 1:59 am (PDT)

Hi Randy (and all others),

when I try to get the company information in: RCHGetElementNumber(IBM,1)

It returns something really weird in the box when I usually display this information. Am I the only one with this issue??

Thanks for all the great service//Chris

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> In the "Works in Progress" folder of the files area. There should have been
> two announcements this morning that the file was uploaded...
>
> On Fri, Apr 27, 2012 at 8:06 AM, Lawrence <lawrence.leesh@...> wrote:
>
> >
> > Where can I find this fix?
> >
> > --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> > >
> > > Just uploaded a new copy with a fix for that element...
> > >
> > > On Fri, Apr 27, 2012 at 6:46 AM, codyklein <codyklein@>wrote:
> > >
> > > > Hi Randy, element number 13862 (company name) still does not appear to
> > be
> > > > working in the updated smf-elements-1 file
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (14)
1b.: Re: MSN elements not working anymore

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

Sat Apr 28, 2012 4:22 am (PDT)

Thanks for the heads up!

The fix for element #1 will be in the next upload of the element
definitions file.

(...not real fond of MSN at the moment...)

On Fri, Apr 27, 2012 at 12:44 PM, Mark <ballard@bankchampaign.com> wrote:

>
> Element 1 also seems to still be not working.
>
> Thanks for all the time you put into this!
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (14)
1c.: Re: MSN elements not working anymore

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

Sat Apr 28, 2012 8:07 pm (PDT)

I just tried one of my spreadsheets with this function and item 64 (5 year dividend growth) is returning a blank.

How do I fix this? Thanks.

--- In smf_addin@yahoogroups.com, "MikeM" <mikemcq802@...> wrote:
>
> It seems MSN may have reconfigured their site. The element numbers 25 and 46 are not working for any ticker (the only two I tried). If I type the url from the smf-elements-txt file it shows a web page for creating a report but you must select the items you want.
>
> This is the version I am using:
> Stock Market Functions add-in, Version 2.1.2012.02.17
>
> This is a sample retrieval that is not working (gets "error").
> =RCHGetElementNumber("VFC",25,,)
>
> Here's the url from the elements file:
> http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=VFC
>
> Interestingly, this page shows info:
> http://investing.money.msn.com/investments/stock-price?Symbol=vfc&ocid=qbeb
>
> I tried the beta version 2012.04.07 too but that gave same results.
>

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

2a.: Re: pSort problem

Posted by: "nk1165" nkemp1165@hotmail.com nk1165

Sat Apr 28, 2012 3:53 am (PDT)

The trouble with the RCHGetYahooHistory Dividend default sorting is that it is newest to oldest (descending). In order to use Excel VLookup the data must be sorted oldest to newest (ascending).

Enabling the sorting function for RCHGetYahooHistory would be great

Nick

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Not you. Resorting is specifically ignored for the dividends option -- I
> don't recall why I did that.
>
> On Sat, Dec 31, 2011 at 3:02 PM, Pete A <optionzz@...> wrote:
>
> > Using values of 0 or 1 for pSort: doesn't seem to have any effect; the
> > date order remains Newest to Oldest. I've inserted a sort routine after
> > updating the data, but thought I'd ask if I'm just doing something wrong.
> >
> > Range(oCell.Offset(16, -1), oCell.Offset(iObservations + 15, 0)) = _
> > RCHGetYahooHistory(oCell.Value2, pResort:=1, pPeriod:="v",
> > pDim1:=iObservations, pDim2:=2)
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
2b.: Re: pSort problem

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

Sat Apr 28, 2012 6:31 am (PDT)

You could just use a MATCH() and INDEX() function to replicate the VLOOKUP.
MATCH() will allow the search to be done as ascending or descending. Or the
MATCH() results could be offset in the INDEX() function.

I sometimes use MATCH()/INDEX() because it gives me a lot more flexibility
than VLOOKUP(). And it doesn't break if you insert a column in your table.
And it's more straightforward if you want to return data from a column to
the left of your lookup column.

On Fri, Apr 27, 2012 at 8:43 AM, nk1165 <nkemp1165@hotmail.com> wrote:

> The trouble with the RCHGetYahooHistory Dividend default sorting is that
> it is newest to oldest (descending). In order to use Excel VLookup the
> data must be sorted oldest to newest (ascending).
>
> Enabling the sorting function for RCHGetYahooHistory would be great
>

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

3.1.: Re: smfGetAdvFNElement

Posted by: "chrispycrunch" cgl888@hotmail.com chrispycrunch

Sat Apr 28, 2012 6:40 am (PDT)

Unrelated question for this add-on. How do you make the VBA compatible for excel 64? The system keeps prompting me to add PTRSafe around the code to make it x64 compatible.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> What do you get for:
>
> =RCHGetElementNumber("Version")
> =RCHGetTableCell("
> http://uk.advfn.com/p.php?pid=financials&symbol=KO&mode=annual_reports&start_date=0",
> 1, "year end date")
>
> On Fri, Apr 27, 2012 at 3:35 AM, gusto.duel <gusto.duel@...> wrote:
>
> >
> > I followed instructions (created smf-AdvFN-Prefix.txt, fixed the #NAME)
> > and made more progress.
> >
> > Still:
> >
> > - it retrieves no data for any symbol but sees the B2 value as "NONE" and
> > returns "--" except Column C where I see text values
> > - in B4 it displays "FALSE".
> >
> > I reverted the VBA to original:
> >
> > Sub LoadAdvFNPrefix()
> > sAdvFNPrefix = "www"
> > On Error GoTo ErrorExit
> > Open ThisWorkbook.Path & "\smf-AdvFN-Prefix.txt" For Input As #1
> > Line Input #1, sAdvFNPrefix
> > Close #1
> > ErrorExit:
> > End Sub
> >
> > Below is the link I get for KO's financial statement on ADVFN site:
> >
> >
> > http://uk.advfn.com/p.php?pid=financials&btn=annual_reports&mode=&symbol=NYSE%3AKO
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (43)
3.2.: Re: smfGetAdvFNElement

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

Sat Apr 28, 2012 6:41 am (PDT)

Not a clue here. Anyone else?

On Sat, Apr 28, 2012 at 6:35 AM, chrispycrunch <cgl888@hotmail.com> wrote:

> Unrelated question for this add-on. How do you make the VBA compatible for
> excel 64? The system keeps prompting me to add PTRSafe around the code to
> make it x64 compatible.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (43)
3.3.: Re: smfGetAdvFNElement

Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com kermitpra

Sat Apr 28, 2012 9:50 am (PDT)

I'm running the SMF addin on vista 64 bit and win7 64 bit with no problems.

I did nothing to enable the addin or VBA.

I know this isn't an answer but at least you know it does run okay.

Kermit

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Saturday, April 28, 2012 9:41 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: smfGetAdvFNElement

Not a clue here. Anyone else?
On Sat, Apr 28, 2012 at 6:35 AM, chrispycrunch <cgl888@hotmail.com> wrote:
Unrelated question for this add-on. How do you make the VBA compatible for excel 64? The system keeps prompting me to add PTRSafe around the code to make it x64 compatible.

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

4a.: smf-elements-1.txt

Posted by: "Laurance Hill" lohill@cox.net laurancehill

Sat Apr 28, 2012 7:56 am (PDT)

Randy,

Today I started having errors with RCHgetElementNumber for 25 and 46 which are part of a spreadsheet I have used for quite a while. I looked through my email messages and spotted that you have made recent changes to smf-elements-1.text to fix errors caused by changes at MSN. I put that file in my smf_addin folder while saving the original. I tested with a few symbols and believe that the addin is now giving me results but I think they are yesterday's prices as opposed to today's prices.

Some examples:
RCGgetElementNumber("AAPL",25) right now returns 607.70 when the number should be 603.00
RCGgetElementNumber("TGT",25) right now returns 57.49 when the number should be 58.26
RCGgetElementNumber("BP",25) right now returns 43.29 when the number should be43.53
RCGgetElementNumber("UTX",25) right now returns 81.25 when the number should be 82.00

I'm not sure what I may have done wrong unless it is at MSN's end.

Larry

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4b.: Re: smf-elements-1.txt

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

Sat Apr 28, 2012 8:31 am (PDT)

It's an MSN problem. If I go to the AAPL print report right now, that page
reports "Last Price" as $607.70.

But it is actually the previous close.

On Sat, Apr 28, 2012 at 7:56 AM, Laurance Hill <lohill@cox.net> wrote:

>
> Today I started having errors with RCHgetElementNumber for 25 and 46 which
> are part of a spreadsheet I have used for quite a while. I looked through
> my email messages and spotted that you have made recent changes to
> smf-elements-1.text to fix errors caused by changes at MSN. I put that
> file in my smf_addin folder while saving the original. I tested with a few
> symbols and believe that the addin is now giving me results but I think
> they are yesterday's prices as opposed to today's prices.
>
> Some examples:
> RCGgetElementNumber("AAPL",25) right now returns 607.70 when the number
> should be 603.00
> RCGgetElementNumber("TGT",25) right now returns 57.49 when the number
> should be 58.26
> RCGgetElementNumber("BP",25) right now returns 43.29 when the number
> should be43.53
> RCGgetElementNumber("UTX",25) right now returns 81.25 when the number
> should be 82.00
>
> I'm not sure what I may have done wrong unless it is at MSN's end.
>

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

5a.: HISTORY - MULTIPLE SYMBOLS

Posted by: "grabthecashanddash" drjay001@gmail.com grabthecashanddash

Sat Apr 28, 2012 9:08 am (PDT)

I've downloaded & ru Files > Templates and Examples > RCHGetYahooHistory. Works fine; thanx!

I'd like to run this for multiple symbols, each with the same dates & items.
What does Names, adjust & resort refer to?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
5b.: Re: HISTORY - MULTIPLE SYMBOLS

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

Sat Apr 28, 2012 9:16 am (PDT)

Check the function documentation (in the "Documentation" folder of the
files area).

On Sat, Apr 28, 2012 at 9:08 AM, grabthecashanddash <drjay001@gmail.com>wrote:

> I've downloaded & ru Files > Templates and Examples > RCHGetYahooHistory.
> Works fine; thanx!
>
> I'd like to run this for multiple symbols, each with the same dates &
> items.
> What does Names, adjust & resort refer to?
>

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

6.: Yahoo element 1285 not working - Next Earnings Date

Posted by: "MikeM" mikemcq802@yahoo.com mikemcq802

Sat Apr 28, 2012 6:52 pm (PDT)

Randy, element 1285 doesn't seem to work anymore. I think Yahoo relocated that item. It now appears on their Summary page rather than the one you reference in the definitions txt file.

Example, see the Next Earnings Date info here:
http://finance.yahoo.com/q?s=SPLS

txt file has:
http://finance.yahoo.com/q/ae?s=~~~~~

Given how often Yahoo fiddles with this summary page I decided to create a retrieval from wsj instead. In case anyone is interested:

smfGetTagContent("http://quotes.wsj.com/"&B3&"/financials","span",1,">Next Earnings Report")

Where B3 is the cell containing the ticker (upper or lower case both seem to work OK).

An advantage of WSJ is they also have the last earnings date - just change Next to Last in the formula shown.

I have a subscription to WSJ but I believe this quote info is free.

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

7a.: RCHGetElementNumber(Ticker, 63) (5 yr dividend growth)..not working

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

Sat Apr 28, 2012 7:47 pm (PDT)

I just tried to execute a spreadsheet that has this equation which identifies the 5 year dividend growth, and for each ticker, I get a blank. Is anyone else having this problem? Anyone know the cause of this and if/when it will be fixed? Thanks.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
7b.: Re: RCHGetElementNumber(Ticker, 63) (5 yr dividend growth)..not work

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

Sat Apr 28, 2012 8:56 pm (PDT)

--- In smf_addin@yahoogroups.com, "investor952" <investor952@...> wrote:
>
> I just tried to execute a spreadsheet that has this equation which identifies the 5 year dividend growth, and for each ticker, I get a blank. Is anyone else having this problem? Anyone know the cause of this and if/when it will be fixed? Thanks.
>
Looks like I just fixed this problem by downloading your updated file in your works in progress folder..didn't think to look there at first.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
7c.: Re: RCHGetElementNumber(Ticker, 63) (5 yr dividend growth)..not work

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

Sat Apr 28, 2012 11:08 pm (PDT)

You must have missed all the messages on the group about MSN web site
changes...

After exiting EXCEL, replace the new smf-elements-1.txt file in your SMF
add-in folder on your machine with the one from the "Works in Progress"
folder of the Yahoo group.

On Sat, Apr 28, 2012 at 8:07 PM, investor952 <investor952@yahoo.com> wrote:

> I just tried one of my spreadsheets with this function and item 64 (5 year
> dividend growth) is returning a blank.
>
> How do I fix this? Thanks.
>

On Sat, Apr 28, 2012 at 7:47 PM, investor952 <investor952@yahoo.com> wrote:

> I just tried to execute a spreadsheet that has this equation which
> identifies the 5 year dividend growth, and for each ticker, I get a blank.
> Is anyone else having this problem? Anyone know the cause of this and
> if/when it will be fixed? Thanks.
>

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

Create New Topic | Visit Your Group on the Web

Messages | Files | Photos | Polls

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

Minggu, 29 April 2012

Messages In This Digest (16 Messages)

Messages

Posted by: "chris.landqvist" chris.landqvist@yahoo.com chris.landqvist

Sat Apr 28, 2012 1:59 am (PDT)

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

Sat Apr 28, 2012 4:22 am (PDT)

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

Sat Apr 28, 2012 8:07 pm (PDT)

Posted by: "nk1165" nkemp1165@hotmail.com nk1165

Sat Apr 28, 2012 3:53 am (PDT)

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

Sat Apr 28, 2012 6:31 am (PDT)

Posted by: "chrispycrunch" cgl888@hotmail.com chrispycrunch

Sat Apr 28, 2012 6:40 am (PDT)

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

Sat Apr 28, 2012 6:41 am (PDT)

Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com kermitpra

Sat Apr 28, 2012 9:50 am (PDT)

Posted by: "Laurance Hill" lohill@cox.net laurancehill

Sat Apr 28, 2012 7:56 am (PDT)

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

Sat Apr 28, 2012 8:31 am (PDT)

Posted by: "grabthecashanddash" drjay001@gmail.com grabthecashanddash

Sat Apr 28, 2012 9:08 am (PDT)

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

Sat Apr 28, 2012 9:16 am (PDT)

Posted by: "MikeM" mikemcq802@yahoo.com mikemcq802

Sat Apr 28, 2012 6:52 pm (PDT)

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

Sat Apr 28, 2012 7:47 pm (PDT)

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

Sat Apr 28, 2012 8:56 pm (PDT)

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

Sat Apr 28, 2012 11:08 pm (PDT)

Tidak ada komentar:

Posting Komentar

Followers

Blog Archive

About Me