Convert values generated from scrolling a chart into a json file.

Help Activities
, ,
1

I have a financial chart I’m screen scraping info from, the values from the chart that I’m interested in are available in a data window, with the values changing for each bar on the chart. Eg date/time, highvalue, lowvalue.

I am able to use get text ocr to get the values I want, but I need to be able to take those values and create an array in json file.

Does anyone know how to do this?

2

Hi @Anthony_Keeley

Have you tried converting the collected variables into a list by writing them side by side with assign ?

or

Take your specified json format and replace each captured variable in this format instead of the relevant tags.

Regards,
MY

3

How do you do the second one of those using json?

4

Hey @Anthony_Keeley

You can please show us the JSON structure you want to create to suggest which data type variable can be used for the same.

Thanks
#nK

5

Thanks

{“data”: [[“1654531200000”,“7464.72”,“2069.41”],[“1634270400000”,“11781.24”,“1373.18”]]}

1 Like
6

Hey @Anthony_Keeley

You need to create a dictionary with key type as String and value type as Array(Array(String))

Thanks
#nK

1 Like
7

Try doing this and let us know if you have problems. You will create a list of Array lists.

1 Like