Getting the data from AH include obviously the unit price but what is the value? Is the value stored as the total amount of copper which we then need to convert to the amount of silver and gold or is it stored as something else?
You are correct. The value is represented in copper.
1s = 100c
1g = 100s (or 10000c)
You can just split the text as follow to get the actual value:
10000 = 1g 00s 00c
223456 = 22g 34s 56c
1432266 = 143g 22s 66c
Perfect! Thanks a lot for your detailed answer!