Create a small tool using Python to help visualize the total Mark-To-Market values
Budget: $10 – $30 USD
In this assignment, you will be provided with raw data containing stock holdings (quantity of shares) in four hypothetical trading inventories (Book 1-4) with respective prices. Data is available in two formats: 1) excel file 2) json file. You are asked to create a small tool using Python to help visualize the total Mark-To-Market values of stock holdings.
1. 3 results are required:
a. "Mark-To-Market" aggregated by inventory
b. "Mark-To-Market" aggregated by sector
c. "Mark-To-Market" aggregated by Stock (use "simpleTicker")
2. "Mark-To-Market" = last price * quantity of shares
3. Data processing should be Python based; excel vlookup / aggregation etc. will be considered as failing the task
Evaluation:
There are several ways to complete this assignment; each is associated with a different level of proficiency as outlined in the Guidance Table below. Feel free to use any resource for self-learning and please note the task should be completed with your own effort as you will be asked to present your final work during the interview.
1. 3 results are required:
a. "Mark-To-Market" aggregated by inventory
b. "Mark-To-Market" aggregated by sector
c. "Mark-To-Market" aggregated by Stock (use "simpleTicker")
2. "Mark-To-Market" = last price * quantity of shares
3. Data processing should be Python based; excel vlookup / aggregation etc. will be considered as failing the task
Evaluation:
There are several ways to complete this assignment; each is associated with a different level of proficiency as outlined in the Guidance Table below. Feel free to use any resource for self-learning and please note the task should be completed with your own effort as you will be asked to present your final work during the interview.