Go Back   CDN Business Directory > Main Category > Financial Planning

 
 
Thread Tools Display Modes
  #38  
Old 02-28-2007, 01:05 PM
HW \Skip\ Weldon
Guest
 
Posts: n/a
Default FROM THE MODERATORS (was: Portfolio Optimization Software)

On Mon, 26 Feb 2007 18:27:43 -0600, Tad Borek <borekfm[at]pacbell.netwrote:

- quote -

> Don't underestimate how much this kind of nonsense -- accusing a
> professional poster of fraud in connection with securities -- shuts down
> contributions to this newsgroup. At least, contributions from those of
> us who actually have access to tools like portfolio optimization software.


The MIFP charter speaks to this subject. I quote from charter item
#8:

"8. Well-tempered disagreements and constructive criticism to
participants of this newsgroup are acceptable in the context of
adding new information to the discussion. Harassment, personal
insults, attacks and profanity towards group participants will
not be tolerated whatsoever."

According to the online dictionary, "harass" implies systematic
persecution by besieging with repeated annoyances, threats or demands.

IMO a key word here is "repeated".

If anyone feels that they have experienced such treatment on this
newsgroup, please bring it to the attention of the Moderators at their
private email addresses. For more, see the weekly post, "Posting to
misc.invest.financial-plan".

--------------
As usual, please do not respond to this post. Comments on newsgroup
policy should be sent to the Moderators at their private email
address.

Thank you.


-HW "Skip" Weldon
Columbia, SC

  #37  
Old 02-27-2007, 08:52 PM
kastnna
Guest
 
Posts: n/a
Default Re: Portfolio Optimization Software?

Thanks Tad.

  #36  
Old 02-27-2007, 03:12 PM
darkness39@yahoo.com
Guest
 
Posts: n/a
Default Re: Portfolio Optimization Software?

On Feb 23, 4:06 pm, beliav...[at]aol.com wrote:

- quote -

> I have a CFA and PhD in physics, have worked as a derivatives
> professional for about 10 years, and I read the major finance
> journals. I have been posting to this newsgroup for some time, and
> people check my history to determine my credibility. You seem to
> believe there is no expertise in finance other than your own. The
> newsgroup would be much better off without you.


FWIW I enjoy your obvious deep knowledge, insight and analysis.

I've sent you a personal email on this topic (from darkness39 (at)
yahoo (dot) com). You might find it illuminating.

  #35  
Old 02-27-2007, 02:06 PM
beliavsky@aol.com
Guest
 
Posts: n/a
Default Re: Portfolio Optimization Software?

On Feb 20, 5:02 am, sawyervill...[at]gmail.com wrote:
- quote -

> I've finally gotten to the point will I would like to optimize my
> portfolio using MPT.
> I'm looking for some software (preferably free) that would allow me to
> run what/if scenarios.
> Nothing fancy, since I'm planning on investing is ~5 Vanguard Funds
> (Large/Small/International/Growth/Value), but I'm curious what the
> historical performance of various weightings would produce in relation
> to the risk.


> From the web site of the AAII (American Association of Individual

Investors) members can download a program called "Portfolio
Optimization", described as follows:

"Portfolio Optimization uses modern portfolio theory to identify
efficient combinations of stocks and mutual funds with the minimum
level of risk for a specified annual expected portfolio return. It
includes a built-in database with annual returns for the past 10 years
for all stocks in AAII's Stock Investor Pro and all of the mutual
funds in AAII's Quarterly Mutual Fund update. It also plots a graph of
the efficient frontier."

I just played with the software for a few minutes and have some
reservations.

(1) It is a DOS program, which is ok with me, but it crashes when one
specifies a date rate of 2000-2007, since it has data only up to 2006.
That's not how to write a program.
(2) It handles a maximum of 32 securities or mutual funds.
(3) It uses only yearly data.

I am thinking about using portfolio optimization of mutual funds and
ETFs for my own investments. The first hurdle is getting accurate
(adjusted for splits and distributions) daily return data. One can get
daily data for stocks and funds from Yahoo Finance using the Python
programming language using a script at http://rimonbarr.com/repository/pyq/index.html
  #34  
