Kamis, 01 Maret 2012

[smf_addin] Digest Number 2133

Messages In This Digest (13 Messages)

1a.
Average Weighted Coupon - bonds From: addison.ingle
1b.
Re: Average Weighted Coupon - bonds From: Randy Harmelink
1c.
Re: Average Weighted Coupon - bonds From: addison.ingle
2a.
Re: market open/ close From: jurgen.conrad
2b.
Re: market open/ close From: Randy Harmelink
3a.
excell 2007 From: babond
3b.
Re: excell 2007 From: Randy Harmelink
3c.
Re: excell 2007 From: babond
3d.
Re: excell 2007 From: Randy H
3e.
Re: excell 2007 From: babond
3f.
Re: excell 2007 From: Randy Harmelink
3g.
Re: excell 2007 From: babond
4.
Stock Charts - Notproviding European Data From: Philip S

Messages

1a.

Average Weighted Coupon - bonds

Posted by: "addison.ingle" addison.ingle@gmail.com   addison.ingle

Wed Feb 29, 2012 8:16 am (PST)



The portfolio page for Morningstar bond funds shows "Weighted Average Coupon". Quicktake....printreport does not pull up the data. I have looked at Yahoo as well in an effort to find a way to get this info.

For example...THOPX.

Is there anything I can try to use to get this info?

Thanks.

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

Re: Average Weighted Coupon - bonds

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

Wed Feb 29, 2012 8:29 am (PST)



Why not just:

