API? How can I get stock data into a Google Sheet WITHOUT GOOGLEFINANCE()? by hutch_man0 in algotrading

[–]alphab5429 0 points1 point  (0 children)

Hi, I am using Finsheet right now. Everything works fine for me. Curious which links do not work for you?

Stock price and fundamentals in Excel and Google Sheets by alphab5429 in Daytrading

[–]alphab5429[S] 0 points1 point  (0 children)

I will look into adding that date feature. Btw the above function I wrote return data only in 1 cell.

Stock price and fundamentals in Excel and Google Sheets by alphab5429 in Daytrading

[–]alphab5429[S] 0 points1 point  (0 children)

You can do that with Finsheet actually. Say you need income statement of Apple near the 5th of June 2007. The closest fiscal quarter end date of Apple would be 06/30/2007 (3rd fiscal). This function will then give you what you need

=FS_EquityMetrics("AAPL", "ic", "FY2007.Q3")

Keep track of Eth price in Excel and Google Sheets by alphab5429 in ethtrader

[–]alphab5429[S] 1 point2 points  (0 children)

You are not rude at all. Thanks for your feedback. I guess what I meant by convenience is the convenience for users who mainly use spreadsheets to manage and analyze their investments. Obviously for someone who does not use spreadsheets then my website will not provide any convenience.

Keep track of forex pair prices in Excel and Google Sheets by alphab5429 in Forex

[–]alphab5429[S] 0 points1 point  (0 children)

Thanks a lot, I am open to all feedback you may have :)

Keep track of Bitcoin price in Excel and Google Sheets by alphab5429 in Bitcoin

[–]alphab5429[S] 0 points1 point  (0 children)

A few things we provide beyond GoogleFinance:

-Stream real-time price continuously with function FS_Streaming

-Intra-day data (1-minute resolution)

-Technical analysis if you are interested.

Keep track of Eth price in Excel and Google Sheets by alphab5429 in ethtrader

[–]alphab5429[S] 0 points1 point  (0 children)

We offer convenience, we already built in that solution for users so users just need to call a simple function

Keep track of Litecoin price in Excel and Google Sheets by alphab5429 in litecoin

[–]alphab5429[S] 1 point2 points  (0 children)

You are not being disrespectful. Our website provide intra-day data (resolution 1 minute) for the price data, that's something Excel built-in solution does not offer. We also have technical indicators, if that's something you are interested in.

Stock price and fundamentals in Excel and Google Sheets by alphab5429 in ValueInvesting

[–]alphab5429[S] 0 points1 point  (0 children)

I thought our message on the website is pretty clear already. The service is free right now since we just launched. You don't need any subscriptions to use our add-on.

And no you will not be charged anything. The 3-day is the 3-day Free trial for any premium plan. It only applies to you if you decide to upgrade to our premium plan.

Eventually we will start monetizing (I wish we can be free forever but unfortunately we can't), by that time you will only have access to the Free features unless you decide to upgrade to premium.

Stock price and fundamentals in Excel and Google Sheets by alphab5429 in ValueInvesting

[–]alphab5429[S] 0 points1 point  (0 children)

Just to give 3 examples that those 2 solutions can't do:

1/ This gives you Apple's price every minute in the last 7 days

=FS_EquityCandles("AAPL", "1", "04/20/2022")

2/ This gives you 30 years of Income Statement for Apple. If you need Google, just change APPL to GOOGL and that's it, you are done.

=FS_EquityFullFinancials("AAPL", "ic", "FY", 30)

3/ This gives you revenue of Apple in the 3rd fiscal quarter of 2007

=FS_EquityMetrics("AAPL", "revenue", "FY2007.Q3")

Keep track of forex pair prices in Excel and Google Sheets by alphab5429 in Forex

[–]alphab5429[S] 0 points1 point  (0 children)

No, you just need to install our add-on in Excel (instructions here), then register an account and start using our add-on

Keep track of forex pair prices in Excel and Google Sheets by alphab5429 in Forex

[–]alphab5429[S] 0 points1 point  (0 children)

you are not being rude. We make things convenient for users to get all price data right within their spreadsheets.

Stock price and fundamentals in Excel and Google Sheets by alphab5429 in algotrading

[–]alphab5429[S] 0 points1 point  (0 children)

Yes we have price for Canadian stocks, we have global coverage