Selasa, 20 September 2011

[smf_addin] Digest Number 1960

Messages In This Digest (6 Messages)

Messages

1a.

Re: RCHGetWebData-Template-Reuters-Key-Developments.xls

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

Mon Sep 19, 2011 4:54 am (PDT)



Oh well, I guess all good things must come to an end. They do make it difficult to extract a company's news. The best that I can do so far is use the following formula: "=smfGetTagContent("http://www.reuters.com/finance/stocks/companyNews?symbol="&$C$1,"a",$C27,"feature","companynews")

where $c$1 = ticker,
"a" = news headline; change to "d" for corresponding details
$c27 = news story number i.e.1, 2, 3 etc.

Thanks for looking into this.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> It was never designed for the news. It looks like it would be a non-trivial
> extraction, because of added links they have for the news stories.
>
> On Sun, Sep 18, 2011 at 7:03 AM, <bushpilote@...> wrote:
>
> > In the past you could go from key developments to company news for any
> > securities by simply changing the url address in D2 from "="
> > http://www.reuters.com/finance/stocks/keyDevelopments?symbol="&Ticker" to
> > "="http://www.reuters.com/finance/stocks/companyNews?symbol="&Ticker".
> >
>

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

Re: Does the plug-in run in X64 version of Excel 2010?

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

Mon Sep 19, 2011 9:15 am (PDT)



No, most of it is not from your adding.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> No idea. But I hope your "huge amount of data" is not from using the add-in.
>
> On Sun, Sep 18, 2011 at 10:34 PM, gz_cp <gz_cp@...> wrote:
>
> > My 32 bit version of Excel 2010 is not able to handle my huge amount of
> > data any more and I am thinking about upgrading it to a 64 version.
> >
> > Does the plug-in work in x64 bit?
> >
>

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

Re: =smfGetOptionQuotes not working

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

Mon Sep 19, 2011 9:32 am (PDT)



I am running Stock Market Functions add-in, Version 2.0j

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The function works fine for me. I would suspect you have an older version of
> the add-in that didn't have that function. What version are you running?
>
> =RCHGetElementNumber("Version")
>
> On Thu, Sep 15, 2011 at 8:57 AM, mandadjiev2000 <mandadjiev2000@...>wrote:
>
> > =smfGetOptionQuotes("ADBE JAN 2012 $35 PUT","b",0,"Y") give me #name?
> >
> > The plug in is installed properly, because
> > =RCHGetYahooQuotes(B2,"l1",,now,0) give me the right answer.
> >
> > Can you confirm that =smfGetOptionQuotes is working OK?
> >
>

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

Re: =smfGetOptionQuotes not working

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

Mon Sep 19, 2011 11:43 am (PDT)



You'll need to install a later version to have the smfGetOptionQuotes()
function available. I would even suggest the beta version available in the
"Works in Progress" folder.

On Mon, Sep 19, 2011 at 9:32 AM, mandadjiev2000 <mandadjiev2000@yahoo.com>wrote:

> I am running Stock Market Functions add-in, Version 2.0j
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > The function works fine for me. I would suspect you have an older version
> of
> > the add-in that didn't have that function. What version are you running?
> >
> > =RCHGetElementNumber("Version")
> >
> > On Thu, Sep 15, 2011 at 8:57 AM, mandadjiev2000 <mandadjiev2000@
> ...>wrote:
> >
> > > =smfGetOptionQuotes("ADBE JAN 2012 $35 PUT","b",0,"Y") give me #name?
> > >
> > > The plug in is installed properly, because
> > > =RCHGetYahooQuotes(B2,"l1",,now,0) give me the right answer.
> > >
> > > Can you confirm that =smfGetOptionQuotes is working OK?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
4a.

Re: smfGetAdvFNElement not working

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

Tue Sep 20, 2011 12:31 am (PDT)



Hi Randy, thanks for the quick reply. I'm not sure what you mean as I don't use Internet Explorer (IE ?). Using Chrome. I've replaced the source of the links with the add-in on my hard drive (?).

Also, I access advfn from Canada. It seems the code is rigged to pick up data from the U.S. site (?). Could that have an effect?

Any help would be greatly appreciated. Thanks.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> It may just be an IE security thing -- see the AdvFN entry in the "Links"
> area of the group. Hopefully, that will solve the problem.
>
> On Thu, Sep 15, 2011 at 8:36 PM, a_clark_canada <a_clark_canada@...>wrote:
>
> >
> > I really like your add-in. I'm just having some trouble with the
> > smfGetAdvFNElement function.
> >
> > I have tried it several ways. I have also tried using the
> > RCHGetElementNumber function and it too will not get the info for me. Both
> > functions bring back "Error". The GetElementNumber function will work if I'm
> > trying to access Yahoo's site. So I find this odd.
> >
> > I have the latest version of the add-in installed from 2010/08/02.
> >
> > Any suggestions would be greatly appreciated.
> >
>

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

Re: smfGetAdvFNElement not working

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

Tue Sep 20, 2011 12:51 am (PDT)



You may not use IE, but EXCEL and the add-in use the same protocols IE does
when they access the Internet. So they share IE's settings, security
cookies, and Temporary Internet Files. So those items are very important to
the add-in.

You should NOT be replacing the source of the links, you should be REMOVING
them.

Again, check out the "Links" area of the group. You should find the two
related items -- one on the "#NAME?" issue and one on the AdvFN issue.

If I recall correctly, AdvFN does do some recognition of where you are from,
so you may need to use U.S. exchange prefixes to get data on U.S. stocks.
The only way to know for sure is to see what happens to your ticker symbol
in the URL when you try to access data with the browser. I don't have the
problems, so it's hard for me to diagnose some of those that others have due
to country location.

On Tue, Sep 20, 2011 at 12:31 AM, a_clark_canada
<a_clark_canada@yahoo.com>wrote:

> Hi Randy, thanks for the quick reply. I'm not sure what you mean as I don't
> use Internet Explorer (IE ?). Using Chrome. I've replaced the source of the
> links with the add-in on my hard drive (?).
>
> Also, I access advfn from Canada. It seems the code is rigged to pick up
> data from the U.S. site (?). Could that have an effect?
>
> Any help would be greatly appreciated. Thanks.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
Recent Activity
Visit Your Group
Need traffic?

Drive customers

With search ads

on Yahoo!

Yahoo! News

Fashion News

What's the word on

fashion and style?

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

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
MARKETPLACE

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

Diposting oleh EXCEL FEED LEARNING di 03.21

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)