Per chi si intende di fogli di calcolo, Ho trovato un programma per selezionare e raccogliere le PF dal sito di QOL funziona su PC con windows
non ho potuto testarlo perche ho un Mac
Preferred Stock Search Application | Free software downloads at SourceForge.net
The Preferred Stock Search, i.e., "PreferredSearch"
License: BSD (see LICENSE.txt)
Version: 0.67 Beta
WHO:
Lead Developer: Michael Truog (mjtruog [at] gmail [dot] com)
WHAT:
PreferredSearch is an application meant to simplify the evaluation of a group
of preferred stocks. It can be used to compare yields and ratings using
recent price information.
WHERE:
Preferred Stock Search Application | Free software downloads at SourceForge.net
WHEN:
Have a look at CHANGELOG.txt
WHY:
Currently, the data on preferred stocks is rather limited and scattered.
Except for one web site, (with a rather obscene yearly fee... epreferreds.com)
there is no good way to evaluate preferred stocks without building your own
spreadsheet from data you manually collect. This application provides
an efficient alternative that can help you collect the necessary data
automatically by extracting the information from the relevant web sites.
REQUIREMENTS:
You must have a login username and password from QuantumOnline.com to
update the preferred stock database.
The source requires Qt == 3.3, PyQt == 3.14.1, pyparsing >= 1.3.3,
pycurl >= 7.13.2, pysqlite >= 2.0.4 and Python >= 2.4 to work properly. This
application has been tested on Windows 2000, SUSE Linux 9.3 64 bit, and
Ubuntu Feisty Fawn 64 bit.
You may also increase the speed of updating the database by using
psyco >= 1.4 when the application is compiled (the precompiled windows
version was compiled with psyco). Psyco is only available for 32 bit systems
currently.
IMPORTANT:
If you use this application often, please donate to QuantumOnline.com. They
are the only reason this preferred stock data is available for free.
Use this data at your own risk. There is no guarentee of accuracy attached to
this data. The data's accuracy mainly depends on the accuracy of the
data maintained on QuantumOnline.com and Yahoo.com. Prices and yields may
be inaccurate and should be checked.
Note that ex-dividend dates can often be off by a day or so. Currently,
the ex-dividend date is expected to follow the rule on the NYSE, where
it is two business days before the distribution date. Holidays
are accounted for now (so that may offset the ex-dividend date by 1 day).
However, companies often have deviated from this two day rule.
So please, double check the ex-dividend date.
INSTRUCTIONS:
VIEWING PREFERRED STOCKS
You may view all available preferred stock information held in the
database by selecting Edit->Show All Stocks.
You may also view stocks by entering their stock ticker symbol after selecting
Edit->Add Stock(s). The stock ticker symbols must be in the format used
by QuantumOnline.com (which does differ from Yahoo.com and other
financial web sites, please refer to
Preferred Ticker Symbols and Names - QuantumOnline.com for more information).
The rules for converting a Yahoo.com ticker symbol to a QuantumOnline.com
ticker symbol are below:
remove ".OB" or ".PK" from the end of the ticker symbol
substitute "-" without a following "P" with "."
substitute "-P" with "-"
UPDATING THE DATABASE
In the lower left of the main window the time of the last update to the
preferred stock database is shown. This can be used to determine if the
preferred stock database should be updated. To update the database
select Edit->Update Database.
The first time you update the database you will need to enter your
username and password you received from your registration at QuantumOnline.com.
Future database updates will not require you to login.
EDITING SUSPENSION DATES
Suspension dates can be entered (since they are not consistently available
through QuantumOnline) so that a hypothetical price and yield might be
more accurate for suspended cumulative preferred stocks. The hypothetical
price is the current dividend owned (a percentage of the next dividend
received) and the dividends due (if the preferred stock is currently
suspended, is cumulative, and has a valid suspension date) subtracted from
the last price. The hypothetical price is then used for the hypothetical
yield.
SAVING A LIST OF PREFERRED STOCKS
There is the option to save preferred stock information for those preferred
stock that you highlight within the main window. To do this, select
File->Save. This will produce a comma delimited file that is easily
imported to Microsoft Excel or Open Office.
SORTING CRITERIA
You may sort by any of the columns listed in the main window. The way ratings
are sorted can be selected by View->Rating Sort. You have the choice of using
the S & P Ratings, Moody Ratings, or an average of both. You are also
able to move columns if you need to for a better view. Just drag the column
heading to the left or right to move it.
FEEDBACK:
Please send me your suggestions for improvements to this program.