Join today and have your say! It’s FREE!

Become a member today, It's free!

We will not release or resell your information to third parties without your permission.
Please Try Again
{{ error }}
By providing my email, I consent to receiving investment related electronic messages from Stockhouse.

or

Sign In

Please Try Again
{{ error }}
Password Hint : {{passwordHint}}
Forgot Password?

or

Please Try Again {{ error }}

Send my password

SUCCESS
An email was sent with password retrieval instructions. Please go to the link in the email message to retrieve your password.

Become a member today, It's free!

We will not release or resell your information to third parties without your permission.
Quote  |  Bullboard  |  News  |  Opinion  |  Profile  |  Peers  |  Filings  |  Financials  |  Options  |  Price History  |  Ratios  |  Ownership  |  Insiders  |  Valuation

Yellow Media Inc T.YLO



TSX:YLO - Post by User

Bullboard Posts
Comment by markvrdon Sep 08, 2011 2:16pm
206 Views
Post# 19023339

tips on using SEDI data

tips on using SEDI dataSEDI has full historical detail back as long as you want.   The detailed transaction reports are easy to cut and paste from your browser in Excel.   From there you can run any calculations you want easily.   Note that each buyback transaction is paired with a cancel transaction.   One is positive, the other negative.   You need to filter out the negatives using the Excel SUMIF function ....

i.e. rather than just summing a column like this: SUM(J99:J197)

you need to type something like this for the excel formula:
SUMIF(J99:J197|">0"|J99:J197)

Once you learn how to use SEDI, it's a very useful and free tool.

For other types of insider transactions, you can use the final column on the right for cumulative totals.   However, for this type, that column balances off to zero because of the pairing of buys with corresponding cancels.


It would be nice if the company just posted this info in a nice summary on their website... maybe a request for IR :-)

Mark
Bullboard Posts
USER FEEDBACK SURVEY ×

Be the voice that helps shape the content on site!

At Stockhouse, we’re committed to delivering content that matters to you. Your insights are key in shaping our strategy. Take a few minutes to share your feedback and help influence what you see on our site!

The Market Online in partnership with Stockhouse