Importing price data into spreadsheets

I'm sure this is an easy thing to do but for some reason can't find it anywhere on the web. But how do you import price data into a spreadsheet for calculations? I basically want to do price ratio calculations and spit them out to a chart. Right now I'm doing this in google sheets and exporting the results into a Sierra chart. But it would be great to do it all within Sierra and keep the charts current without having to go through all the downloading and updating the price data files each day.

Thanks for any help!