Jumat, 16 September 2011

[smf_addin] Digest Number 1956

Messages In This Digest (14 Messages)

Messages

1a.

Re: Google share price data

Posted by: "Steven" stevenletzer@yahoo.com   stevenletzer

Thu Sep 15, 2011 7:56 am (PDT)



Is there a list of the codes to use in the formulas? Such as company name, date of last trade, and the other financial data in the Google quote area. For example symbol 0215 (HKG:0215) returns these items.

Hutchison Telecommunications HK Hld Ltd (Public, HKG:0215)
Sep 15 - Close
Currency in HKD
Range 2.95 - 3.06
52 week 2.02 - 3.22
Open 2.99
Vol. 10.81M
Mkt cap 14.74B
P/E 16.60
Div/yield 0.05/3.92
EPS 0.18
Shares 4.82B






3.06
+0.12 (4.08%) Sep 15 - Close
HKG data delayed by 15 mins - Disclaimer
Currency in HKD

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Take a look at the SMF-Template-Yahoo-Google-Pre-Market-Quotes.xls template.
> You'll need to expand the collapsed columns to get to the necessary
> formulas.
>
> On Thu, Sep 1, 2011 at 8:21 AM, Steven <stevenletzer@...> wrote:
>
> > I am trying to capture the price, change and percent change for stocks that
> > trade outside of the USA. For examples:
> > Hutchison Telecommunications Hong Kong Holdings Ltd., symbol HKG:0215
> > SmarTone Telecommunications Holdings Ltd. symbol HKG:0315
> > Tokyo Broadcasting System Incorporated symbol TYO:9401
> >
> > These stocks trade in their domestic currency, so I most interested in the
> > percent change.
> >
> > Any ideas?
> >
>

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

Re: Google share price data

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

Thu Sep 15, 2011 8:22 am (PDT)



I have no idea what you mean by "list of codes" -- for what?

On Thu, Sep 15, 2011 at 7:56 AM, Steven <stevenletzer@yahoo.com> wrote:

> Is there a list of the codes to use in the formulas? Such as company name,
> date of last trade, and the other financial data in the Google quote area.
> For example symbol 0215 (HKG:0215) returns these items.
>
> Hutchison Telecommunications HK Hld Ltd (Public, HKG:0215)
> Sep 15 - Close
> Currency in HKD
> Range 2.95 - 3.06
> 52 week 2.02 - 3.22
> Open 2.99
> Vol. 10.81M
> Mkt cap 14.74B
> P/E 16.60
> Div/yield 0.05/3.92
> EPS 0.18
> Shares 4.82B
>
>
>
>
>
>
> 3.06
> +0.12 (4.08%) Sep 15 - Close
> HKG data delayed by 15 mins - Disclaimer
> Currency in HKD
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
1c.

Re: Google share price data

Posted by: "Steven" stevenletzer@yahoo.com   stevenletzer

Thu Sep 15, 2011 10:52 am (PDT)



Im sorry, I thought I sent this as a reply from a previous message. This formula is from the pre-market worksheet.

0+smfGetTagContent("http://www.google.com/finance?q="&Ticker,"span",-1,"_l"">")

The l in -> ,"_l"">")changes to get different information, l=last, c=change, cp=percent change. I was wondering if there is more information that can be captured from Google finance.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I have no idea what you mean by "list of codes" -- for what?
>
> On Thu, Sep 15, 2011 at 7:56 AM, Steven <stevenletzer@...> wrote:
>
> > Is there a list of the codes to use in the formulas? Such as company name,
> > date of last trade, and the other financial data in the Google quote area.
> > For example symbol 0215 (HKG:0215) returns these items.
> >
> > Hutchison Telecommunications HK Hld Ltd (Public, HKG:0215)
> > Sep 15 - Close
> > Currency in HKD
> > Range 2.95 - 3.06
> > 52 week 2.02 - 3.22
> > Open 2.99
> > Vol. 10.81M
> > Mkt cap 14.74B
> > P/E 16.60
> > Div/yield 0.05/3.92
> > EPS 0.18
> > Shares 4.82B
> >
> >
> >
> >
> >
> >
> > 3.06
> > +0.12 (4.08%) Sep 15 - Close
> > HKG data delayed by 15 mins - Disclaimer
> > Currency in HKD
> >
>

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

Re: Google share price data

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

Thu Sep 15, 2011 12:15 pm (PDT)



You'll have to examine the source code of the web page to see what's
available...

