Hi there,

I am looking for a wizard to help me out on this one.

I've created a rather advanced Excel workbook that tracks stocks (analyses, gives alerts, atc). The only thing missing is real time stock prices. I have tried many many things to get real time stockprices in my spreadsheet (power querry, web sourcing, the "new" stock data type from Office 365), but all of them have the same issue: 15 minute delay on prices.

I understand where this is coming from (its all about the monah), but I am curious if there is any hero around here that can tell me if there is a way to get REAL TIME stock prices in my excel workbook. I can work my way around excel and vba, so I don't care how difficult it is, or if it involves some other software. If it requires me to subscribe to some data source that provides me with the data, I am willing to do so (if the prices is reasonable for a stand-alone wannabe investor) - as long as I can get real time stock prices into my workbook, that can automatically refresh every minute or so.

Any help on this is much appreciated.

Cheers.