Testing with googlesheet download

1
Stock NameBase Price
10 AM Matching Price
10:30 AM Matching Price
11 AM Matching Price
11:30 AM Matching Price
12 PM Matching Price
12:30 PM Matching Price
1 PM Matching Price
Change From
Change From Base Price
Volume Traded at Matching Time
Total Volume Traded
Market Cap(Million
2
FMI8,4008,4008,4008,4008,4008,4008,4008,40000.00%54448278,121
3
MTSH2,8502,8502,8502,8502,9002,9002,9002,900501.75%0680112,895
4
MCB7,9007,9007,9007,9007,9007,9007,9007,90000.00%0082,168
5
FPB1,5001,5001,5001,5001,5001,5001,5001,50000.00%210344,497
6
TMH2,4502,4502,5002,5002,5002,5002,5002,500502.04%020432,058
7
EFR1,7501,7001,7001,7001,7001,7001,7501,75000.00%015234,960
8
AMATA4,7004,5004,7004,7004,7004,7004,7004,70000.00%6849,339
9
MAEX1,8501,9001,9001,9001,9001,9001,9001,85000.00%1108331,534

 

Testing with googlesheet publish link

Stock NameBase Price10 AM Matching Price10:30 AM Matching Price11 AM Matching Price11:30 AM Matching Price12 PM Matching Price12:30 PM Matching Price1 PM Matching PriceChange FromChange From Base PriceVolume Traded at Matching TimeTotal Volume TradedMarket Cap(Million
FMI8,4008,4008,4008,4008,4008,4008,4008,40000.00%54448278,121
MTSH2,8502,8502,8502,8502,9002,9002,9002,900501.75%0680112,895
MCB7,9007,9007,9007,9007,9007,9007,9007,90000.00%0082,168
FPB1,5001,5001,5001,5001,5001,5001,5001,50000.00%210344,497
TMH2,4502,4502,5002,5002,5002,5002,5002,500502.04%020432,058
EFR1,7501,7001,7001,7001,7001,7001,7501,75000.00%015234,960
AMATA4,7004,5004,7004,7004,7004,7004,7004,70000.00%6849,339
MAEX1,8501,9001,9001,9001,9001,9001,9001,85000.00%1108331,534

 

Testing with googlesheet publish link [Sheet2]

Login emailIdentifierOne-time passwordRecovery codeFirst nameLast nameDepartmentLocation
rachel@example.com901212se74rb9012RachelBookerSalesManchester
laura@example.com207004ap67lg2070LauraGreyDepotLondon
craig@example.com408130no86cj4081CraigJohnsonDepotLondon
mary@example.com934614ju73mj9346MaryJenkinsEngineeringManchester
jamie@example.com507909ja61js5079JamieSmithEngineeringManchester