=RCHGetTableCell("http://portfolios.morningstar.com/fund/summary?t=THOPX",1,"Weighted
Coupon")

On Wed, Feb 29, 2012 at 9:16 AM, addison.ingle <addison.ingle@gmail.com>wrote:

> The portfolio page for Morningstar bond funds shows "Weighted Average
> Coupon". Quicktake....printreport does not pull up the data. I have looked
> at Yahoo as well in an effort to find a way to get this info.
>
> For example...THOPX.
>
> Is there anything I can try to use to get this info?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
1c.

Re: Average Weighted Coupon - bonds

Posted by: "addison.ingle" addison.ingle@gmail.com   addison.ingle

Wed Feb 29, 2012 8:39 am (PST)



Naturally, that works perfectly. Obviously, I am still learning how the add-in works. I really appreciate your help and your patience. I promise I'll get this thing figured out eventually!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Why not just:
>
> =RCHGetTableCell("http://portfolios.morningstar.com/fund/summary?t=THOPX",1,"Weighted
> Coupon")
>
> On Wed, Feb 29, 2012 at 9:16 AM, addison.ingle <addison.ingle@...>wrote:
>
> > The portfolio page for Morningstar bond funds shows "Weighted Average
> > Coupon". Quicktake....printreport does not pull up the data. I have looked
> > at Yahoo as well in an effort to find a way to get this info.
> >
> > For example...THOPX.
> >
> > Is there anything I can try to use to get this info?
> >
>

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

Re: market open/ close

Posted by: "jurgen.conrad" jurgen.conrad@gmail.com   jurgen.conrad

Wed Feb 29, 2012 2:39 pm (PST)





hi Randy - thanks for this and i will make use of this.

something peculiar on my computer (or Excel), it seems that the URL is cached - i.e

i use the below URL with AAC.AX and i receive the time correctly until the market opens
<Thu 1 Mar 2012 09:02 - Australia Markets open in 58 mins.>

refreshing this 12 minutes later and the remaining time is not updated
<Thu 1 Mar 2012 09:02 - Australia Markets open in 58 mins.>

changing the URL to include BHP.AX will update the time correctly to
<Thu 1 Mar 2012 09:14 - Australia Markets open in 46 mins.>

reverting the URL back to AAC.AX and the original remaining time is displayed
<Thu 1 Mar 2012 09:02 - Australia Markets open in 58 mins.>

any idea where i would need to make changes??? if not, i can change the URL and with 2000 securities on the ASX i should be ok for a while.

btw - Randy this is an awesome add-in that you have created.

thanks & best regards - jurgen

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You can try:
>
> =smfGetTagContent("http://au.finance.yahoo.com/q?s=AAC.AX
> ","span",-1,"yfs_market_time")
>
> I'm not sure what it will look like after the market is closed, but here's
> what I got just prior to the market open, and after the market opened:
>
> Wed 29 Feb 2012 09:50 - Australia Markets open in 10 mins.
> Wed 29 Feb 2012 10:00 - Australia Markets close in 6 hrs.
>
> If they follow the same structure as the U.S. web pages, it should say
> "Australia Markets closed" when the market closes for the day.
>
> On Tue, Feb 28, 2012 at 3:38 PM, jurgen.conrad <jurgen.conrad@...>wrote:
>
> > hi all - is the market open/ close information obtainable???
> >
> > i.e. it would be great to know if the AU market (or other markets) is
> > currently open or closed.
> >
> > i can do it by other means, however it would be more ease (i believe).
> >
> > thanks in advance for your help & time - regards...
> >
>

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

Re: market open/ close

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

Wed Feb 29, 2012 3:00 pm (PST)



Check out item 9.4.2 in the "Links" area of the group. You need to change a
setting in Internet Options.

On Wed, Feb 29, 2012 at 3:39 PM, jurgen.conrad <jurgen.conrad@gmail.com>wrote:

>
> something peculiar on my computer (or Excel), it seems that the URL is
> cached - i.e
>
> any idea where i would need to make changes??? if not, i can change the
> URL and with 2000 securities on the ASX i should be ok for a while.
>
> btw - Randy this is an awesome add-in that you have created.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3a.

excell 2007

Posted by: "babond" babond@suddenlink.net   babond2

Wed Feb 29, 2012 5:23 pm (PST)



I sure am having trouble getting the download addins to work. Only blank #### data. Even turned off firewall thinking it would provide a different result.

I've downloaded zip file, created SMF Add-In directory, installed the RCH_Stock_Market_Functions, put test files in the same directory.....nothing worked. Can see data on some of the downloaded test files but if I try to change the symbol, everything goes to #'s. I even watched a You Tube demo. I "think" I am doing everything correct - - obviously not.

can anyone help?

BAB

bec@brightok.net
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
3b.

Re: excell 2007

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

Wed Feb 29, 2012 5:25 pm (PST)



I don't know what "blank #### data" means...

What do you get when you enter this formula in a cell:

=RCHGetElementNumber("Version")

On Wed, Feb 29, 2012 at 6:00 PM, babond <babond@suddenlink.net> wrote:

> **
>
> I sure am having trouble getting the download addins to work. Only blank
> #### data. Even turned off firewall thinking it would provide a different
> result.
>
> I've downloaded zip file, created SMF Add-In directory, installed the
> RCH_Stock_Market_Functions, put test files in the same
> directory.....nothing worked. Can see data on some of the downloaded test
> files but if I try to change the symbol, everything goes to #'s. I even
> watched a You Tube demo. I "think" I am doing everything correct - -
> obviously not.
>
> can anyone help?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
3c.

Re: excell 2007

Posted by: "babond" babond@suddenlink.net   babond2

Wed Feb 29, 2012 7:13 pm (PST)



I get the filled text shown below

Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\SMF Add-In\RCH_Stock_Market_Functions-2.1.2012.02.02; 1)

Thanks for the quick response

BAB

----- Original Message -----
From: Randy Harmelink
To: smf_addin@yahoogroups.com
Sent: Wednesday, February 29, 2012 7:24 PM
Subject: Re: [smf_addin] excell 2007

I don't know what "blank #### data" means...

What do you get when you enter this formula in a cell:

=RCHGetElementNumber("Version")

On Wed, Feb 29, 2012 at 6:00 PM, babond <babond@suddenlink.net> wrote:

I sure am having trouble getting the download addins to work. Only blank #### data. Even turned off firewall thinking it would provide a different result.

I've downloaded zip file, created SMF Add-In directory, installed the RCH_Stock_Market_Functions, put test files in the same directory.....nothing worked. Can see data on some of the downloaded test files but if I try to change the symbol, everything goes to #'s. I even watched a You Tube demo. I "think" I am doing everything correct - - obviously not.

can anyone help?

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

Re: excell 2007

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

Wed Feb 29, 2012 7:36 pm (PST)



At least that means the add-in is installed and active.

However, with the folder name you're using for the add-in -- C:\SMF
Add-In\RCH_Stock_Market_Functions-2.1.2012.02.02 -- none of the
templates are going to work until you manually fix the location errors
-- see item 0.2 in the "Links" area of the group. That folder name
you're using for the add-in will not match anything that is in the files
area.

On Wed, Feb 29, 2012 at 8:13 PM, babond <babond@suddenlink.net> wrote:

I get the filled text shown below Stock Market
Functions add-in, Version 2.1.2012.02.02 (C:\SMF
Add-In\RCH_Stock_Market_Functions-2.1.2012.02.02; 1)
What do you get when you enter this formula in a cell:

=RCHGetElementNumber("Version")

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

Re: excell 2007

Posted by: "babond" babond@suddenlink.net   babond2

Wed Feb 29, 2012 8:37 pm (PST)



I'm sorry " can you be more exact" .....where is the item 0.2 in the "links" area..... A Link would be nice. Manually fix it to what ??

BAB
----- Original Message -----
From: Randy H
To: smf_addin@yahoogroups.com
Sent: Wednesday, February 29, 2012 9:36 PM
Subject: [smf_addin] Re: excell 2007

At least that means the add-in is installed and active.

However, with the folder name you're using for the add-in -- C:\SMF Add-In\RCH_Stock_Market_Functions-2.1.2012.02.02 -- none of the templates are going to work until you manually fix the location errors -- see item 0.2 in the "Links" area of the group. That folder name you're using for the add-in will not match anything that is in the files area.

On Wed, Feb 29, 2012 at 8:13 PM, babond <babond@suddenlink.net> wrote:

I get the filled text shown below

Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\SMF Add-In\RCH_Stock_Market_Functions-2.1.2012.02.02; 1)


What do you get when you enter this formula in a cell:

=RCHGetElementNumber("Version")

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

Re: excell 2007

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

Wed Feb 29, 2012 8:58 pm (PST)



The "Links" area of the group is here:

http://finance.groups.yahoo.com/group/smf_addin/links

On Wed, Feb 29, 2012 at 9:36 PM, babond <babond@suddenlink.net> wrote:

> **
>
> I'm sorry " can you be more exact" .....where is the item 0.2 in the
> "links" area..... A Link would be nice. Manually fix it to what ??
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
3g.

Re: excell 2007

Posted by: "babond" babond@suddenlink.net   babond2

Wed Feb 29, 2012 9:02 pm (PST)



OK found it..... http://finance.groups.yahoo.com/group/smf_addin/message/11346

do not fully understand, I will read more......

bab

----- Original Message -----
From: Randy H
To: smf_addin@yahoogroups.com
Sent: Wednesday, February 29, 2012 9:36 PM
Subject: [smf_addin] Re: excell 2007

At least that means the add-in is installed and active.

However, with the folder name you're using for the add-in -- C:\SMF Add-In\RCH_Stock_Market_Functions-2.1.2012.02.02 -- none of the templates are going to work until you manually fix the location errors -- see item 0.2 in the "Links" area of the group. That folder name you're using for the add-in will not match anything that is in the files area.

On Wed, Feb 29, 2012 at 8:13 PM, babond <babond@suddenlink.net> wrote:

I get the filled text shown below

Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\SMF Add-In\RCH_Stock_Market_Functions-2.1.2012.02.02; 1)


What do you get when you enter this formula in a cell:

=RCHGetElementNumber("Version")

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

Stock Charts - Notproviding European Data

Posted by: "Philip S" Philip_R_Small@hotmail.com   philip_r_small

Thu Mar 1, 2012 1:35 am (PST)



I had a couple of good stock charts that I used to look at several UK based stocks using the formula below to bring them in via stockcharts.

=RCHCreateComment("http://stockcharts.com/c-sc/sc?s="&A1&"&p=D&b=5&g=0&i=0&r=8876",99,,,10)

Just seen that they have "switched off" the European coverage. Does anyone know of another site that might offer a similar chart for UK/European companies?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
Recent Activity
Visit Your Group
Yahoo! News

Odd News

You won't believe

it, but it's true

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need traffic?

Drive customers

With search ads

on Yahoo!

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 02.23

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)