Join Now or Login or connect with

Trading Software Trading objects Features Blog Search

Dividend comments

by The trader, 367 days ago
Share |

Get dividends information for US companies. The data is parsed from an RSS feed and is inserted into a database whose name is 'dividends_rss'. This database has a date and a title column. The title generally contains useful information about the dividend being paid by the company. It also usually contains the dividend amount.

This amount could be extracted using regular expressions. In Pre-Scripting you can add the formula described below to extract this dividend value. You also need to create a new numeric field in this dividend database, so that the extracted value will be associated to the newly created field.

Go to the 'database editor', select the 'dividends_rss' database then create a new numeric (double) field. Update the current downloader item, select the first URL (there is only one URL) and click on 'Settings'. In the new form, click on 'Next', create a new column, assign it to the new field then click on 'Pre-Script'. Add the following formula inside the loop, then assign the variable 'dividendValue' to 'Content.Rows[i].Data[index] ' where index is the column index of the newly created field.

var match : System.Text.RegularExpressions.Match = System.Text.RegularExpressions.Regex.Match(Content.Rows[i].Data[1], '[$]([0-9|.])+');
var dividendValue : String = match.Value.ToString().Replace('$', '');

Example of dividends comments:
28/07/2009 11:42 - Cherokee (CHKE) Maintains $0.50 Qtr. Distribution, Yielding 10.29%
28/07/2009 11:42 - Wyndham Worldwide (WYN) Approves Qtr. Dividend of $0.04, Yielding 1.27%

If you had applied the regular expression formula, the extract dividend values would be: 0.50 for the first row and 0.04 for the second one.


Share This ->
Share |


You have to log in to bookmark this object
What is this?





Related Trading Objects



Country
Page 1
BAA Corporate Bond Yield Forecast
by Patrick Fonce, uploaded several months ago
No notes

Rate an item Rate an item Rate an item Rate an item Rate an item Number of downloads 1 Notes Report an item
Covered Call Strategy Indices - Dow DJI..
by Tom Huggens, uploaded several months ago
No notes

Rate an item Rate an item Rate an item Rate an item Rate an item Number of downloads 1 Notes Report an item
Options Market - Trading volume data pe..
by Patrick Fonce, uploaded several months ago
No notes

Rate an item Rate an item Rate an item Rate an item Rate an item Number of downloads 1 Notes Report an item
Number of reviews
Click to add a review
Average rate
Click to rate this item
Number of times this object was downloaded
Number of rates the current object received
Report an object
if you can't run it for example or if it contains errors
Click to report this object






Market
Page 1
Fibonacci Trading Indicator - Support a..
by QuantShare, uploaded today
No notes

Rate an item Rate an item Rate an item Rate an item Rate an item Number of downloads 0 Notes Report an item
Fibonacci Trading with the Retracement ..
by QuantShare, uploaded yesterday
No notes

Rate an item Rate an item Rate an item Rate an item Rate an item Number of downloads 0 Notes Report an item
Williams AD - Accumulation Distribution..
by QuantShare, uploaded one week ago
No notes

Rate an item Rate an item Rate an item Rate an item Rate an item Number of downloads 1 Notes Report an item
Number of reviews
Click to add a review
Average rate
Click to rate this item
Number of times this object was downloaded
Number of rates the current object received
Report an object
if you can't run it for example or if it contains errors
Click to report this object






Style
Page 1
Fibonacci Trading Indicator - Support a..
by QuantShare, uploaded today
No notes

Rate an item Rate an item Rate an item Rate an item Rate an item Number of downloads 0 Notes Report an item
Fibonacci Trading with the Retracement ..
by QuantShare, uploaded yesterday
No notes

Rate an item Rate an item Rate an item Rate an item Rate an item Number of downloads 0 Notes Report an item
Williams AD - Accumulation Distribution..
by QuantShare, uploaded one week ago
No notes

Rate an item Rate an item Rate an item Rate an item Rate an item Number of downloads 1 Notes Report an item
Number of reviews
Click to add a review
Average rate
Click to rate this item
Number of times this object was downloaded
Number of rates the current object received
Report an object
if you can't run it for example or if it contains errors
Click to report this object






Reviews
You must log in first

Join now
and get instant access for free to the trading software, the Sharing server and the Social network website.
Click here


Related objects
Show All
News data for US companies from Google RSS feed (by The trader, uploaded several months ago)
No notes

Rate an item Rate an item Rate an item Rate an item Rate an item Number of downloads 9 Notes Report an item
Financial fundamental data for US companies (by Patrick Fonce, uploaded several months ago)
No notes

Rate an item Rate an item Rate an item Rate an item Rate an item Number of downloads 22 Notes Report an item
Analyst downgrades & upgrades (by Patrick Fonce, uploaded several months ago)
No notes

Rate an item Rate an item Rate an item Rate an item Rate an item Number of downloads 12 Notes Report an item
Recent mergers and acquisitions (by Patrick Fonce, uploaded several months ago)
No notes

Rate an item Rate an item Rate an item Rate an item Rate an item Number of downloads 6 Notes Report an item
Media sentiment alerts (by The trader, uploaded several months ago)
No notes

Rate an item Rate an item Rate an item Rate an item Rate an item Number of downloads 6 Notes Report an item
Earnings database (by Patrick Fonce, uploaded several months ago)
No notes

Rate an item Rate an item Rate an item Rate an item Rate an item Number of downloads 8 Notes Report an item
Valuation ratios for US stocks (by Patrick Fonce, uploaded several months ago)
No notes

Rate an item Rate an item Rate an item Rate an item Rate an item Number of downloads 14 Notes Report an item
Number of reviews
Click to add a review
Average rate
Click to rate this item
Number of times this object was downloaded
Number of rates the current object received
Report an object
if you can't run it for example or if it contains errors
Click to report this object

Technical Analysis


Fundamental Analysis


Random Objects

  3 0 0 - Sales, Growth and Estimates
  3 0 0 - Kuwait Stock Exchange
  4 0 0 - Covered Call Screener
  3 0 0 - Yale - Valuation Confidence Index
  5 0 0 - M2 money supply
  1 0 0 - Standard Error Bands
 18 0 0 - China stock market
  5 0 0 - The Best trading rules for the ADX technical indicator
  5 0 0 - Donchian Channels
  1 0 0 - calcA
More trading objects...


Recent Posts

Pivot Tables in QuantShare Trading Software
Posted 9 days ago

How to create market indicators using the composite function - Part 1
Posted 17 days ago

Optimize a trading strategy using the Sharpe ratio
Posted 24 days ago

How to create a trading indicator that uses stock news
Posted 31 days ago

How to create your own technical analysis indicators
Posted 38 days ago

Show All

Number of reviews
Click to add a review
Average rate
Click to rate this item
Number of times this object was downloaded
Number of rates the current object received
Report an object
if you can't run it for example or if it contains errors
Click to report this object


contactus
About | Privacy | Terms of Use | Manual
Copyright © 2010 QUANTSHARE.COM