Sabtu, 28 April 2012

[smf_addin] Digest Number 2191

Messages In This Digest (10 Messages)

Messages

1a.

Re: MSN elements not working anymore

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

Fri Apr 27, 2012 8:30 am (PDT)



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@gmail.com> 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 (12)
1b.

Re: MSN elements not working anymore

Posted by: "Mark" ballard@bankchampaign.com   mballard34a

Fri Apr 27, 2012 11:00 pm (PDT)



Hi Randy,

Element 1 also seems to still be not working.

Thanks for all the time you put into this!

Mark

--- In smf_addin@yahoogroups.com, "codyklein" <codyklein@...> wrote:
>
> Hi Randy, element number 13862 (company name) still does not appear to be working in the updated smf-elements-1 file
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > Thanks for the heads up.
> >
> > Doing a "Find and Replace All" on the definitions file from:
> >
> > http://moneycentral.msn.com/investor/research/sreport.asp?
> >
> > ...to:
> >
> > http://investing.money.msn.com/investments/stock-report?
> >
> > ...appears to fix most of the errors, but I still have a number of elements
> > still coming up error. They may have changed the content or layout of the
> > page for those elements, or obsoleted them altogether.
> >
> > I won't release a new definitions file until more of the errors are gone.
> >
> > This is the fourth time in three years that MSN has changed the URLs of
> > their website.
> >
> > On Thu, Apr 26, 2012 at 7:18 PM, 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 (12)
1c.

Re: MSN elements not working anymore

Posted by: "Matt" mattschofield@xtra.co.nz   mattschofield@xtra.co.nz

Sat Apr 28, 2012 12:02 am (PDT)




I can get the company name definition to work with the new file, but the description (i.e. element 1), returns:

Financial data in <span> USD</span> <br /> Values in Millions (Except for per share items)

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

Re: MSN elements not working anymore

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

Sat Apr 28, 2012 12:09 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 (12)
1e.

Re: MSN elements not working anymore

Posted by: "invesco88" franklin.forward@gmail.com   invesco88

Sat Apr 28, 2012 12:09 am (PDT)



Can anyone get the Cash Flow Model 17S working? I get errors throughout the entire workbook. It wont even pull up the latest price. Any ideas on how to fix this? Thanks.

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

MSN URL Change

Posted by: "Douglas" jurisdoctor74@yahoo.com   jurisdoctor74

Fri Apr 27, 2012 10:47 pm (PDT)



I can understand why changing the MSN URL would immediate invalidate the MSN elements and the fix is clearly straightforward. However, I noticed that the instant the MSN elements were changed, most of my calculated data elements immediately stopped working (with very few exceptions).

I should mention that I did add a number of my own calculated elements but that, except for one or two exceptions, they do not directly reference the MSN elements. So why would the MSN issue affect the (apparently) unrelated calculated elements?

If anyone knows the answer, I would appreciate your feedback.

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

Re: MSN URL Change

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

Sat Apr 28, 2012 12:25 am (PDT)



I can't think of a reason why they would stop working...

And, the fix was not all that straightforward. Although many element
definitions were fixed with the URL change, I still had at least 60 other
elements that needed custom changes. And I suspect there will be more. I
pretty much just fixed everything I could see on the templates, so I could
get a quick update out there for the majority of the data elements.

On Fri, Apr 27, 2012 at 12:17 PM, Douglas <jurisdoctor74@yahoo.com> wrote:

> I can understand why changing the MSN URL would immediate invalidate the
> MSN elements and the fix is clearly straightforward. However, I noticed
> that the instant the MSN elements were changed, most of my calculated data
> elements immediately stopped working (with very few exceptions).
>
> I should mention that I did add a number of my own calculated elements but
> that, except for one or two exceptions, they do not directly reference the
> MSN elements. So why would the MSN issue affect the (apparently) unrelated
> calculated elements?
>
> If anyone knows the answer, I would appreciate your feedback.
>
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3a.

Quick way to download Open/High/Low/Close prices from Yahoo for 2000

Posted by: "peter_sagg" boropeter@hotmail.com   peter_sagg

