Cookie Policy: This web site uses cookies. By using this site you agree to our cookie policy.
Disclaimer: By posting on this web site it is accepted that you have agreed to the T&C. This is an information forum, and it is just that information, all views are of the individual poster and not that of the site owner. Please DO NOT publish copyrighted material without the owners permission. If you copy news or articles include a link back to the original site. Threads/Posts may be deleted on request. No other links without permission.
BEFORE POSTING A QUESTION: Your question has probably been asked before, so please use the
SEARCH FUNCTION, as we grow tired of answering the same question again and again.
Results 1 to 5 of 5

Thread: Sound alerts in excel?

  1. #1
    wb's Avatar
    wb is offline Win2Win Racing Club Member

    Join Date
    Apr 2005
    Location
    Éire
    Posts
    7,347
    Rep Power
    80

    Sound alerts in excel?

    Hi all Haven't been around these parts in a while - hope you all are well

    Mat will be proud of me as I've progressed a little in excel since the last time I used to come on here bugging him with questions!

    Anyhow, I'm just wondering if sound alerts can be added to excel, perhaps under conditional formatting?

    I have a spreadsheet for trading which tracks the live Betfair prices through Betting Assistant. The basis of the strategy is that if the price moves by a certain %, it becomes a back or a lay. At the moment, I have the boxes changing to blue or pink when the price moves a certain distance, and this colour change indicates that the horse should be backed or layed for trading purposes:

    http://3.bp.blogspot.com/-6J3WX_fNPc...preadsheet.jpg

    I done this using conditional formatting and it's working well at alerting me when there is a price move. However, it would be handy if I could get sound alerts as that would free me up to do other things instead of staring at the screen, waiting on the colour to change.

    Tada gan iarracht


  2. #2

    Join Date
    Feb 2002
    Location
    N Wales
    Posts
    50,310
    Rep Power
    275
    Put at the very start of the code
    Code:
      
    Private Declare Function sndPlaySound32 Lib "winmm.dll" _
    Alias "sndPlaySoundA" (ByVal lpszSoundName _
    As String, ByVal uFlags As Long) As Long
    Then when you want to use sound
    PHP Code:
    Call sndPlaySound32("C:\Program Files\Optic Limited\Bet Angel - Professional\sounds\sound109.wav"1
    Replacing the directory & WAV name with whatever you use.

    FREE Live Odds Comparison Software

    Keith Driscoll - Administrator
    Managing Director, Win2Win Limited



    Filipino UK Filipino Forum | Win2Win Racing - Free Tips


  3. #3

    Join Date
    Feb 2002
    Location
    N Wales
    Posts
    50,310
    Rep Power
    275
    How are the horses going?

    FREE Live Odds Comparison Software

    Keith Driscoll - Administrator
    Managing Director, Win2Win Limited



    Filipino UK Filipino Forum | Win2Win Racing - Free Tips


  4. #4
    wb's Avatar
    wb is offline Win2Win Racing Club Member

    Join Date
    Apr 2005
    Location
    Éire
    Posts
    7,347
    Rep Power
    80
    Will try that - thanks Keith - horses going good, not doing as much punting these days, mainly trading now.

    Tada gan iarracht


  5. #5
    wb's Avatar
    wb is offline Win2Win Racing Club Member

    Join Date
    Apr 2005
    Location
    Éire
    Posts
    7,347
    Rep Power
    80
    Hi all, hope you are well.

    Another excel one...

    Trying to work out longest sequences of winners and losers.

    I have a column which simply says 'Won' or 'Lost' depending on whether the bet was a winner or loser.

    Is there any way for Excel to count longest winning sequences and longest losing sequences? i.e. I need it to figure out what was my biggest number of winners in a row was, likewise, losers. Obviously, I need it to update itself as I add to the column.

    Thanks!

    Tada gan iarracht


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. No sound
    By vegyjones in forum PC Help/Advice - 100% FREE
    Replies: 2
    Last Post: 12th August 2007, 22:39
  2. No sound in browser
    By mathare in forum PC Help/Advice - 100% FREE
    Replies: 10
    Last Post: 19th January 2007, 13:55
  3. Sound
    By Micky T in forum PC Help/Advice - 100% FREE
    Replies: 0
    Last Post: 28th June 2006, 15:43
  4. no sound
    By silax in forum PC Help/Advice - 100% FREE
    Replies: 4
    Last Post: 26th December 2004, 09:54
  5. No sound...help!!!
    By simonkarios in forum PC Help/Advice - 100% FREE
    Replies: 24
    Last Post: 23rd August 2004, 16:53

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Free Tips | Betting Advice | UK Horse Racing Tips | Free Bets | Staking Advice | Horse Racing Systems | Horse Racing Lays | Laying System | UK Horse Racing Tips | lay betting