Hi,
As per the subject I am trying to take some of the time consuming irritants out of binary option trading. I have a program I wrote that works great. In fact I made several threads on this site over the last year to help finish it. But now, for ease of use, I would like to have triggers emailed to me. There have been threads about this before but due to the violent complexity of my workbook I had hoped I could bump this topic to be revisited.
Some specifics:
- I am using Outlook not Express
- Excel 2007
- All the functionality is complete for monitoring several live streams of securities data with several trade indicators.
- It is consolidated onto one sheet for manual monitoring (Picture below). Basically takes copious amounts of data and reduces it to just IF and AND functionality for the triggers for easy use from all the other sheets.
- The workbook will be open and running/refreshing on its own 24/7 as it is now.
I am a busy guy, I just need the VBA to automatically email me remotely when any of the 7 currency pairs causes a trigger when I am on the go. I can log trades from an app on my phone.
One other hurdle would be that if say (Using percentages to keep it simple) that a trigger would be if something reached as high as 80% to send the notification email. But where the system refreshes every 60 seconds it shouldn't send another notification each time it remains at or above 80%. Just the once. It may remain there for hours and that is a lot of emails.
Thoughts? and many many thanks in advance.
*EDIT* I cannot provide the entire workbook as it is too valuable. Seems to be the holy grail for binary traders from my research over the past year. But the picture provides a decent view of the functionality. I could make a stripped down version if needed.
As per the subject I am trying to take some of the time consuming irritants out of binary option trading. I have a program I wrote that works great. In fact I made several threads on this site over the last year to help finish it. But now, for ease of use, I would like to have triggers emailed to me. There have been threads about this before but due to the violent complexity of my workbook I had hoped I could bump this topic to be revisited.
Some specifics:
- I am using Outlook not Express
- Excel 2007
- All the functionality is complete for monitoring several live streams of securities data with several trade indicators.
- It is consolidated onto one sheet for manual monitoring (Picture below). Basically takes copious amounts of data and reduces it to just IF and AND functionality for the triggers for easy use from all the other sheets.
- The workbook will be open and running/refreshing on its own 24/7 as it is now.
I am a busy guy, I just need the VBA to automatically email me remotely when any of the 7 currency pairs causes a trigger when I am on the go. I can log trades from an app on my phone.
One other hurdle would be that if say (Using percentages to keep it simple) that a trigger would be if something reached as high as 80% to send the notification email. But where the system refreshes every 60 seconds it shouldn't send another notification each time it remains at or above 80%. Just the once. It may remain there for hours and that is a lot of emails.
Thoughts? and many many thanks in advance.
*EDIT* I cannot provide the entire workbook as it is too valuable. Seems to be the holy grail for binary traders from my research over the past year. But the picture provides a decent view of the functionality. I could make a stripped down version if needed.
Last edited:
