Messages In This Digest (12 Messages)
- 1a.
- Re: Full security name From: Ron Spruell
- 1b.
- Re: Full security name From: Randy Harmelink
- 2a.
- Re: profile summary From: nikos chryssochoidis
- 3a.
- Re: Income Funds From: paul messerschmidt
- 4a.
- Federal Reserve Bank of St. Louis - Economic Data (FRED) Add-in for From: mkorgie
- 4b.
- Re: Federal Reserve Bank of St. Louis - Economic Data (FRED) Add-in From: Michael Thomas
- 5a.
- SMF for Dummy's? From: thtabe
- 5b.
- Re: SMF for Dummy's? From: Randy Harmelink
- 6a.
- Future of SMF-Add In From: Michael Thomas
- 6b.
- Re: Future of SMF-Add In From: Randy Harmelink
- 6c.
- Re: Future of SMF-Add In From: Charles Backus
- 6d.
- Re: Future of SMF-Add In From: rex
Messages
- 1a.
-
Re: Full security name
Posted by: "Ron Spruell" hashky@yahoo.com hashky
Mon Aug 8, 2011 5:57 am (PDT)
Thanks Gary.
I was looking for an example of how to use SMFGetTagContent so that I could better learn how to use the command.
Ron
>____________________ _________ ___
>From: Gary Funck <gary@intrepid.com >
>To: smf_addin@yahoogroups.com
>Sent: Monday, August 8, 2011 2:17 AM
>Subject: Re: [smf_addin] Re: Full security name
>
>
>
>On 08/08/11 05:32:34, hashky wrote:
>> Randy -
>>
>> This is what I use for pulling the full security name.
>>
>> =(RCHGetTableCell("http://finance. yahoo.com/ "&C4,0,"("&C4&q/pr?s= ")","("&C4& ")"))
>
>I ended up using this in a spreadsheet that I put together a while back.
>
>=RCHGetTableCell("http://finviz. com/quote. "&Symbol1,1,ashx?t= "fullview- ticker"," <tr")
>
>where Symbol1 is a defined name for a particular cell.
>
>- Gary
>
>PS: Randy, or someone else on the list, likely suggested this.
>
>
>
> - 1b.
-
Re: Full security name
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Aug 8, 2011 10:57 am (PDT)
This is what I came up with using smfGetTagContent:
=smfGetTagContent("http://finance. yahoo.com/ q/pr?s=
"&C4,"b",1,"id=""pageTicker" "")
It pulls it from the first line of the general company information data
area.
For the item you're pulling:
=smfGetTagContent("http://finance. yahoo.com/ q/pr?s=
"&C4,"b",-1,"("&C4&") ","("&C4& ")")
Basically just using the same table cell, but using the HTML tags within the
table cell.
On Sun, Aug 7, 2011 at 10:32 PM, hashky <hashky@yahoo.com > wrote:
>
> This is what I use for pulling the full security name.
>
> =(RCHGetTableCell("http://finance. yahoo.com/ q/pr?s=
> "&C4,0,"("&C4&")","("&C4& ")"))
>
> Would I be better off using the SMFGetTagContent? Could you give me the
> equation for pulling the same information using Tag Content?
>
> The SMFGetTagContent is hard for me to get my mind around.
>
- 2a.
-
Re: profile summary
Posted by: "nikos chryssochoidis" nikoschryssochoidis@yahoo.gr nikoschryssochoidis
Mon Aug 8, 2011 6:54 am (PDT)
--- In smf_addin@yahoogroups.com , "kostas" <nasta256@...> wrote:
>
>
>
>
>
> --- In smf_addin@yahoogroups.com , "nikos chryssochoidis" <nikoschryssochoidis@> wrote:
> >
> > hi,
> >
> > am wondering if there is a formula to use , in order to add in a cell of an excel the profile summary of a company listed in a stock exchange.
> >
> > thank you , and many thanks for this great group !
> >
>
> Hi,
> You can use =smfGetTagContent(_
> "http://www.reuters.com/finance/ ","div",1,"Full Description"stocks/companyPr ofile?symbol= HEPr.AT )
> and clean it with some string manipulation.
> You will find that Reuters as a source has most of the Greek companies.
> Elpizo na boi8isa.
> Kostas
>
euxaristw poly kwsta , tha prospathisw twra na syndesw to add in ayto sto add in getyahooquotes
- 3a.
-
Re: Income Funds
Posted by: "paul messerschmidt" financepaul@gmail.com fuelspotpaul
Mon Aug 8, 2011 11:05 am (PDT)
these are very different products with very different characteristics.
NCZ - The Fund seeks total return with capital appreciation and high current
income through investment in convertible and non convertible income
producing *non investment grade securities*
*
*
BTA - The Fund seeks current income *exempt from regular Federal
income tax*through investment in long term
*investment grade* *municipal securities*
*
*
*
*
both are 1-star from morningstar
http://cef.morningstar.com/quote? t=bta
http://cef.morningstar.com/quote? t=ncz
with NCZ, you are paying a premium to net asset value (nav), currently about
7%
http://www.cefconnect.com/Details/ Summary.aspx? ticker=NCZ
http://www.closed-endfunds. com/FundSelector /FundDetail. fs?ID=91340
BTA is currently trading at a discount to nav -- about 5% -- giving you some
upside if (when) it returns to its average discount of 2%
http://www.cefconnect.com/Details/ Summary.aspx? ticker=BTA
http://www.closed-endfunds. com/FundSelector /FundDetail. fs?ID=107601
i buy closed-end funds (cef's) for my ira's, but stick with solid products
trading at a discount (and not tax exempts)
use the fund sorter and filter by discount
http://www.cefconnect.com/Sorter/ FundSorter. aspx
but, do your homework and don't just buy the first on the list
and importantly, be sure the dividend is primarily income, and not just a
return-of-capital (roc), where they are just giving you your money back.
here is what happens when investors chase yield -- which is really roc --
and the fund cut the 'dividend'
http://www.cefconnect.com/Details/ Summary.aspx? ticker=GUT
here you can search for 'income yield' vs. 'distribution yield' of
'managed distribution funds' which plan to pay a steady distribution.
http://www.closed-endfunds. com/ManagedDistr ibutions/ default.fs? ID=42963
the closer this ratio is to 1.00, the better, as you are obtaining
return-on-capital vs. return-of-capital. if i want to pay someone just to
give me my money back, i'll buy t-bills -- which actually traded above par
recently.
i also like to see significant insider participation
http://www.finviz.com/quote. ashx?t=bta& ty=c&ta=1& p=d
BTA has only 0.02% insiders -- do they know something you don't?
if i had to pick one, i'd buy BTA, but not for an ira, as it is already tax
advantaged.
i like exchange-traded debt securities (more on these at a later date)
here is one that won't give you capital appreciation, but the dividend is
about as secure as you can get TVC (or similarly, TVE)
but before you invest, do your due diligence.
know what you trade; trade what you know...
<http://www.cefconnect.com/Details/ >Summary.aspx? ticker=NCZ
On Fri, Aug 5, 2011 at 6:47 PM, elderbands <elderbands@aol.com > wrote:
> **
>
>
> Can I get some opinions on 2 funds for an older couple as far as risk is
> concerned. They are NCZ and BTA.I know that NCZ is rikier ,but it has been
> paying this dividend for many months. Thank you.
>
>
>
--
--------------------- --------- --------- --
Paul Messerschmidt
paul.messerschmidt (skype)
+1-813-334-8682 (mobile)
- 4a.
-
Federal Reserve Bank of St. Louis - Economic Data (FRED) Add-in for
Posted by: "mkorgie" mkorgie@southwind.net mkorgie
Mon Aug 8, 2011 11:59 am (PDT)
Randy and all! ... does anyone have any experience or feedback on the attached addin. Mike
http://research.stlouisfed. org/fred- addin/
The Federal Reserve Bank of St. Louis Economic Data (FRED) Add-In is free software that will significantly reduce the amount of time spent collecting and organizing macroeconomic data. The FRED add-in provides free access to over 30,000 data series from various sources (e.g., BEA, BLS, Census, and OECD) directly through Microsoft Excel.
Key Features:
- One-click instant download of economic time series.
- Browse the most popular data and search the FRED database.
- Quick and easy data frequency conversion and growth rate calculations.
- Instantly refresh and update spreadsheets with newly released data.
- Create graphs with NBER recession shading and an auto update feature.
- 4b.
-
Re: Federal Reserve Bank of St. Louis - Economic Data (FRED) Add-in
Posted by: "Michael Thomas" thomas91112@yahoo.com thomas91112
Mon Aug 8, 2011 7:11 pm (PDT)
Randy has developed a great SMF function called GetEconData for St. Louis Fed FRED data that expands from what you present in your email. For example, the formula for pulling down Consumer Spending is: SMFGetEconData("PCE",B250) ..B250 is a cell that states the date you want the data reported as of e.g. 6/30/2011. It works very well and is easy to apply.
Mike T.
--- On Mon, 8/8/11, mkorgie <mkorgie@southwind.net > wrote:
From: mkorgie <mkorgie@southwind.net >
Subject: [smf_addin] Federal Reserve Bank of St. Louis - Economic Data (FRED) Add-in for Excel
To: smf_addin@yahoogroups.com
Date: Monday, August 8, 2011, 11:58 AM
Randy and all! ... does anyone have any experience or feedback on the attached addin. Mike
http://research.stlouisfed. org/fred- addin/
The Federal Reserve Bank of St. Louis Economic Data (FRED) Add-In is free software that will significantly reduce the amount of time spent collecting and organizing macroeconomic data. The FRED add-in provides free access to over 30,000 data series from various sources (e.g., BEA, BLS, Census, and OECD) directly through Microsoft Excel.
Key Features:
- One-click instant download of economic time series.
- Browse the most popular data and search the FRED database.
- Quick and easy data frequency conversion and growth rate calculations.
- Instantly refresh and update spreadsheets with newly released data.
- Create graphs with NBER recession shading and an auto update feature.
- 5a.
-
SMF for Dummy's?
Posted by: "thtabe" thtabe@yahoo.com thtabe
Mon Aug 8, 2011 1:23 pm (PDT)
Hello All,
I have been stalking the forum for a while now and have tried on several occasions to down load and set up the SMF addin unsuccessfully. I was wondering is there a SMF Addin for dummy's post or file I can't find? Any help would be greatly appreciated.
Tarry
- 5b.
-
Re: SMF for Dummy's?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Aug 8, 2011 1:26 pm (PDT)
At what point of the instructions are you running into problems?
On Mon, Aug 8, 2011 at 1:18 PM, thtabe <thtabe@yahoo.com > wrote:
>
> I have been stalking the forum for a while now and have tried on several
> occasions to down load and set up the SMF addin unsuccessfully. I was
> wondering is there a SMF Addin for dummy's post or file I can't find? Any
> help would be greatly appreciated.
>
- 6a.
-
Future of SMF-Add In
Posted by: "Michael Thomas" thomas91112@yahoo.com thomas91112
Mon Aug 8, 2011 7:20 pm (PDT)
Randy,
You are developing a good add-in service of which many people are becoming dependent for their investment needs. What are your plans for this add-in? Are you going to continue offering it for free or will you be converting to a pay for service add-in? We the users should all be aware of your plans so we don't devote massive amounts of time and effort into setting up and becoming dependent upon your add-in interface only to find we suddenly need to begin paying at rates that we may be unable to accommodate.
We will all greatly appreciate your candor on this topic; as it is your product is terrific and much needed.
Thanks for all your work.
Mike T. - 6b.
-
Re: Future of SMF-Add In
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Aug 8, 2011 8:49 pm (PDT)
Since the code is open source, I would think my plans are more or less
irrelevant.
However, I have never had plans to charge for it, and I don't see that
changing -- EVER. Money is not an issue (even with the market declines). The
most likely scenario is that I simply shut down the group, either because I
get tired of supporting it or am unable to because of health problems. For
example, my kidneys failed in 2007, and I've been in the hospital four times
in the last year because of foot injuries and infections (complicated by
diabetes). Not to mention a recent bout with Shingles and Bell's Palsy.
In fact, I've had people offer donations in the past. My response has always
been, and will continue to be -- give the donations to a worthy charity.
That is, "Pay It Forward"...
On Mon, Aug 8, 2011 at 7:20 PM, Michael Thomas <thomas91112@yahoo.com >wrote:
>
> Randy,
>
> You are developing a good add-in service of which many people are becoming
> dependent for their investment needs. What are your plans for this add-in?
> Are you going to continue offering it for free or will you be converting to
> a pay for service add-in? We the users should all be aware of your plans so
> we don't devote massive amounts of time and effort into setting up and
> becoming dependent upon your add-in interface only to find we suddenly need
> to begin paying at rates that we may be unable to accommodate.
>
> We will all greatly appreciate your candor on this topic; as it is your
> product is terrific and much needed.
>
> Thanks for all your work.
>
> Mike T.
>
- 6c.
-
Re: Future of SMF-Add In
Posted by: "Charles Backus" cbackus@comcast.net charlie51952
Mon Aug 8, 2011 9:00 pm (PDT)
Hey Randy,
Think I just need to say thank you!
Charlie
On Aug 8, 2011, at 8:48 PM, Randy Harmelink <rharmelink@gmail.com > wrote:
> Since the code is open source, I would think my plans are more or less irrelevant.
>
> However, I have never had plans to charge for it, and I don't see that changing -- EVER. Money is not an issue (even with the market declines). The most likely scenario is that I simply shut down the group, either because I get tired of supporting it or am unable to because of health problems. For example, my kidneys failed in 2007, and I've been in the hospital four times in the last year because of foot injuries and infections (complicated by diabetes). Not to mention a recent bout with Shingles and Bell's Palsy.
>
> In fact, I've had people offer donations in the past. My response has always been, and will continue to be -- give the donations to a worthy charity. That is, "Pay It Forward"...
>
>
> On Mon, Aug 8, 2011 at 7:20 PM, Michael Thomas <thomas91112@yahoo.com > wrote:
>
> Randy,
>
> You are developing a good add-in service of which many people are becoming dependent for their investment needs. What are your plans for this add-in? Are you going to continue offering it for free or will you be converting to a pay for service add-in? We the users should all be aware of your plans so we don't devote massive amounts of time and effort into setting up and becoming dependent upon your add-in interface only to find we suddenly need to begin paying at rates that we may be unable to accommodate.
>
> We will all greatly appreciate your candor on this topic; as it is your product is terrific and much needed.
>
> Thanks for all your work.
>
> Mike T.
>
>
- 6d.
-
Re: Future of SMF-Add In
Posted by: "rex" rex@nosyntax.net bios007a
Mon Aug 8, 2011 9:46 pm (PDT)
Michael Thomas <thomas91112@yahoo.com > [2011-08-08 19:20]:
>
> Randy,
> You are developing a good add-in service of which many people are
> becoming dependent for their investment needs. What are your plans for
> this add-in? Are you going to continue offering it for free or will
> you be converting to a pay for service add-in?
Randy regularly turns down offers of contributions. Given that, it
seems highly likely he will ever start charging for SMF_Addin.
However, no one maintains a package forever, and Randy is the only
developer. What happens, if -- god forbid -- he gets hit by a bus?
Due to this possibility, IMO the community of SMF_Addin users has a
strong incentive to work toward insuring the continuity of the
SMF_Addin package, or its functionality. A good way to do that would
be to start a SourceForge project and bring at least a couple of other
developers in. And, it would be natural to port the SMF_Addin to open
source tools to remove the dependency on proprietary M$ tools. EXCEL
could be replaced by the free Open Office, and VBA by any one of
several languages, e.g., Python.
This would not only ensure continuity, it would also allow Mac and
Linux users to use the package.
It's understandable that Randy may not have any interest in doing the
unpaid work required, but if he's not hostile to the idea and would
offer some hints now and then, it could be done.
Randy, what say you?
(BTW, as a Linux user I can't use the the Addin, but I've watched
Randy tirelessly give an amazing level of support to users over the
years, and greatly admire that. Thanks a bunch, Randy.)
-rex
--
Nostalgia is like a grammar lesson;
you find the present tense and the past perfect.
%
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
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