i need an excel file with VBA macro working as follows:
It must have a clock updating in real time
A1: it has a live stock price updating in real time (that i will provide)
everytime the clock gets to a point i can chose (i.e. every 10mins or every round minute), the content of cell A1 is copied down in column A
columns B and columns C will perform a calculation i will enter manually
then, suppose B5 and C5 are the top point of column B and C:
if B6>C6 and now B5<C5 then
open enternal application and performs a set of actions,
otherwise do nothing
the extermal application is internet explorer or can be a stock trading program.
1. the code must allow me to modify the condition "if B6>C6 and now B5<C5 then" etc...
2. ideally it is easy to modify the part of code that wakes up the external application, because suppose the website changes, i must be able to adapt the code for the program to put the right number in the right box.
13 freelancers are bidding on average $118 for this job
hi...I m a vba developer and have worked on such projects..... price is no issue.. we can talk over it.. I just want to show my abilities.. Hope to hear from u soon..