Enter "TM" or "BRK.B" in symbol column and get unexpected result

Question

GTH1944 Author

Level 1

4 points

Enter "TM" or "BRK.B" in symbol column and get unexpected result

1) When "TM" is entered in the symbol column it changes to the small "tm" symbol for trademark and the data for Toyota Motors is not displayed. I checked my System Preferences/Keyboard/Text and there is no entry to make the change automatically (there are no entries).

2) When "BRK.B" is entered in the symbol column the entry is allowed, but the symbol is apparently not recognized and no data for Berkshire Hathaway Inc COM CL B appears.

MacBook Air 13″, macOS 10.15

Posted on Aug 14, 2022 5:27 PM

Reply

Answer 1

Top-ranking reply

SGIII

Level 8

37,550 points

Aug 14, 2022 8:29 PM in response to GTH1944

GTH1944 wrote:

1) When "TM" is entered in the symbol column it changes to the small "tm" symbol for trademark

Go in the menu to Edit > Substitutions and UNcheck Text Replacement

) When "BRK.B" is entered in the symbol column the entry is allowed, but the symbol is apparently not recognized and no data for Berkshire Hathaway Inc COM CL B appears.

The STOCK function gets its data from Yahoo! Finance and uses the symbols that are value in Yahoo! Finance. For Berkshire Hathaway B the symbol used in Yahoo! Finance is BRK-B.

Try using BRK-B instead of BRK.B.

SG

Reply

Answer 2

GTH1944 Author

Level 1

4 points

Aug 14, 2022 7:48 PM in response to Wayne Contello

I agree that TM works in this use of the formula in a blank template. It does not work for me when entering the symbol "TM" in the My Stocks template. Thank you for responding.

I am still looking for a solution for both TM and BRK.B.

Reply

Answer 3

Aug 14, 2022 6:42 PM in response to GTH1944

With regard to item (1):

I do not get the same outcome you report.

So I entered the symbol "TM" in cell C3 and the formula shown

Reply

Answer 4

GTH1944 Author

Level 1

4 points

Aug 15, 2022 5:35 AM in response to SGIII

Both of my difficulties are resolved! THANK YOU SG! Your services are greatly appreciated.

gth

Reply

Enter "TM" or "BRK.B" in symbol column and get unexpected result

Similar questions