Old 02-27-2007, 09:20 AM
Elle
Guest
 
Posts: n/a
Default Re: Portfolio Optimization Software?

"John Gunn" <noway[at]forgetit.org> wrote
- quote -

> "Elle" <honda.lioness[at]nospam.earthlink.net> wrote
> > "Tad Borek" <borekfm[at]pacbell.net> wrote
> > > Any written communication, including usenet and bulletin
> > > board postings, can be considered "advertising" under
> > > state and federal securities law. This isn't my
> > > opinion --
> > > an auditor told me this. There are very specific
> > > guidelines regarding advertising, and as you might
> > > imagine, "fraud" is a very dirty word in that context.
> > > Nothing stated in this thread constitutes fraudulent

> > advertising. I am sorry you object to my pointing out an
> > inaccuracy in a statement on portfolio optimization.
> > Doing
> > so goes towards educating the public on financial
> > forecasting, just as pointing out that the many mutual
> > fund
> > managers who ostensibly "beat the market" in fact
> > according
> > to studies mostly do not in the future.
> > > The inaccuracy which I pointed out was acknowledged by

> > its
> > poster. He went on to elaborate that his actual
> > literature
> > on his software is more precise. No harm, no foul, on
> > Usenet
> > nor anywhere else. I do enjoy your posts. They're very
> > revealing. :-)
> > > Sadly, Tad is right on.


Do you think fraudulent advertising did take place here?
Because otherwise, your comments are a non sequitur to my
own.

Both of you need to take your objections up with the poster
who acknowledged his original comments were inaccurate, re
appearing to predict the future. Your determination to
ignore this point and try to chill the marketplace of ideas
is striking.

  #33  
Old 02-27-2007, 09:03 AM
John Gunn
Guest
 
Posts: n/a
Default Re: Portfolio Optimization Software?

"Elle" <honda.lioness[at]nospam.earthlink.net> wrote in news:juNEh.4345
$PL.2666[at]newsread4.news.pas.earthlink.net:

- quote -

> "Tad Borek" <borekfm[at]pacbell.net> wrote
> > Any written communication, including usenet and bulletin
> > board postings, can be considered "advertising" under
> > state and federal securities law. This isn't my opinion --
> > an auditor told me this. There are very specific
> > guidelines regarding advertising, and as you might
> > imagine, "fraud" is a very dirty word in that context.

> Nothing stated in this thread constitutes fraudulent
> advertising. I am sorry you object to my pointing out an
> inaccuracy in a statement on portfolio optimization. Doing
> so goes towards educating the public on financial
> forecasting, just as pointing out that the many mutual fund
> managers who ostensibly "beat the market" in fact according
> to studies mostly do not in the future.
> The inaccuracy which I pointed out was acknowledged by its
> poster. He went on to elaborate that his actual literature
> on his software is more precise. No harm, no foul, on Usenet
> nor anywhere else. I do enjoy your posts. They're very
> revealing. :-)


Sadly, Tad is right on. Your posts are ill-informed on the reality of
investmenting and now securites regulation.

  #32  
Old 02-27-2007, 02:23 AM
Elle
Guest
 
Posts: n/a
Default Re: Portfolio Optimization Software?

"Tad Borek" <borekfm[at]pacbell.net> wrote
- quote -

> Any written communication, including usenet and bulletin
> board postings, can be considered "advertising" under
> state and federal securities law. This isn't my opinion --
> an auditor told me this. There are very specific
> guidelines regarding advertising, and as you might
> imagine, "fraud" is a very dirty word in that context.


Nothing stated in this thread constitutes fraudulent
advertising. I am sorry you object to my pointing out an
inaccuracy in a statement on portfolio optimization. Doing
so goes towards educating the public on financial
forecasting, just as pointing out that the many mutual fund
managers who ostensibly "beat the market" in fact according
to studies mostly do not in the future.

The inaccuracy which I pointed out was acknowledged by its
poster. He went on to elaborate that his actual literature
on his software is more precise. No harm, no foul, on Usenet
nor anywhere else. I do enjoy your posts. They're very
revealing. :-)

  #31  
