Issues with 'company_desc' object/database

Issues with 'company_desc' object/database

Peter Gum
2011-01-22 16:26:56

This database has developed some issues:
- rather than replacing or updating information for a symbol the database is carrying multiple entries per symbol.
- columns are misaligned in some cases, with sector name showing in the fiscal_yr_end column in the latest update for example.
- the 'optionable' flag is inaccurate in many cases (and different from prior entries in many cases).

This has been a most useful object (Object id: 487) up to this point.

(This may not be the right place to post about this but I don't see another place that is appropriate.
A forum or support context would seem more appropriate than a private contact or misusing the review capability?)

~Pete

QuantShare
2011-01-23 12:13:51

It does work for me. To see the downloaded data and how it is parsed, select the item then click on "Update". Click on the "Parser" button.

Please note also that this item was updated 19 days ago. Download the new version and see if it works for you.

Peter Gum
2011-01-23 12:41:53

I have sent snips to support that illustrate the situation. ~Pete

QuantShare
2011-01-23 12:45:16

In the fourth try, the data was downloaded but not in the right order. I have sent a message to the trading object owner asking if he can fix this.

Note that this item do no replace or update information. For each download, it adds, to the database, an entry (market, industry, optional...) that corresponds to the download date.

Peter Gum
2011-01-26 07:53:50

I thank you for your support (off list) on this. After exchanges with support I re-installed the object and the problem seems to be cured.
(It remains a curiosity why the object retains multiple entries per symbol in the database as opposed to updating/replacing existing entries?)
~Pete

QuantShare
2011-01-26 09:10:52

Best Answer

This has to do with the parser settings. (Data is associated with today date - The fundamental data could change over time)

You can make it add only one entry:
- Update the item
- Click on "Parser", select the first item then click on "OK".
- Click on "Next" then "PreScript"
- Add the following code: date = "01-01-2011"; after the first line (string date = DateTime.Now.ToString...)

Get more messages

No more messages

Back


Trading Items Potential Issues and Errors in Historical Data Advance-Decline-Unchanged issues for NYSE, AMEX and NASDAQ Advance Stocks & Volume - Stock that advanced with a volume incre... Trading System with Sharpe-Based Ranking Double / Triple Smoothened EMA with Flexible Alpha	How-to Lessons How to use QuantShare with Metastock data How to associate an index with a list of stocks How to create a chart with a black background How to screen for stocks having a high correlation with the Dow J... How to speed up watchlist and screener plug-ins when working with...
Related Forum Threads Issues with indicators on backtesting (CCI) Basic features and some issues with the background Futures data - overwrites stock symbols, issues with point value Custom Drawing tool Trendline does not end with second click Trailing Stop With Condition	Blog Posts Working with the formula editor How to Optimize a Trading System with Thousands of Billions of Co... Long Term Trading with Technical Analysis Trading Forex with the commitments of traders report Display several stock market charts with one click