# Stock Watchlist **URL:** \ **Category:** Ask for Help\ **Created:** [December 17, 2020, 7:47pm UTC](https://community.glideapps.com/t/stock-watchlist/20005 "2020-12-17T19:47:40Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Joevestor](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joevestor/32/18301_2.png) [@Joevestor](https://community.glideapps.com/u/Joevestor)\ **Post date:** [December 17, 2020, 7:47pm UTC](https://community.glideapps.com/t/stock-watchlist/20005/1 "2020-12-17T19:47:40Z")
I’m trying to make a watchlist tab in my app for stocks where the user can search a stock by its Ticker and add it to their watchlist. I don’t even know where to start. I know I have to incorporate Google finance into this, but I need help. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 18, 2020, 1:01am UTC](https://community.glideapps.com/t/stock-watchlist/20005/2 "2020-12-18T01:01:27Z")
To let the users search a “database” of stock information, you would need to have that list in your Sheet first, then populate the stock data using Google Finance. ---
**Author:** ![Joevestor](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joevestor/32/18301_2.png) [@Joevestor](https://community.glideapps.com/u/Joevestor)\ **Post date:** [December 18, 2020, 5:03am UTC](https://community.glideapps.com/t/stock-watchlist/20005/3 "2020-12-18T05:03:31Z")
So I would would have to type every stock into my google sheets? Or is there an easier way of doing this? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 18, 2020, 11:32am UTC](https://community.glideapps.com/t/stock-watchlist/20005/4 "2020-12-18T11:32:08Z")
Yeah I think so, I don’t know if there’s a database somewhere you can import into Google Sheets. ---
**Author:** ![Joevestor](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joevestor/32/18301_2.png) [@Joevestor](https://community.glideapps.com/u/Joevestor)\ **Post date:** [December 18, 2020, 5:10pm UTC](https://community.glideapps.com/t/stock-watchlist/20005/5 "2020-12-18T17:10:57Z")
Dang, I won’t be able to type in every stock… ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 18, 2020, 8:19pm UTC](https://community.glideapps.com/t/stock-watchlist/20005/6 "2020-12-18T20:19:01Z")
> **[public-apis/public-apis - Finance](https://github.com/public-apis/public-apis#finance)** > > A collective list of free APIs for use in software and web development. ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [December 18, 2020, 8:27pm UTC](https://community.glideapps.com/t/stock-watchlist/20005/7 "2020-12-18T20:27:35Z")
here is ticker tracker and foreign X app…allows you to convert from c of 141 countries- its all live info > **[tickerT & foreignX](https://foreignx.glideapp.io/)** > > Live track top tech & social media tickers, track & manage your stock portfolio, & live track & convert from 141 ISO 4217 currencies s to the top 40 ISO 4217 currencies. Conversion calculations are back to back. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 19, 2020, 4:41am UTC](https://community.glideapps.com/t/stock-watchlist/20005/8 "2020-12-19T04:41:05Z")
You could actually make a cell pull from google finance with the ticker blank and pointing to the cell in which is being edited when the ticker is populated it finishes the formula and a add button copies current formula that has that ticker in it. Also if you are looking to find a way to search through google finance with glide you can do the search the same way. It will take a little time due to Glide refresh and google sheets refresh not being so quick. But use an API for this and Glide relations and it will be almost seamless.