Old 02-27-2007, 01:25 AM
Tad Borek
Guest
 
Posts: n/a
Default Re: Portfolio Optimization Software?

Elle wrote:
- quote -

> For the record, IMO Usenet posts hold virtually no water in
> a court of law as far as "fraud," inter alia, is concerned.


> I am surprised you do not know this.


Hmmm, now an expert on securities law. Let describe the reality so you
understand our point of view.

Any written communication, including usenet and bulletin board postings,
can be considered "advertising" under state and federal securities law.
This isn't my opinion -- an auditor told me this. There are very
specific guidelines regarding advertising, and as you might imagine,
"fraud" is a very dirty word in that context.

You may think this isn't the case, or think it's a bad law, but it's the
way it is. This is why we see no registered representatives
(stockbrokers) posting on MIFP, their broker-dealers generally forbid
it. Us independents can decide for ourselves, and believe me, the
compliance attorneys say "don't take the risk!"

The question isn't whether posting here could cause problems, or whether
one reader could cause problems for us -- it's why any of us would even
bother, once there's a risk.

-Tad

  #30  
Old 02-27-2007, 12:25 AM
Elle
Guest
 
Posts: n/a
Default Re: Portfolio Optimization Software?

"Tad Borek" <borekfm[at]pacbell.net> wrote
- quote -

> I wouldn't dream of talking about what I use, or how I use
> it, lest my comments not meet Elle's capricious standards
> for disclosure, non-solicitation, and heck grammar. One
> phone call to a regulator by a loose-cannon MIFP reader
> and I'm potentially looking at a one-week non-routine
> audit. Why would I bother?


For the record, IMO Usenet posts hold virtually no water in
a court of law as far as "fraud," inter alia, is concerned.
The reason being that this is part of the free marketplace
of ideas. Like all of Usenet, this is a casual forum where
people are not under a legal obligation for perfection in
writing. I would not dream of reporting, using legal
avenues, anyone here. Such a complaint would make a
laughingstock of the complainer. I am surprised you do not
know this.

I am sorry you have such a problem with dissent in a forum
like this. It is in fact vital to the success of commerce
and industry.

I fully support diversity in one's portfolio. I think the
aforementioned portfolio optimization tools (for fee or not)
are far more likely to do good than bad. My objection
remains that their output should not be presented as being
definitely superior in the future.

  #29  
Old 02-27-2007, 12:19 AM
Elle
Guest
 
Posts: n/a
Default Re: Portfolio Optimization Software?

"Tad Borek" <borekfm[at]pacbell.net> wrote
- quote -

> Elle wrote:
> > Just my opinion, but it serves the "financial critical
> > thinking skills" of America etc. well to add an extra
> > qualifying sentence (or words) to posts like your
> > previous one. Otherwise, one could make a perfectly
> > reasonable argument that there's some attempt at fraud
> > (unconscious or otherwise) and seduction here when one
> > uses phrases like "Our company's allocation is more
> > efficient than yours."

> Don't underestimate how much this kind of nonsense --
> accusing a professional poster of fraud in connection with
> securities


See above. That's not what I said.

  #28  
Old 02-26-2007, 11:27 PM
Tad Borek
Guest
 
Posts: n/a
Default Re: Portfolio Optimization Software?

Elle wrote:
- quote -

> Just my opinion, but it serves the "financial critical
> thinking skills" of America etc. well to add an extra
> qualifying sentence (or words) to posts like your previous
> one. Otherwise, one could make a perfectly reasonable
> argument that there's some attempt at fraud (unconscious or
> otherwise) and seduction here when one uses phrases like
> "Our company's allocation is more efficient than yours."



Don't underestimate how much this kind of nonsense -- accusing a
professional poster of fraud in connection with securities -- shuts down
contributions to this newsgroup. At least, contributions from those of
us who actually have access to tools like portfolio optimization software.

I wouldn't dream of talking about what I use, or how I use it, lest my
comments not meet Elle's capricious standards for disclosure,
non-solicitation, and heck grammar. One phone call to a regulator by a
loose-cannon MIFP reader and I'm potentially looking at a one-week
non-routine audit. Why would I bother?

