converting price data to sound or charts to sounds

[SoesWasBetter]

Did this for ES almost 20 years ago using IB and excel

old news. beep beep. boop.

 

[jonahern]

You could assign the bid a tone and the ask a different tone, and just have it play with a gradient on the price axis. It would be another representation of price besides a visual image. I haven't seen any software do this yet.

If price is on the bid, tone persists, as size dwindles tone drops off and as size is added tone picks up. The ask would have a totally different assigned tone and same drop off and pick ups. Every trade at the bid or ask would just be a beat of that tone.

I'm interested in figuring out how to program something similar

 

[jonahern]

http://www.pricesquawk.com/

way overpriced imo

 

[jonahern]

Did this for ES almost 20 years ago using IB and excel

old news. beep beep. boop.

have a spreadsheet you can share?

 

[Spectre2007]

https://www.extendoffice.com/documents/excel/4417-excel-play-sound-if-condition-is-true.html

 

[jonahern]

Thanks Spectre....I’ve seen this and a few others out there. I have yet to take these basic instructions and build a more complex spreadsheet. I tried this specific example to beep when for example, last size > 1000 on a set of streaming quotes and the results were hit or miss.

 

[userque]

Thanks Spectre....I’ve seen this and a few others out there. I have yet to take these basic instructions and build a more complex spreadsheet. I tried this specific example to beep when for example, last size > 1000 on a set of streaming quotes and the results were hit or miss.

Try immediately surrounding (before, after, or both) your sound generating statement with:

Application.Wait (Now + TimeValue("0:00:01"))

and/or

DoEvents

If a one-second delay is too long (re: the timevalue delay function above), only use doevents.

You may also loop the doevents (or use multiple statements) to increase the delay in small increments.

 

[jonahern]

Try immediately surrounding (before, after, or both) your sound generating statement with:

Application.Wait (Now + TimeValue("0:00:01"))

and/or

DoEvents

If a one-second delay is too long (re: the timevalue delay function above), only use doevents.

You may also loop the doevents (or use multiple statements) to increase the delay in small increments.

Thanks for the input! I’ll try “DoEvents” and see if that does what I want. Def want sub 1 second... I am currently trying to monitor multiple streaming time and sales and play sounds based on “last size.”

 

[userque]

Thanks for the input! I’ll try “DoEvents” and see if that does what I want. Def want sub 1 second... I am currently trying to monitor multiple streaming time and sales and play sounds based on “last size.”

Also try application.wait for sh*ts and giggles ... and for proof of concept. You can remove it later. Doing that may give you some idea of how many doevents you might need.

FYI ... had the same problem. Seems VBA ran "so fast" on my puter that the sound was never generated ... until I slowed it down.

I have four beeps statements, each followed by a one-second delay AND a doevents to signal the end of a program. I usually only hear the last three. Sometimes I hear half of the first beep.

Keep us posted!

EDIT:

I've never tried it, but it looks like application.wait also works for delays of less than one second.

https://stackoverflow.com/questions...me-delay-of-less-than-one-second-in-excel-vba

 

[jonahern]

Thanks, userque! Would have never thought about it going too fast being an issue