Tracking stock prices using Python and Google Sheets
This looks very interesting. Well done!



Here is some nitpicking:


from yahoofinancials import YahooFinancials
import re
import pygsheets
import pandas as pd
import datetime




Organise these imports in following way: builtins, third-party then first-party.



 def main(sheet, everything,place):




Name of this function is sloppy. Use main function as an entry-point.
Name the function as a verb phrase or that explains what it is doing.
What is everything here? I can see that it is defined outside as well.
Avoid using everything as a name. It is very vague. 



for i in tickers:
    tick = YahooFinancials(i)




What is i here? Reserve i for integer indexes. These are ticker_names.
for ticker_name in tickers is more readable. 



tickers = ['XOM', 'JNJ', 'TR', 'CRON', 'HSY', 'FL', 'PLNT', 'MCD', 'ARLP', 'LULU', 'RCII', 'DELL', 'DNKN', 'DIS']




Load this from a JSON file.



def get_name(person):




This function doesn't get you anything. There is no return.
Why does this call main?
Name to sheet mapping can probably be loaded from a JSON as well.



adjclose, PY to Gsheet Test




Perform extract constant refactoring on strings like these and remove magic values. 



  A magic number is a direct usage of a number in the code.
  
  For example, if you have (in Java):
  
  public class Foo {
    public void setPassword(String password) {
         // don't do this
         if (password.length() &gt; 7) {
              throw new InvalidArgumentException("password");
         }
    }
}

  
  This should be refactored to:
  
  public class Foo {
    public static final int MAX_PASSWORD_SIZE = 7;

    public void setPassword(String password) {
         if (password.length() &gt; MAX_PASSWORD_SIZE) {
              throw new InvalidArgumentException("password");
         }
    }
}

  
  From: https://stackoverflow.com/questions/47882/what-is-a-magic-number-and-why-is-it-bad





Summary - This code is very hard to understand. Functions do things that are completely different from function-name. Variable names are vague. Contains lot of hard-coded values that can be extracted to a JSON or some other kind of config. Contains magic values that should be converted to meaningful constants.