When I access an api. it returns data in below format
n2035014,25 N2035014,25 B2035014,2944.40,250,3787.30,2400 o24,22971.20 h24,23064.15 l24,22641.40 c24,22945.05 i24,22744.40
I am clueless how to map these data and store in mysql table.
First set of data highlited in bold is dataset 1, followed by second set of data which has a prefix that needs to be mapped from below reference table. And above is just an example output, usually it will have 500 such dataset.
i=current value
B=bid
o= open
h=high
l=low
c=close
I want to store something like this
stock code | Current Value | Open | High | Low | Close | Bid
24 |22744.40 |22971.20 |23064.15 |22641.40 |22945.05
2035014 25 |Null | Null | Null | Null | 2944.40,250,3787.30,2400
Thanks for guidance.