Kastnna, I'm sure plenty of people appreciate your posts...but from
someone else in the biz...consider yourself warned. <sigh
-Tad

  #27  
Old 02-26-2007, 08:28 PM
Elle
Guest
 
Posts: n/a
Default Re: Portfolio Optimization Software?

<beliavsky[at]aol.com> wrote
- quote -

> Even if an ETF has only been around for three years, it
> may have an
> underlying index with a much longer history and an
> underlying asset
> class with an even longer history.


I agree.

Re selling stuff: It's about generating buzz (and IMO not a
few urban legends within that buzz) as much as plugging
one's specific service.

  #26  
Old 02-26-2007, 05:47 PM
beliavsky@aol.com
Guest
 
Posts: n/a
Default Re: Portfolio Optimization Software?

On Feb 23, 3:10 pm, Will Trice <wwtr...[at]paragondynamics.com> wrote:
- quote -

> beliav...[at]aol.com wrote:
> > Forecasting Volatility
> > Financial Markets, Institutions, and Instruments 6 (1), 1997.
> > http://pages.stern.nyu.edu/~sfiglews...Volatility.pdf

> This paper seems to indicate that even simple techniques for forecasting
> volatility are fairly good over sufficiently long periods. Of course,
> that's only one part of the optimization problem. How good are
> forecasts of the correlations between the price movements of different
> assets?
> -Will


Since volatilities are the square roots of the diagonal elements of
the covariance matrix, the simplest approach is to use a single window
and sampling interval to compute the covariance matrix. A good
introduction to estimation methods is Chapter 16 of the book "Modern
Investment Management" by Goldman Sachs Assset Management.

One way to study the goodness of correlation/covariance estimates is
to look at the returns achieved by an optimizer using them as inputs.
The paper below (available by purchase only) tried computing
covariances using 5 years of monthly data and 1 year of daily data.
For long-only portfolios there was not much difference, but for long/
short portfolios daily data looked better.

Minimum-Variance Portfolios in the U.S. Equity Market
Clarke, Roger de Silva, Harindra Thorley, Steven
THE JOURNAL OF PORTFOLIO MANAGEMENT
Fall 2006
In the minimum-variance portfolio, far to the left on the efficient
frontier, security weights are independent of expected security
returns. Portfolios can be constructed using only the estimated
security covariance matrix, without reference to equilibrium expected
or actively forecasted returns. Empirical results illustrate the
practical value of large-scale numerical optimizations using return-
based covariance matrix estimation methodologies, providing new
perspective on the factor characteristics of low-volatility
portfolios. Optimizations that go back to 1968 reveal that the long-
only minimum-variance portfolio has about three-fourths the realized
risk of the capitalization-weighted market portfolio, with higher
average returns.

A working paper by Tal Schwartz at
http://www.departments.bucknell.edu/...27Schwartz.pdf
found good results using 1 year of daily data. The good results may
largely be the result of the 1-year momentum effect, since he
estimates mean returns of stocks using the last year, which I would
not recommend.

These studies look at optimizing a portfolio of stocks rather than
asset classes. Both impose limits on the amount invested in any one
stock, 5% in the latter case.

One can Google "beliavsky realized volatility" in this newsgroup to
find a paper on asset allocation using portfolio optimization and
implemented using futures contracts -- not practical for most people.

  #25  
Old 02-26-2007, 05:37 PM
Michael Siemon
Guest
 
Posts: n/a
Default Re: Portfolio Optimization Software?

In article <1172500877.202041.50410[at]v33g2000cwv.googlegroups.com> ,
"kastnna" <kastnna[at]auburnalum.org> wrote:

- quote -

> Sorry Michael, I did a pretty poor job of clarifying myself above. I
> worded it pretty poorly.
> FWIW, we can plug in as many or as few asset/indexes as we choose. The
> asset mix we use to simulate an efficient frontier consists of a bunch
> of ETFs that attempt to approach the market portfolio as close as
> possible. As you implied, the difficult part is generating a perfectly
> efficient frontier that actually has a tangency to the market
> portfolio. I an almost certain that our frontier is not 100%
> efficient. What we have found to date, is that no one has brought us a
> portfolio that is any closer. ...


