question

peterjamesduff avatar image
0 Likes"
peterjamesduff asked ·

Tag for outstanding shares not working

=@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.

excel api
10 |600 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

peterjamesduff avatar image
0 Likes"
peterjamesduff answered ·

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.




· Share
10 |600 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

wtschwalbe avatar image
0 Likes"
wtschwalbe answered ·

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")

· Share
10 |600 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.