Tag Archives: stock market

Twitter Updates for 2009-08-14

  • RT @mktbot From 10 Aug $CXN:ASX ConnXion Limited is $CXN:ASX ConnXion Ventures Limited http://is.gd/2gBot #
  • RT @mktbot From 12 Aug $ETC:ASX Entertainment Media #
  • RT @mktbot From 12 Aug $ETC:ASX Entertainment Media & Telecoms Corp.Ltd is $NBS:ASX Nexbis Limited http://is.gd/2gB5m #
  • RT @mktbot As of 14 Aug $GLI:ASX GoldLink IncomePlus Limited is now $BIV:ASX Blue Capital Limited http://is.gd/2gAeb #
  • ASX-listed Companies price sensitive announcements 14Aug $ACX $AGS $AVJ $AVO $BAR $BAU $BEL $BIV $BPT $BSR $CAB $CDI http://bit.ly/6LMUV #
  • ASX-listed Companies price sensitive announcements 14Aug $CER $CGM $CKK $CNP $CNX $CRE $CUE $CWN $CXU $DCG $DDT $DEG http://bit.ly/6LMUV #
  • ASX-listed Companies price sensitive announcements 14Aug $DGO $DIO $DLS $DMX $EMG $FNT $FUN $GCG $GCR $GMG $GPG $GRT http://bit.ly/6LMUV #
  • ASX-listed Companies price sensitive announcements 14Aug $GXY $HAW $HAZ $ICN $IDG $IEF $IGR $LEI $LKO $LLC $LLP $LML http://bit.ly/6LMUV #
  • ASX-listed Companies price sensitive announcements 14Aug $MAE $MAH $MAP $MCP $MCR $MEO $MMA $MOC $MPA $MSR $MTU $NEM http://bit.ly/6LMUV #
  • ASX-listed Companies price sensitive announcements 14Aug $ODG $ORG $OTI $PDM $PMP $PRV $PTN $PXS $RAU $RHD $RHM $ROG http://bit.ly/6LMUV #
  • ASX-listed Companies price sensitive announcements 14Aug $SEG $STU $SYM $TCQ $TGX $VBA $WCN $WHN $WOT http://bit.ly/6LMUV #
  • ASX-listed Companies announcements 14Aug $ABM $ACK $ACZ $ADA $AGO $AGX $AHC $AIB $AIO $AIQ $ALF $ALK $ALR $AMP $AMU http://bit.ly/6LMUV #
  • ASX-listed Companies announcements 14Aug $AMX $ANZ $AOD $AQP $ARO $ARU $ASP $ATJ $AUP $AUZ $AVG $AVJ $AVO $AXY $BBG http://bit.ly/6LMUV #
  • ASX-listed Companies announcements 14Aug $BBI $BCS $BIV $BKN $BLP $BMN $BPH $BPT $BUL $BWN $CAM $CBA $CDI $CDM $CEY http://bit.ly/6LMUV #
  • ASX-listed Companies announcements 14Aug $CHN $CLO $CSJ $CSR $CSU $CSW $CTW $CUE $CXM $CYA $DBS $DCG $DIO $DLS $DUE http://bit.ly/6LMUV #
  • ASX-listed Companies announcements 14Aug $ECE $EHL $EMA $EMR $EON $ERC $ESG $ESN $EVE $FAC $FAS $FAT $FMG $FND $FPH http://bit.ly/6LMUV #
  • ASX-listed Companies announcements 14Aug $FUN $GIP $GMG $GMI $GRT $GUD $HAP $HAW $HAZ $HDN $HHV $HHY $HJB $HLS $HRL http://bit.ly/6LMUV #
  • ASX-listed Companies announcements 14Aug $HSN $HZN $IBC $IDG $IFL $IMA $IMD $IMU $INE $JVG $KAT $KIL $KNH $LBY $LEP http://bit.ly/6LMUV #
  • ASX-listed Companies announcements 14Aug $LLC $LLP $LML $LUM $MAK $MAP $MBL $MBN $MCK $MCL $MCP $MCW $MGO $MIF $MLE http://bit.ly/6LMUV #
  • ASX-listed Companies announcements 14Aug $MMR $MMS $MMX $MPJ $MPS $MQG $MRI $MSO $MTH $MWG $MXQ $NEU $NGE $NHC $NSP http://bit.ly/6LMUV #
  • ASX-listed Companies announcements 14Aug $NVT $OLH $OMI $ONC $ORC $ORN $PBA $PBB $PHG $PMH $PMP $PRG $PRV $PTN $PTR http://bit.ly/6LMUV #
  • ASX-listed Companies announcements 14Aug $PXS $QBE $QGM $QMN $QPN $RHD $RMS $ROG $ROY $SAK $SBS $SFY $SHX $SLF $SLV http://bit.ly/6LMUV #
  • ASX-listed Companies announcements 14Aug $SNB $SPI $SRE $SSS $STE $STO $STW $STX $SUL $SYG $SYL $SYM $SYS $TEN $TES http://bit.ly/6LMUV #
  • ASX-listed Companies announcements 14Aug $TGG $TLS $TOD $TON $TOV $TRS $TSF $TWD $TXN $TYS $UBS $UNX $UOS $URL $VBP http://bit.ly/6LMUV #
  • ASX-listed Companies announcements 14Aug $VIL $VMT $VTP $VXR $WAA $WAM $WAS $WBC $WDC $WHC $WHF $WHN $WIL $WME $WOT http://bit.ly/6LMUV #
  • ASX-listed Companies announcements 14Aug $XEN http://bit.ly/6LMUV #