Sure; that's entirely reasonable. My suggestion was that Bernstein,
despite some hyperbolic criticism of MVO tools in his book, supports
this same kind of approach -- his website, after all, is named
"efficient frontier", and stuff on it seems to me to imply that his
consultancy operations work analogously to what you describe above.

  #24  
Old 02-26-2007, 05:10 PM
beliavsky@aol.com
Guest
 
Posts: n/a
Default Re: Portfolio Optimization Software?

On Feb 26, 12:07 pm, "Elle" <honda.lion...[at]nospam.earthlink.netwrote:

<snip
- quote -

> You're welcome in advance, because I think there is no doubt
> that one's sales pitch is enhanced by speaking as though
> past performance represents the future. It's so easily
> corrected, grammatically, and it's so important, that I
> personally find no excuse for not using the right language.
> 'specially when you're talking about, what, three years of
> ETF data? People have to make a living, and I do support
> diversification, but this newsgroup is about a lot more than
> people selling their products.- Hide quoted text -


Even if an ETF has only been around for three years, it may have an
underlying index with a much longer history and an underlying asset
class with an even longer history. Most ETFs have tracked their
indices pretty closely -- this has been studied. I am sure the
software uses index and asset class data for its historical studies.
As usual you don't know what you are talking about.

If kastnna is trying to sell his products on this newsgroup, he is not
trying very hard. I don't know what his real name is, and there is
nothing in his signature mentioning his company (there would be
nothing wrong with mentioning this). Instead of trying to censor
others, censor yourself!

  #23  
Old 02-26-2007, 04:07 PM
Elle
Guest
 
Posts: n/a
Default Re: Portfolio Optimization Software?

"kastnna" <kastnna[at]auburnalum.org> wrote
- quote -

> I don't intend to mislead the noobs and I don't think they
> can be to
> any serious extent. Even if they become convinced that I
> (or someone
> else) "have all the answers" they are never going to not
> run into the
> necessary disclaimers at some point in the process. If
> they somehow
> managed to track me down, the first thing they would hear
> would be
> "you know there is no guarantee of future performance..."
> I don't end
> every verbal sentence with a disclaimer either when
> talking with
> clients, but before we make any meaningful progress the
> disclaimers
> are well understood.


You don't even need the disclaimer. You need only state that
this is what history has shown.

- quote -

> Long story short its caveat emptor, and "you get what you
> pay for." If
> you like you can attach a disclaimer for me everytime I
> post. I'll say
> "thanks" now in advance.
> FYI, by definition fraud cannot be "unconscious". The very
> basis for
> fraud is intent. Careful tossin' that word around.


The very basis for _illegal fraud_ is xyz, "intent" can be
nebulous, it depends on the state, and so forth. My meaning
was meant more casually.

You're welcome in advance, because I think there is no doubt
that one's sales pitch is enhanced by speaking as though
past performance represents the future. It's so easily
corrected, grammatically, and it's so important, that I
personally find no excuse for not using the right language.

'specially when you're talking about, what, three years of
ETF data? People have to make a living, and I do support
diversification, but this newsgroup is about a lot more than
people selling their products.

  #22  
Old 02-26-2007, 03:12 PM
kastnna
Guest
 
Posts: n/a
Default Re: Portfolio Optimization Software?

On Feb 26, 9:35 am, "Elle" <honda.lion...[at]nospam.earthlink.net> wrote:
- quote -

> Words are everything. Newbies overwhelmingly frequent this
> group.
> Just my opinion, but it serves the "financial critical
> thinking skills" of America etc. well to add an extra
> qualifying sentence (or words) to posts like your previous
> one. Otherwise, one could make a perfectly reasonable
> argument that there's some attempt at fraud (unconscious or
> otherwise) and seduction here when one uses phrases like
> "Our company's allocation is more efficient than yours."


