Automated Excel Screen Capture System
Budget: $30 – $250 USD
So, here is my project details again described here, study and give me better code please:
I have excel file showing live data of market, I watch this excel file from abroad through screenleap, I want to build a live watch up software by python or java and web application or any other coding to watch this live data and store them in my pc in a data base allowing me to watch the history of a few days back, here are the page names in excel file
eurusd , eurjpy , eurchf , eurgbp , eurcad , eurcny , oil , eursgd , eurhkd , euraud ,
usdchf , usdjpy , usdcad , usdsgd , usdhkd, usdcny , 5yb , gbpusd , gbpcad , gbpjpy ,
gbpchf , gbpcny , gbpsgd , gbphkd , gbpaud , chfcny , chfjpy , nzdusd , nzdjpy , audusd ,
audcad , audnzd , audjpy , cadjpy , xauusd , BTC , ETH , CORN , audchf , audsgd ,
cadchf , chfsgd , chfhkd , eurnzd , gbpnzd , jpysgd , jpycny , cnysgd , nzdcad , nzdchf ,
nzdhkd , hkdsgd , hkdjpy , cnyhkd , test.
Store the captured photo in the page name, store data as per time taken at.
Give me a proper code to do that please.
This database contain a photos only no numbers.
In most excel pages you need to watch the cell CA31 this counter variable moving from 16500 to 17000 only, it takes about 5 minutes in this range, when reach to 17000 it is changes to 16500 to start count again to 17000, at 17000 and before goes to 16500 big action happen you need to consider carefully : it is moving fastly through all the 55 pages to show them and you need to store those 55 pages(at this instance you need to captured those page photos and store them and the time taken associated), no csv files only photos please, at counter value 17000 the mouse shape changed, keep your eye on it to predict the future move of this excel file. This counter CA31 value is same in all pages, so if it got value of 17000 then its same in all other pages. This counter in page hkdsgd is at BR128. Give me the input in your code the 9 digits of screenleap page to enter to follow up because this 9 digits number changed frequently not fixed. Do your code again and take your time in testing please in your side. Read time from cell BW51 from most pages to know the time in excel and show it to me and show me also the time now as per my pc in the output.
When you log in to the screenleap, keep it on, no disconnection.
Now, I have a live data of screen leap and other stored pages photos, give me choices to see live data , or any other specific page of combination, maximum 4 photos I can see per page, make your code according to that. Give me Microsoft window application only.
لإhis code suppose to run all 24 hours and 5 days continuously, so please confirm its robustness.
Improve and correct your code. Give me stop button from the live page and when I stop it, it should delete ram and databases properly to help another fresh start later.
you need to watch the page name down and CA31,BW51 cell values from most pages, study this screenleap page for 15 minutes to capture the nature of this excel file working policy https://www.screenleap.com/621414478
your code should be smart and watch the page name down, any new page should be photted, and pass this photo to your data base , each page name having its own data base part to store in and restore from , fix your code again accordingly
build the code in your side and test it for 15 minutes at least then pass it to me after checking no errors and its working fine.
Show me the start time or the elapsed time of run, show me the value of CA31 and BW51 as you catch them from the pages.
When this counter reach 17000 then the excel stopped and start passing all 55 pages and last 0.2 second in each page here you need to do captured fastly, keep you eye on the mouse please its predicted the next move of the excel file, when the mouse getting action and circle shape at 17000 counter value then the move among 55 pages done here, your code is making captured all times, this is wrong, correct it, and show me how to see the history of those captured photos in the desktop application, allow the screenleap to be in back if i do not want to see it and not necessary to be watched it can be in the back if i want.
The counter value is moving from 16500 to 17000 in about 5 minutes, you need to guess its move value to correct your reading. See cell CA33: it shows the time in minute from the start of counter at 16500 to now, read it to guide you to read and guess counter value correctly, you need to prepared to the main action at 17000 : to captured the photos and store them and relate those stored to the time take of those photos and store in the name of the page and be sure those data base is easy to explore and watch.
Make the size of photo in the stored data is adjustable and 75% of the screen size.
CA31 , its excel sheet, simple, look up to the top line you can see the column name CA, and look left to the row number and search for 31, the crossing of those two values is showing the value of CA31, its easy, why you need to read it correctly.
The page or sheet name is the lower line in the page, the selected page shall be shiny, its easy to see the selected sheet.
I have excel file showing live data of market, I watch this excel file from abroad through screenleap, I want to build a live watch up software by python or java and web application or any other coding to watch this live data and store them in my pc in a data base allowing me to watch the history of a few days back, here are the page names in excel file
eurusd , eurjpy , eurchf , eurgbp , eurcad , eurcny , oil , eursgd , eurhkd , euraud ,
usdchf , usdjpy , usdcad , usdsgd , usdhkd, usdcny , 5yb , gbpusd , gbpcad , gbpjpy ,
gbpchf , gbpcny , gbpsgd , gbphkd , gbpaud , chfcny , chfjpy , nzdusd , nzdjpy , audusd ,
audcad , audnzd , audjpy , cadjpy , xauusd , BTC , ETH , CORN , audchf , audsgd ,
cadchf , chfsgd , chfhkd , eurnzd , gbpnzd , jpysgd , jpycny , cnysgd , nzdcad , nzdchf ,
nzdhkd , hkdsgd , hkdjpy , cnyhkd , test.
Store the captured photo in the page name, store data as per time taken at.
Give me a proper code to do that please.
This database contain a photos only no numbers.
In most excel pages you need to watch the cell CA31 this counter variable moving from 16500 to 17000 only, it takes about 5 minutes in this range, when reach to 17000 it is changes to 16500 to start count again to 17000, at 17000 and before goes to 16500 big action happen you need to consider carefully : it is moving fastly through all the 55 pages to show them and you need to store those 55 pages(at this instance you need to captured those page photos and store them and the time taken associated), no csv files only photos please, at counter value 17000 the mouse shape changed, keep your eye on it to predict the future move of this excel file. This counter CA31 value is same in all pages, so if it got value of 17000 then its same in all other pages. This counter in page hkdsgd is at BR128. Give me the input in your code the 9 digits of screenleap page to enter to follow up because this 9 digits number changed frequently not fixed. Do your code again and take your time in testing please in your side. Read time from cell BW51 from most pages to know the time in excel and show it to me and show me also the time now as per my pc in the output.
When you log in to the screenleap, keep it on, no disconnection.
Now, I have a live data of screen leap and other stored pages photos, give me choices to see live data , or any other specific page of combination, maximum 4 photos I can see per page, make your code according to that. Give me Microsoft window application only.
لإhis code suppose to run all 24 hours and 5 days continuously, so please confirm its robustness.
Improve and correct your code. Give me stop button from the live page and when I stop it, it should delete ram and databases properly to help another fresh start later.
you need to watch the page name down and CA31,BW51 cell values from most pages, study this screenleap page for 15 minutes to capture the nature of this excel file working policy https://www.screenleap.com/621414478
your code should be smart and watch the page name down, any new page should be photted, and pass this photo to your data base , each page name having its own data base part to store in and restore from , fix your code again accordingly
build the code in your side and test it for 15 minutes at least then pass it to me after checking no errors and its working fine.
Show me the start time or the elapsed time of run, show me the value of CA31 and BW51 as you catch them from the pages.
When this counter reach 17000 then the excel stopped and start passing all 55 pages and last 0.2 second in each page here you need to do captured fastly, keep you eye on the mouse please its predicted the next move of the excel file, when the mouse getting action and circle shape at 17000 counter value then the move among 55 pages done here, your code is making captured all times, this is wrong, correct it, and show me how to see the history of those captured photos in the desktop application, allow the screenleap to be in back if i do not want to see it and not necessary to be watched it can be in the back if i want.
The counter value is moving from 16500 to 17000 in about 5 minutes, you need to guess its move value to correct your reading. See cell CA33: it shows the time in minute from the start of counter at 16500 to now, read it to guide you to read and guess counter value correctly, you need to prepared to the main action at 17000 : to captured the photos and store them and relate those stored to the time take of those photos and store in the name of the page and be sure those data base is easy to explore and watch.
Make the size of photo in the stored data is adjustable and 75% of the screen size.
CA31 , its excel sheet, simple, look up to the top line you can see the column name CA, and look left to the row number and search for 31, the crossing of those two values is showing the value of CA31, its easy, why you need to read it correctly.
The page or sheet name is the lower line in the page, the selected page shall be shiny, its easy to see the selected sheet.