Prices based on formula and multiple values

[jewele8]

Hi everyone. I am a newbie to prestashop and i'd appreciate your help.

 

I am trying to develop a wholesale jewelry store and most of my product prices are based on precious metal prices that fluctuate and two other values that do not fluctuate (labor/piece and unit weight in grams).

 

Metal prices are always changing and it would be inconvenient to be uploading prices for a large inventory constantly.

 

The product price = labor($/pc) + [weight(grams/pc) * market price of metal ($/gram)].

 

My products are in excel files and the formulas do not translate to csv. I was wondering if there is a way to upload the product specs according to the formula above and input a market metal price either manually once/twice a day or linked to a market website like bloomberg in real time.

 

Thanks for your help