I don't intend to mislead the noobs and I don't think they can be to
any serious extent. Even if they become convinced that I (or someone
else) "have all the answers" they are never going to not run into the
necessary disclaimers at some point in the process. If they somehow
managed to track me down, the first thing they would hear would be
"you know there is no guarantee of future performance..." I don't end
every verbal sentence with a disclaimer either when talking with
clients, but before we make any meaningful progress the disclaimers
are well understood.

Long story short its caveat emptor, and "you get what you pay for." If
you like you can attach a disclaimer for me everytime I post. I'll say
"thanks" now in advance.

FYI, by definition fraud cannot be "unconscious". The very basis for
fraud is intent. Careful tossin' that word around.

  #21  
Old 02-26-2007, 02:48 PM
kastnna
Guest
 
Posts: n/a
Default Re: Portfolio Optimization Software?

On Feb 26, 9:01 am, beliav...[at]aol.com wrote:
- quote -

> How confident are you that the efficient portfolios you generate for
> clients
> do better, AFTER they are constructed, than the portfolios clients
> come in with?
> Have you studied the level of outerpformance, in terms of Sharpe
> ratios?


Somewhat. We do "look back" to compare performance after the
portfolios are constructed. The software is only used for fee-based
clients. These clients get quarterly reviews that cover performance,
rebalancing, AND the performance of their old portfolio had they kept
it. It reassures clients to see what would have happened had they not
changed their portfolio. The company that developed the software,
fiserv, does most of the legwork for us. We get a wealth of
performance data against numerous benchmarks. Among others, actual
return and standard dev. are given so that we can do sharpe ratios.

We do not perform sharpes on ALL clients because many had portfolios
that were so poorly constructed there is no question. Many
underperformed us AND had higher Std Dev.

The clients that had fairly well constructed portfolios to begin with
tend to be our "more demanding" clients by virtue of being more
educated. We usually do sharpe ratio values with them during their
review. We are confident so far, but remember we have only been using
the software for three years and many of the ETFs we use aren't very
old either.

  #20  
Old 02-26-2007, 02:35 PM
Elle
Guest
 
Posts: n/a
Default Re: Portfolio Optimization Software?

"kastnna" <kastnna[at]auburnalum.org> wrote
- quote -

> We attach our lovely little "based on historical data"
> disclaimers on everything necessary in our office. For the
> sake of
> brevity I leave it off on a non-regulated usegroup.


Words are everything. Newbies overwhelmingly frequent this
group.

Just my opinion, but it serves the "financial critical
thinking skills" of America etc. well to add an extra
qualifying sentence (or words) to posts like your previous
one. Otherwise, one could make a perfectly reasonable
argument that there's some attempt at fraud (unconscious or
otherwise) and seduction here when one uses phrases like
"Our company's allocation is more efficient than yours."

  #19  
Old 02-26-2007, 02:21 PM
kastnna
Guest
 
Posts: n/a
Default Re: Portfolio Optimization Software?

On Feb 26, 9:02 am, "Elle" <honda.lion...[at]nospam.earthlink.net> wrote:
Sorry Elle. We attach our lovely little "based on historical data"
disclaimers on everything necessary in our office. For the sake of
brevity I leave it off on a non-regulated usegroup.

If the readers here honestly believe that I can accurately predict the
future and/or have software that can assure outpreformance then they
have much bigger problems than can be addressed in this group.

 

Tags
optimization, portfolio, software
Similar Threads
Thread Forum Replies Last Post
Best Software for Portfolio Tracking
JeffWeiss9: I've used MSN Portfolio for tracking and charting my portfolio for a number of years but am confused whether Microsoft is still supporting this free...
Microsoft Money 5 08-22-2008 01:47 PM
Novice seeking a portfolio tracker website that shows asset classes for total portfolio
ichiban: Can anybody advise me of a site on the web where I can find an easy to use portfolio tracker that not only shows the daily values / graphs of...
Financial Planning 2 08-19-2006 08:58 AM
Money 2005 Bug: Portfolio toolbar button loads blank page titled Portfolio Manager
Frank: Problem Description: Clicking on the Portfolio toolbar button loads a blank page that's titled Portfolio Manager. That's it! I can't see any of my...
Microsoft Money 2 10-08-2004 02:04 AM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 04:22 AM.