Automated Price Changes based on Market Variations

[ciscoaum]

We are a wholesaler selling Gold Filled/Silver jewelry components.

We are looking for a way to automatically change item prices based on current Gold & Silver metal market prices.

I have spoken to some others in my industry & they tell me that they have input the prices at a certain level of Gold/Silver & have added increments for each. Then daily they would set the current Gold/Silver prices and the program would calculate current prices.

What is the best accounting/invoicing pacakge within QuickBooks group or even outside that will offer above.

I also need to often change prices on items that is very manual. Any suggestions on updating prices from Excel or Access databases?

Thanks,