Fri Apr 27, 2012 10:49 pm (PDT)



Randy, thank you very much for these wonderful add-ins of yours. I would like to find a quick way of downloading Open/High/Low/Close from Yahoo!Finance after the close for the day. Usually this data is only available after around 7:30pm under Historical results. One solution is to use RCHGetYahooQuotes at say 4:15pm when the majority of stocks already closed. However, in that instance Excel will be grabbing any after-market activity as well in the downloaded last price. I obviously don't want that to happen, since im purely interested in receiving the official closing price. Another option would be to use RCHGetYahooQuotes for Open/High/Low at 4:15 pm and retrieve official closing prices using your other add-in.

Understanding that 2000 stocks is a lot of data, i intentionally used the word "quick" while asking you: in my understanding 20mins for this particular operation would be quick.

Thank you :)

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

Re: Quick way to download Open/High/Low/Close prices from Yahoo for

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

Sat Apr 28, 2012 12:28 am (PDT)



Are you sure that RCHGetYahooQuotes() returns after-market activity? I've
never seen that. But I don't specifically grab any EOD quotes either.

I don't think prices from RCHGetYahooHistory() include pre-market and
after-market activity either.

With RCHGetYahooQuotes(), 2000 stocks shouldn't take too long -- all the
data can be gotten in 10 function invocations. I would think it would take
10-15 seconds at most.

On Fri, Apr 27, 2012 at 1:02 PM, peter_sagg <boropeter@hotmail.com> wrote:

> Randy, thank you very much for these wonderful add-ins of yours. I would
> like to find a quick way of downloading Open/High/Low/Close from
> Yahoo!Finance after the close for the day. Usually this data is only
> available after around 7:30pm under Historical results. One solution is to
> use RCHGetYahooQuotes at say 4:15pm when the majority of stocks already
> closed. However, in that instance Excel will be grabbing any after-market
> activity as well in the downloaded last price. I obviously don't want that
> to happen, since im purely interested in receiving the official closing
> price. Another option would be to use RCHGetYahooQuotes for Open/High/Low
> at 4:15 pm and retrieve official closing prices using your other add-in.
>
> Understanding that 2000 stocks is a lot of data, i intentionally used the
> word "quick" while asking you: in my understanding 20mins for this
> particular operation would be quick.
>
> Thank you :)
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4.1.

Re: smfGetAdvFNElement

Posted by: "Patrick Van Beesen" patrick.van.beesen@perso.be   patrickvb

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



Try this.
uk in place of WWW, it works with fr
sAdvFNPrefix = "uk"

On 27/04/2012 10:56, gusto.duel wrote:
>
> I have tried the OLDSCHOOLVALUE fix by adding uk before www:
>
> Sub LoadAdvFNPrefix()
> sAdvFNPrefix = "uk.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
>
> Still it works not.
>
> FOr instance B3 in Template All Line Items:
>
> =IF(UPPER($B$2)="NONE","--",smfGetADVFNElement($B$2,$B$3,999))
> delivers "Error".
>
> Everything other cell delivers #NAME and I see no formulas in them
> (but #NAME)
>
> --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>,
> "gusto.duel" <gusto.duel@...> wrote:
> >
> > Dear Randy,
> >
> > I was wondering if the Templates illustrating smfGetAdvFNElement
> should work? They do not on my computer.
> >
> > I get #NAME? all over the place.
> > I use Excel 2010 and the formula in B3 (ie)(Template All Line Items) is:
> >
> > =IF(UPPER($B$2)="NONE","--",'C:\Program Files\SMF
> Add-in\RCH_Stock_Market_Functions.xla'!smfGetADVFNElement($B$2,$B$3,999))
> >
> > The ADD In is installed in "C:\Program Files\SMF Add-in".
> >
> > I would appreciate any assistance.
> >
> > Best regards,
> >
> > Gusto
> >
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (40)
Recent Activity
Visit Your Group
Search Ads

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Fashion News

What's the word on

fashion and style?

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
Diposting oleh EXCEL FEED LEARNING di 01.03

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)