PuneetTewani

Mouse click (using coordinates) not working on NSE NOW software. Works well everywhere else.

#include <IE.au3> #include <Tesseract.au3> #include <MsgBoxConstants.au3> #include <Math.au3> #include <FileConstants.au3> #include <StringConstants.au3> #include <File.au3> #include <ScreenCapture.au3> #include <sound.au3> #Include <WinAPI.au3> #include <Date.au3> $OCR_Result = _TesseractScreenCapture(0,"",1,2,220,660,500,730,1) $OCR_Result1 = _TesseractScreenCapture(0,"",1,2,220,660,500,730,1) $OCR_Result2 = _TesseractScreenCapture(0,"",1,2,220,660,500,730,1) $OCR_Result3 = _TesseractScreenCapture(0,"",1,2,220,660,500,730,1) $sound = _SoundStatus("C:\ExpertAdvisorBuyAlert.wav") while _nowtime < 3.30 pm If $sound = True Then if $OCR_Result1 > $OCR_Result2 EndIf EndIf Wend Trying to ocr some values on chart in real time(once per minute) and buy/sell securities on basis of alert generated in my software. I am struck onto few steps. 1. On Tesseract Screen Capture indentation parameters. How can we determine the exact parameters if I just want numeric values only. 2. The Tesseract Screen Capture generates and error Obj1 on line 185 which needs to be resolved. 3. Sometimes lines get overlapped with values. What to do in that case. 3. Detecting the sound as and when it approaches and then comparing the ocr values to decide on either buy or sell. The values that needs to be fetched are encircled.

I went through some articles on internet but isn't aware how to inject dll into system from VBA. Attaching the excel file that is being used in current context. The cell B2 is tracked and its value is recorded on cell V2 and so on at time interval of 3 minutes and I am trying to calculate average of 14 relevant cells(which keeps on changing as new rows are recorded) in cell W2 and if W2 > V2 inject a buy dll into system. Please also help in how to pass parameters to dll from excel. Thanks in advance. Default MW1.xlsm

@JLogan3o13 I have tried my hands onto it, but struck somewhere in middle. The code is as follows: #include <IE.au3> #include <Excel.au3> Call("signin") Func signin() Global $oIE= _IECreate ("xyz.com") Local $username = _IEGetObjByName($oIE,"username") Local $password = _IEGetObjByName($oIE,"password") Local $button = _IEGetObjById($oIE,"loginBTN") _IEFormElementSetValue ($username, "979928") _IEFormElementSetValue ($password, "PUNIT") _IEAction($button,"click") EndFunc MouseClick($mouse_click_left) MouseClick($mouse_click_left,396,181) Local $oExcel_1 = _excel_bookopen() Local $sworkbook = "C:\punit.xlsx" Local $oWorkbook = _excel_bookopen($oExcel_1,$sWorkbook) WinActiavte($oWorkbook) Local $_read = _excel_RangeRead($oWorkbook, "Sheet1","A1") Local $mobileno = _IEGetObjByName($oIE,"mobile") // as read from excel Local $message = _IEGetObjByName($oIE,"message") // as read from excel I haven't been able to use for loop to read excel sheet. I just managed to read a cell. The mobile numbers are in column A and message in Column B. Moreover, I need help in filling the data read from excel to tags mobileno and message. Thanks

I have a excel containing name and number of people. I need to register them on a website. The excel format is I have name in cell a1 and number in cell b1. I just need to fill in these 2 details and click on submit. I have around 4000 rows to fill in to the web form. Please help me with the code.

I am trying to automate my trading. I have used NEST RTD so that I can receive live data in excel. I want to compute average of 14 cells dynamically and the if average is greater than a particular number(for ex: 90), We buy a script and parameters for buy (i.e. Quantity, Limit Price) could be defined from excel itself.