Plotly graph
Budget: $30 – $250 USD
I want build plotly scatter together with line graph with is 5 days back and show me how many coupons has been sold or bot in a defined time frame.
Read from file data: Date, Time, Price, BuyCoupon, SellCoupon (sample file provided) just to see if its working and then connect to api to read real time.
best if you provide code in jupyter notebook so I can check myself.
1. Calculate how many coupons has been sold or bot in 60s (not together, calculate separetly for how many bot(blue scatter) and sold(green scatter)) and plot on price line.
a) whatever color scatter occur first, the next one is on top of previous.
b) eg. if there is 110 coupons sold and 240 coupons bot in the 60s time frame then plot blue scatter that show "110" number on hoverinfo and also plot green with "240" number hoverinfo.
3. Filter out less than 100 and more than 1000 coupons sold or bot.
a)scatter should ble ploted only if there is more than 100 coupons bot or sold and and max 1000 in defined time.
b) So if there is 99 coupons sold in 60s then nothing ploted
c) if there is 1001 coupons sold in 60s - nothing plot.
d) sum of 110 sold or bot in 60s - plot relevant color and size scatter.
4. Size of scatter should be relevant to the sum of bot or sold coupons in a range of 1-20.
a) size 1 is the smallest scatter size, 20 is the biggest.
b) size of scatter should be calculated only till 600 coupons, so 600 coupons is 20 size. Over 600, scatter size is the same (650, 730, 999 is size 20)
5. plot scatter on relevant y-axis price of with was bot or sold with relevant scatter size.
a) scatter plotting is time independent, so it will plot only if sum of coupons will occur. There is date and time anyway as a reference at x-axis, but it will not spread long distance from each scatter if there time of plotting another scatter was long because of less than 100 coupons sale. Scatter need to be close to each other( eg. plot another scatter 1mm from previous scatter centre point)
6. Chart should show last 500 scatter back (or less, just to look good), rest 5 days should be scrolled back to the left.
Read from file data: Date, Time, Price, BuyCoupon, SellCoupon (sample file provided) just to see if its working and then connect to api to read real time.
best if you provide code in jupyter notebook so I can check myself.
1. Calculate how many coupons has been sold or bot in 60s (not together, calculate separetly for how many bot(blue scatter) and sold(green scatter)) and plot on price line.
a) whatever color scatter occur first, the next one is on top of previous.
b) eg. if there is 110 coupons sold and 240 coupons bot in the 60s time frame then plot blue scatter that show "110" number on hoverinfo and also plot green with "240" number hoverinfo.
3. Filter out less than 100 and more than 1000 coupons sold or bot.
a)scatter should ble ploted only if there is more than 100 coupons bot or sold and and max 1000 in defined time.
b) So if there is 99 coupons sold in 60s then nothing ploted
c) if there is 1001 coupons sold in 60s - nothing plot.
d) sum of 110 sold or bot in 60s - plot relevant color and size scatter.
4. Size of scatter should be relevant to the sum of bot or sold coupons in a range of 1-20.
a) size 1 is the smallest scatter size, 20 is the biggest.
b) size of scatter should be calculated only till 600 coupons, so 600 coupons is 20 size. Over 600, scatter size is the same (650, 730, 999 is size 20)
5. plot scatter on relevant y-axis price of with was bot or sold with relevant scatter size.
a) scatter plotting is time independent, so it will plot only if sum of coupons will occur. There is date and time anyway as a reference at x-axis, but it will not spread long distance from each scatter if there time of plotting another scatter was long because of less than 100 coupons sale. Scatter need to be close to each other( eg. plot another scatter 1mm from previous scatter centre point)
6. Chart should show last 500 scatter back (or less, just to look good), rest 5 days should be scrolled back to the left.