On Thu, Sep 15, 2011 at 10:52 AM, Steven <stevenletzer@yahoo.com> wrote:

> Im sorry, I thought I sent this as a reply from a previous message. This
> formula is from the pre-market worksheet.
>
> 0+smfGetTagContent("http://www.google.com/finance?q=
> "&Ticker,"span",-1,"_l"">")
>
> The l in -> ,"_l"">")changes to get different information, l=last,
> c=change, cp=percent change. I was wondering if there is more information
> that can be captured from Google finance.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2a.

=smfGetOptionQuotes not working

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

Thu Sep 15, 2011 9:23 am (PDT)



=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?

THanks,

I.

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

Re: =smfGetOptionQuotes not working

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

Thu Sep 15, 2011 9:24 am (PDT)



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@yahoo.com>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 (2)
3a.

Futures

Posted by: "Tim" tim@riverrockinvestors.com   sweetpercyz

Thu Sep 15, 2011 9:34 am (PDT)



Just wondering if anyone has thought of a program that would look at futures contracts? For instance the ability to pull up the next 12 contracts for crude oil and to see how the term structure is changing could be very helpful in determining supply / demand and therefore price. Maybe from a website such as http://futures.tradingcharts.com/marketquotes/

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

Re: SMF-Template-Reuters-Ratios-Comparison.xls Percentage Errors

Posted by: "Peter C" pcalinski@yahoo.com   pcalinski

Thu Sep 15, 2011 10:36 am (PDT)



Yes, looks great now. Thanks!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Just the dividends section, right? The version on my hard drive already had
> the changes, so I must have forgotten to upload the changes. I just uploaded
> the new file. Thanks!
>
> On Wed, Sep 14, 2011 at 6:19 PM, Peter C <pcalinski@...> wrote:
>
> > I was looking at SMF-Template-Reuters-Ratios-Comparison.xls and discovered
> > that some (if not all) values that are formatted as percent are too high by
> > a factor of 100.
> >
> > I gather the value returned is already a percent value and when formatted
> > "percent" it gets double applied.
> >
> > If there is not already a corrected version I can correct this one and
> > upload it.
> >
>

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

www.dividendinvestor.com Dividend AllStar™ Ranking

Posted by: "carmine288" carmine.nicoletta@gmail.com   carmine288

Thu Sep 15, 2011 12:43 pm (PDT)



Randy, any suggestions on how to grab the "Dividend AllStar™ Ranking"

Thanks

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

Re: [smf_addin] www.dividendinvestor.com Dividend AllStar̢㢠Ran

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

Thu Sep 15, 2011 1:01 pm (PDT)



Check the archives. It's been discussed before. And not necessarily simple.

On Thu, Sep 15, 2011 at 12:43 PM, carmine288 <carmine.nicoletta@gmail.com>wrote:

> Randy, any suggestions on how to grab the "Dividend AllStar̢㢠Ranking"
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
6a.

SMF-Template-Reuters-Ratios-Comparison.xls

Posted by: "cdtrad123" clinton.hofman@gmail.com   cdtrad123

Thu Sep 15, 2011 8:32 pm (PDT)



Hi All,

Just downloaded the SMF-Template-Reuters-Ratios-Comparison.xls but it is just showing error and #VALUE. Others work fine. Any Ideas?

Thanks!

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

Re: SMF-Template-Reuters-Ratios-Comparison.xls

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

Thu Sep 15, 2011 8:34 pm (PDT)



You probably just need the updated element definitions in file
smf-elements-5.txt, which you can find in the "Works in Progress" folder of
the files area of the group. I had to update the element definitions when
they changed their web site earlier this year. After replacing that file,
run the smfForceRecalculation macro to reload the element definitions.

On Thu, Sep 15, 2011 at 8:27 PM, cdtrad123 <clinton.hofman@gmail.com> wrote:

> Just downloaded the SMF-Template-Reuters-Ratios-Comparison.xls but it is
> just showing error and #VALUE. Others work fine. Any Ideas?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
7a.

smfGetAdvFNElement not working

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

Thu Sep 15, 2011 8:37 pm (PDT)



Hi Randy (or anyone that can help),

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.

Cheers,
- a

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

Re: smfGetAdvFNElement not working

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

Thu Sep 15, 2011 8:39 pm (PDT)



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@yahoo.com>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 (2)
Recent Activity
Visit Your Group
Need traffic?

Drive customers

With search ads

on Yahoo!

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
MARKETPLACE
A bad score is 579. A good idea is checking yours at freecreditscore.com.

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.12

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)