# Automatically populate a cell **URL:** \ **Category:** Ask for Help\ **Created:** [August 22, 2020, 5:16pm UTC](https://community.glideapps.com/t/automatically-populate-a-cell/14420 "2020-08-22T17:16:27Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Petervb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/petervb/32/13486_2.png) [@Petervb](https://community.glideapps.com/u/Petervb)\ **Post date:** [August 22, 2020, 5:16pm UTC](https://community.glideapps.com/t/automatically-populate-a-cell/14420/1 "2020-08-22T17:16:27Z")
Hi I’m a very impressed newbie to glide. I’m also new to google sheets. My sheet is a simple one that tracks some recent investments. So does my new app 😀 I’m curious if anyone in this community could tell me how to format a cell so that it is updated daily with the closing market price of ethereum, Apple and Tesla ? Thanks ---
**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:** [August 22, 2020, 11:55pm UTC](https://community.glideapps.com/t/automatically-populate-a-cell/14420/2 "2020-08-22T23:55:25Z")
Would GoogleFinance formula work for you in this case? ---
**Author:** ![Petervb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/petervb/32/13486_2.png) [@Petervb](https://community.glideapps.com/u/Petervb)\ **Post date:** [August 23, 2020, 3:45am UTC](https://community.glideapps.com/t/automatically-populate-a-cell/14420/3 "2020-08-23T03:45:45Z")
Hi I don’t know? Maybe If it’s a google product, it’s probably compatible. I’m totally new to sheets, so I I’m impressed that I was able to figure out how to make formulas like + - x / % sum average 😀 Plus having my spreadsheet as an app, I’m beaming ! Any help would be appreciated. Thanks ---
**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:** [August 23, 2020, 3:51am UTC](https://community.glideapps.com/t/automatically-populate-a-cell/14420/4 "2020-08-23T03:51:40Z")
[https://support.google.com/docs/answer/3093281?hl=en](https://support.google.com/docs/answer/3093281?hl=en) You can read about its syntax here. ---
**Author:** ![Petervb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/petervb/32/13486_2.png) [@Petervb](https://community.glideapps.com/u/Petervb)\ **Post date:** [August 23, 2020, 4:20am UTC](https://community.glideapps.com/t/automatically-populate-a-cell/14420/5 "2020-08-23T04:20:17Z")
OMG ! You are AWESOME !!! Thank you !, Peter ---
**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:** [August 23, 2020, 7:29am UTC](https://community.glideapps.com/t/automatically-populate-a-cell/14420/6 "2020-08-23T07:29:30Z")
My pleasure Peter. Make sure you ask questions when you get stuck, we’ll always try to help. ---
**Author:** ![Petervb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/petervb/32/13486_2.png) [@Petervb](https://community.glideapps.com/u/Petervb)\ **Post date:** [August 29, 2020, 6:41am UTC](https://community.glideapps.com/t/automatically-populate-a-cell/14420/7 "2020-08-29T06:41:53Z")
I’m officially losing it here Added a Tab, a pie chart… The data that shows is accurate, but why does the chart look like this? ![image.jpg](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/8c77984b9d4899dc3cf3e7da84a9fb425dbcaea0.jpeg) I’m aiming for pie slices And why is AAPL featured? My brain is now mush Good nite and thank you Peter ---
**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:** [August 29, 2020, 4:33pm UTC](https://community.glideapps.com/t/automatically-populate-a-cell/14420/8 "2020-08-29T16:33:44Z")
Seems like you’re setting the wrong fields for the chart. I read it as each money value happens once. ---
**Author:** ![Petervb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/petervb/32/13486_2.png) [@Petervb](https://community.glideapps.com/u/Petervb)\ **Post date:** [August 30, 2020, 3:21am UTC](https://community.glideapps.com/t/automatically-populate-a-cell/14420/9 "2020-08-30T03:21:26Z")
Thank you. I stayed away from the app all day after reading your answer. Had real things to do, so just pondered it. Re-examined the fields tonight when I got home. My pie chart Tab looks and works great now ! Thanks, Peter ---
**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:** [August 30, 2020, 3:25am UTC](https://community.glideapps.com/t/automatically-populate-a-cell/14420/10 "2020-08-30T03:25:25Z")
Nice, tell me if I can help!