Test Description:
****************************************
Create an excel file with 3 worksheets: worksheet1, worksheet2, worksheet3
1) Read a cell A1 in the worksheet1, and if its true, then carry out 1 random order..
2) In worksheet2, store in B2 cell, whether the order was executed or not..
3) If it was not executed, then execute another random order... else do nothing..
4) In worksheet 3, retrieve and store some information about live market feed in cells A1,A2,A3.
Create a ReadMe file explaining:
1) Explain the API used for carrying out the orders. Explain the parameters of API and return value. Explain whether the API is asynchronous or synchronous.
And if its asynchronous, how do we provide a callback function in order to handle unexecuted/failed orders.
2) Explain what informations did u retrieve and stored in step 4 above in A1,A2,A3 cells of worksheet 3, and what APIs did you use in order to retrieve the information.
Comment your code deeply, so that even a person with no knowledge in coding will be able to understand what the part of the code is doing, and why and how.
**************************************
Whoever bids less than $100 will be hired right away.
This is just a test in order to find the right coder for a bigger project.
And this test is paid. So if you are chosen, you will be paid what you bid for before you are hired for the bigger project.
This test will be awarded and paid only when the client is happy, and agrees to hire you for the bigger project and pays for this test.
You may learn APIs from [login to view URL] in order to implement this test.
And you may learn VBA scripting with Excel too before you begin this test.
The IB API for Windows or Mac can be downloaded from:
[login to view URL]
The IB API Guide can be found here:
[login to view URL]
[login to view URL]
[login to view URL]
All the above links can be found here:
[login to view URL]
Hello, I am top excel developer on this forum with 200+ five star reviews and with a completion rate of 90%. I have understood your requirement and I am sure I can implement this. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
Hi,
I am working as Lead Pricing Analyst in a Fortune 500 MNC. I have worked on pricing models, income statements, conjoint surveys, business analysis etc.
Prior that I have completed MBA and bachelors in Engineering.
I have worked extensively on excel and VBA in my job and here on freelancer as well.
I believe I can help in your work. Please have a look at reviews provided by previous employers. Please contact for further discussion.
Regards!
Vikas
Hi,
I am working as software professional in IT industry from last 4 years.
I work on VB scripting along with VBA for MS office applications.
Also developed various Desktop based application using Visual Studio in VB and C#
I have done projects related to VBA and VB in past.
I am currently going through all the detailed description to have a clear view.
If you like my proposal,lets start.
Thanks
Abhinov