Auto updating datasets and conditional formating

If you can have that in .csv format, then you can use dataSets in Xibo, create required columns and then import the .csv there.

Then you can use either Ticker module with dataSet source or dataSet View module to show the information from the dataSet.

As for the operations on existing columns, you can have a Formula column in dataSet that will make operations on the selected columns and show the output of it.

There are several examples here on the Xibo community site, something like this one might be of interest to you - Dataset Formula to Calculate Percentage