Powered by Twitter Tools.

Calculate the Beta Coefficient of a stock

Beta CoefficientAs part of the Corporate Finance subject of my MBA we have to calculate the beta coefficient (aka Beta) of a company’s share price. The is applied economics and market mathematics, but it simply is a number which indicates how closely (or not) a company’s share price moves in relation to a broader market (or an index like the S&P ASX200 or the Dow Jones Industrial Average).

Anyway, part of the process is to create an excel format spreadsheet to aid with the calculation. I’ve done it and thought I share it with you. It will work with any spreadsheet program that can open .xls files

Update 1: 31 July 2009 the new version is available for testing by requesting it in a comment below. Once the testing is complete I’ll make it freely available to registered users.

Update 2: 7 July 2011 For a limited time you can get the Beta Coefficient Calculator without registering. Enter a valid email address in this form to receive a link to download the file. You’ll also get an email about new versions and bug fixes (with an opt-out link).

Update 3: 23 July 2011 If the form doesn’t work for you, please comment below and I’ll email it to you. The form is quicker but some people can’t get the download.

Enter your email address to download Beta Coefficient Calculator by Wealth Esteem

Version 0.9 beta_8
* Enabled automatic download via web form
* Added French and German to Translation tab (alpha code there)

Version 0.9 beta_7
* Fixed bug in date text description
* Updated sample data to 6 Jun 2011
* Changed sample data to BHP Billiton
* Made Instructions tab text translatable
* Cosmetic fixes

Version 0.9 beta_6
* Explained Translation tab in instructions and asked for volunteers
* Updated sample data to 2011
* Updated copyright date to 2011

Version 0.9 beta_5
* Added Change Log tab
* Moved text of index symbol & stock symbol to translation tab

Version 0.9 beta_4
* Added explanation of index and stock symbol fields on Beta Coefficient tab
* Updated copyright date to 2010

Version 0.9 beta_3
* Added email address to instructions tab

Version 0.9 beta_2
* Added logic to translate number of periods to a date range and show that range to users in Beta Coefficient tab at C11
* Swapped order of Security and Index tabs
* Fixed bug in coefficient calculation
* Introduced version numbering and control

Version 0.9 beta_1
* Updated instructions tab

Version 0.9 beta
* Initial public version

Support and feedback via the comments below.