=@IntrinioFinancials($A2:"calculations":$S2:$T2:"adjweightedavedilutedsharesos":"A")

where A2 is ticker symbol S2 is Q2 and T2 is year 2020 is not returning outstanding shares. Just getting #VALUE in excel.

=@IntrinioFinancials($A2:"calculations":$S2:$T2:"adjweightedavedilutedsharesos":"A")

where A2 is ticker symbol S2 is Q2 and T2 is year 2020 is not returning outstanding shares. Just getting #VALUE in excel.

Comment

0

I pasted

=IntrinioFinancials("AMZN","calculations","2020","Q2","adjweightedavedilutedsharesos","A")

and got generic "There's something wrong with this formula" from excel but replaced your commas with colons and got the number. Let me refer you

(https://docs.intrinio.com/documentation/excel/getting_started)

However when using references i still got #Values. Realized when typing T2:S2 for Year:Period, excel was automatically reversing it to S2:T2, no idea why, so i reversed the columns in my spread sheet so S was the year and T the period and while all my balance sheet and income statement tags are fine i still got #VALUE for shares outstanding. In the end it was the year it did not like. I use a relative reference

=IFERROR(@IntrinioFundamentals(A2:"income_statement":R2:U2:"fiscal_year"):"")

Where R=QTR and U= 0 for most recent.

fortunately the period

=@IntrinioFundamentals(A2:"income_statement":R2:U2:"fiscal_period")

and ticker i enter manually don't seem to upset the adjweightedavedilutedsharesos Tag so i'll just deal with it at this point update manually. Thanks for trying.

0 ·
Share

The equation is missing commas. Review the documentation (https://docs.intrinio.com/documentation/excel/getting_started) and previously answered response (https://community.intrinio.com/comments/781/view.html ):

=IntrinioFinancials(A2,"calculations",T2,S2,"adjweightedavedilutedsharesos","A")

=IntrinioFinancials("AMZN","calculations","2020","Q2","adjweightedavedilutedsharesos","A")

0 ·
Share

**2** People are following this question.

Having trouble with the Excel API Add-in 1 Answer

Excel API error: Cannot run macro 1 Answer