Messages In This Digest (7 Messages)
- 1.
- Zacks data for Canadian stocks From: Jacob Jose
- 2a.
- Equtiy CUSIP lookup From: john.sitarz
- 2b.
- Re: Equtiy CUSIP lookup From: Randy Harmelink
- 2c.
- Re: Equtiy CUSIP lookup From: John Sitarz
- 3.
- Anyone else timing out with smartmoney? From: B B
- 4a.
- Re: FYI - RCHGetYahooQuotes returns incorrect 52-wk high price for C From: thtabe
- 5a.
- Re: Please help: keep getting windows security alarm From: xjiaan
Messages
- 1.
-
Zacks data for Canadian stocks
Posted by: "Jacob Jose" pepecan47@yahoo.ca pepecan47
Fri Sep 30, 2011 8:09 am (PDT)
Does anybody know how to get Canadian Stocks info from Zacks?
Regards,
Jose L. Jacob
- 2a.
-
Equtiy CUSIP lookup
Posted by: "john.sitarz" john.sitarz@gmail.com john.sitarz
Fri Sep 30, 2011 9:00 am (PDT)
Is there anyway to get cusip info from this website http://quantumonline.com/search. cfm
I need to be able to lookup the CUSIP info by ticker.
Thanks for your help,
John
- 2b.
-
Re: Equtiy CUSIP lookup
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Sep 30, 2011 9:06 am (PDT)
This:
=smfGetTagContent("
http://quantumonline.com/search. cfm?sopt= symbol&1. 0.1=Search& tickersymbol=
"&D2,"b",-1,"CUSIP:")
...should get you something like this, from which you can extract the CUSIP:
Ticker Symbol: IBM CUSIP: 459200101 Exchange: NYSE
For example, if you were using the latest beta version of the add-in from
the "Works in Progress" folder:
=smfStrExtr(smfGetTagContent ("
http://quantumonline.com/search. cfm?sopt= symbol&1. 0.1=Search& tickersymbol=
"&D2,
"b",-1,"CUSIP:"),"CUSIP: "," ")
On Fri, Sep 30, 2011 at 8:57 AM, john.sitarz <john.sitarz@gmail.com > wrote:
> Is there anyway to get cusip info from this website
> http://quantumonline.com/search. cfm
>
> I need to be able to lookup the CUSIP info by ticker.
>
- 2c.
-
Re: Equtiy CUSIP lookup
Posted by: "John Sitarz" john.sitarz@gmail.com john.sitarz
Fri Sep 30, 2011 9:44 am (PDT)
Thansk so much. That is awesome.
On Fri, Sep 30, 2011 at 10:06 AM, Randy Harmelink <rharmelink@gmail.com >wrote:
> **
>
>
> This:
>
> =smfGetTagContent("
> http://quantumonline.com/search. cfm?sopt= symbol&1. 0.1=Search& tickersymbol=
> "&D2,"b",-1,"CUSIP:")
>
> ...should get you something like this, from which you can extract the
> CUSIP:
>
> Ticker Symbol: IBM CUSIP: 459200101 Exchange: NYSE
>
> For example, if you were using the latest beta version of the add-in from
> the "Works in Progress" folder:
>
> =smfStrExtr(smfGetTagContent ("
> http://quantumonline.com/search. cfm?sopt= symbol&1. 0.1=Search& tickersymbol=
> "&D2,
> "b",-1,"CUSIP:"),"CUSIP: "," ")
>
>
> On Fri, Sep 30, 2011 at 8:57 AM, john.sitarz <john.sitarz@gmail.com >wrote:
>
>> Is there anyway to get cusip info from this website
>> http://quantumonline.com/search. cfm
>>
>> I need to be able to lookup the CUSIP info by ticker.
>>
>
>
>
- 3.
-
Anyone else timing out with smartmoney?
Posted by: "B B" kokdari82@yahoo.com kokdari82
Fri Sep 30, 2011 12:14 pm (PDT)
Just wanted to see whether people who are using smartmoney to pull data for their templates is timing out.
Seems like during 9am-4pm EST, it cant load 100% of the data. Consistently a few years of data not showing up.
Was wondering whether its a system or smartmoney have implemented something to prevent multiple requests from the same IP.
- 4a.
-
Re: FYI - RCHGetYahooQuotes returns incorrect 52-wk high price for C
Posted by: "thtabe" thtabe@yahoo.com thtabe
Fri Sep 30, 2011 2:21 pm (PDT)
I am having the same problem with the 52 low.
FDX returns 52 week low of $71.33 should be $64.55.
F returns 52 week low of $9.81 should be $9.32.
T.
--- In smf_addin@yahoogroups.com , Sharon McAllister <sharonnraymc@...> wrote:
>
> I reported the problem to Yahoo! Finance. Is anyone else noticing data issues with the 52-week high price? Colgate-Palmolive is one of the companies whose ticker was not returning price quotes on Tuesday.
> -Sharon
>
- 5a.
-
Re: Please help: keep getting windows security alarm
Posted by: "xjiaan" xjiaan@yahoo.com xjiaan
Fri Sep 30, 2011 3:44 pm (PDT)
thanks,fixed by accepting all the cookies which can be configured in privacy menu of IE.
--- In smf_addin@yahoogroups.com , "xjiaan" <xjiaan@...> wrote:
>
> ok,i will try to lower the internet security seting to see whether this can help.
>
> very appreciate your help!
>
> have a good night!
>
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > Right. Settings and files.
> >
> > On Wed, Sep 28, 2011 at 3:35 PM, xjiaan <xjiaan@> wrote:
> >
> > >
> > > so i need change the security setting of IE ,because EXCEL use the same
> > > configuration as IE ?
> > >
> >
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
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
Tidak ada komentar:
Posting Komentar