Excel 365 ETF Prices (=B2.Price)

Data123

Board Regular
Joined
Feb 15, 2024
Messages
71
Office Version
  1. 365
Platform
  1. Windows
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
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
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.
 
Upvote 0
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.
 

Attachments

  • B2 Price Wrong.PNG
    B2 Price Wrong.PNG
    17.7 KB · Views: 12
Upvote 0
I put your symbols in a worksheet and bounced them off Yahoo Finance. They all matched that source...

Book2
BC
1VS:2x Long VIX Futures (BATS:UVIX)$ 5.03
2ProShs II:Ult Blm Nat Gs (ARCX:BOIL)$ 14.08
3Direxion:Elctr & AV Bl2X (ARCX:EVAV)$ 17.74
4ProShs II:UltVIX STF ETF (BATS:UVXY)$ 22.05
Sheet1
Cell Formulas
RangeFormula
C1:C4C1=B1.Price
 
Upvote 0
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?
 
Upvote 0

Forum statistics

Threads
1,223,447
Messages
6,172,203
Members
452,448
Latest member
Tupacandres

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top