Excel Stockhistory lookup for SPAC WARRANTS either gives wrong company or value error.

%3CLINGO-SUB%20id%3D%22lingo-sub-3087765%22%20slang%3D%22en-US%22%3EExcel%20Stockhistory%20lookup%20for%20SPAC%20WARRANTS%20either%20gives%20wrong%20company%20or%20value%20error.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3087765%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20on%20a%20Dell%20desktop%20using%20Microsoft%20365%20Excel%20MSO%20(Version%202112%20Build%2016.0.14729.20254)%2064-bit16.0.14729.20254)%2064-bit%2C%20WIN%2010.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20attached%20spreadsheet%20I%20input%20a%20date%20and%20get%20back%20the%20value%20of%20a%20stock%20warrant%20so%20that%20I%20can%20follow%20whether%20it%20is%20going%20up%20or%20down.%26nbsp%3B%20The%20spreadsheet%20I%20pulled%20this%20from%20has%20about%2040%20different%20companies%20and%20mostly%20they%20all%20work%20except%20for%20the%20three%20I%20present%20in%20this%20example.%26nbsp%3B%20Columns%20B%20thru%20G%20are%20some%20SPAC's%20that%20I%20follow.%26nbsp%3B%20Row%202%20is%20the%20stock%20symbol%20(DATA%20type%20STOCK)%20and%20the%20name%20of%20the%20company.%26nbsp%3B%20Row%204%20is%20the%20number%20of%20shares.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CU%3E%26nbsp%3B%3C%2FU%3E%3C%2FP%3E%3CP%3E%3CU%3EFirst%20instance%3C%2FU%3E.%3C%2FP%3E%3CP%3EColumn%20B%20is%20the%20company%20shares%20for%20AURORA%20Innovation%20and%20column%20C%20is%20the%20warrant%20associated%20with%20the%20same%20company.%26nbsp%3B%20You'll%20see%20in%20cell%20C2%20it%20lists%20the%20company%20as%20ARROW%20(the%20W%20stands%20for%20warrant)%20Financial%20Corp.%26nbsp%3B%20This%20is%20wrong%2C%20it%20should%20show%20Aurora%20Innovation%20warrants.%3C%2FP%3E%3CP%3E%3CU%3E%26nbsp%3B%3C%2FU%3E%3C%2FP%3E%3CP%3E%3CU%3ENext%20instance%3C%2FU%3E.%3C%2FP%3E%3CP%3EColumn%20D%20shows%20EQRX%20and%20it%20pulls%20up%20the%20shares%20for%20EQRX.%26nbsp%3B%20Column%20E%20is%20the%20warrants%20for%20EQRX%20from%20stock%20symbol%20EQRXW.%26nbsp%3B%20Here%20the%20lookup%20fails%20and%20only%20returns%20a%20value%20error.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%3CU%3E%26nbsp%3B%3C%2FU%3E%3C%2FP%3E%3CP%3E%3CU%3ELast%20instance%3C%2FU%3E.%26nbsp%3B%3C%2FP%3E%3CP%3EColumn%20F%20represents%20the%20shares%20for%20RAM%20(formerly%20known%20as%20Aries%20I%20Acquisition)%20and%20it%20works%20correctly.%26nbsp%3B%20Column%20G%2C%20the%20warrant%20for%20RAM%20is%20RAMMW%2C%20returns%20a%20value%20error.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20attached%20spreadsheet%20with%20formulas%20is%20presented%20so%20that%20you%20see%20exactly%20the%20symbols%20and%20the%20functions.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20suspicion%20that%20excel%20is%20looking%20in%20the%20wrong%20exchange%20ie.%20Not%20NASDAQ%20or%20NYSE.%26nbsp%3B%20That%20would%20explain%20why%20excel%20is%20not%20correctly%20finding%20AUROW%2C%20EQRSW%20and%20RAMMW.%26nbsp%3B%20All%20threee%20are%20in%20NASDAQ.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20thoughts%2C%20ways%20to%20proceed%20or%20solutions%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20your%20help.%3C%2FP%3E%3CP%3ESteve%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3087765%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

I am on a Dell desktop using Microsoft 365 Excel MSO (Version 2112 Build 16.0.14729.20254) 64-bit16.0.14729.20254) 64-bit, WIN 10.

 

In the attached spreadsheet I input a date and get back the value of a stock warrant so that I can follow whether it is going up or down.  The spreadsheet I pulled this from has about 40 different companies and mostly they all work except for the three I present in this example.  Columns B thru G are some SPAC's that I follow.  Row 2 is the stock symbol (DATA type STOCK) and the name of the company.  Row 4 is the number of shares. 

 

First instance.

Column B is the company shares for AURORA Innovation and column C is the warrant associated with the same company.  You'll see in cell C2 it lists the company as ARROW (the W stands for warrant) Financial Corp.  This is wrong, it should show Aurora Innovation warrants.

 

Next instance.

Column D shows EQRX and it pulls up the shares for EQRX.  Column E is the warrants for EQRX from stock symbol EQRXW.  Here the lookup fails and only returns a value error.  

 

Last instance

Column F represents the shares for RAM (formerly known as Aries I Acquisition) and it works correctly.  Column G, the warrant for RAM is RAMMW, returns a value error.  

The attached spreadsheet with formulas is presented so that you see exactly the symbols and the functions. 

 

I have a suspicion that excel is looking in the wrong exchange ie. Not NASDAQ or NYSE.  That would explain why excel is not correctly finding AUROW, EQRSW and RAMMW.  All threee are in NASDAQ.

 

Any thoughts, ways to proceed or solutions would be greatly appreciated.

Thanks in advance for your help.

Steve

0 Replies