Excel 365 ETF Prices (=B2.Price)

[Data123]

May I ask if others are showing wrong prices for US ETFs (=B2.Price)? Every ETF I try to show a price for seems way off. When I look at the price history on Yahoo Finance I can't even match it to a day in the past. Historical prices do show correctly in Excel. ie., UVIX

 

[igold]

B2.Price is the Last Price for the symbol. It works on all my US ETF's (I bring back about 30 symbols). Although they may not always agree with other sources (i.e. Yahoo Finance). Eventually they all align. it's a classic of "it depends who you ask"... What are some of the symbols you are looking at.

 

[Data123]

B2.Price is the Last Price for the symbol. It works on all my US ETF's (I bring back about 30 symbols). Although they may not always agree with other sources (i.e. Yahoo Finance). Eventually they all align. it's a classic of "it depends who you ask"... What are some of the symbols you are looking at.

Thanks, your answer gives me hope something in my workbook is defective. I normally view my workbook when the market is closed so I am not concerned with any delay issue. Every symbol I have in place gives me the wrong END OF DAY PRICE. When I compare it to the closing prices for the last 25 days it does not match any of them. See uploaded image. Is there a way to manually refresh a symbol's data and if it fixes it then manually do all symbols at once or could this be an issue with the BATS, ARCX, XNAS?
************I refreshed the data of the symbols after writing the above reply and it fixed the issue. Awesome! It also updated other data points that were wrong for every symbol ie., volume, avg volume, 52 week high................Weird how this gets corrupted and also what data is it pulling then? As mentioned I looked at historical data for several symbols going back months (daily) and none matched.

 

[igold]

I put your symbols in a worksheet and bounced them off Yahoo Finance. They all matched that source...

Book2
	B	C
1	VS:2x Long VIX Futures (BATS:UVIX)	$ 5.03
2	ProShs II:Ult Blm Nat Gs (ARCX:BOIL)	$ 14.08
3	Direxion:Elctr & AV Bl2X (ARCX:EVAV)	$ 17.74
4	ProShs II:UltVIX STF ETF (BATS:UVXY)	$ 22.05
Sheet1

Cell Formulas
Range	Formula
C1:C4	C1	=B1.Price

 

[Data123]

Thanks, yeah as mentioned when I refreshed the symbols data it correted itself. I wonder what causes this and why the prices dont match the history of end of day prices from the past?