Guest User

Untitled

a guest
Jul 16th, 2018
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.59 KB | None | 0 0
  1. query="SELECT B,N,E,G,H,I WHERE A='Exited Positions Bullish Stocks'"
  2.  
  3. query="SELECT B,N,E,G,H,I WHERE A='Exited Positions Bullish Stocks' and G>NOW()-30"
  4.  
  5. [gdoc key="https://docs.google.com/a/justinhandley.com/spreadsheets/d/15q2H_X0nohUJs8vgZ6NFiHrtU5lBKrEQLM1dJoQgB6E/edit" gid="2078888428" class="no-datatables" query="SELECT B,N,E,G,H,I WHERE A='Exited Positions Bullish Stocks' "]
  6.  
  7. [gdoc key="https://docs.google.com/a/justinhandley.com/spreadsheets/d/15q2H_X0nohUJs8vgZ6NFiHrtU5lBKrEQLM1dJoQgB6E/edit" gid="2078888428" class="no-datatables" query="SELECT B,N,E,G,H,I WHERE A='Exited Positions Bullish Stocks' "]
  8.  
  9. [gdoc key="https://docs.google.com/a/justinhandley.com/spreadsheets/d/15q2H_X0nohUJs8vgZ6NFiHrtU5lBKrEQLM1dJoQgB6E/edit" gid="2078888428" class="no-datatables" query="('VR Platinum'!A:N, "SELECT * WHERE A='Exited Positions Bullish Stocks' AND G >= date '" & TEXT(NOW()-30, "yyyy-MM-dd") & "' ") "]
  10.  
  11. [gdoc key="https://docs.google.com/a/justinhandley.com/spreadsheets/d/15q2H_X0nohUJs8vgZ6NFiHrtU5lBKrEQLM1dJoQgB6E/edit" gid="2078888428" class="no-datatables" query="SELECT B,N,E,G,H,I WHERE A='Exited Positions Bullish Stocks' AND G >= date '" & TEXT(NOW()-30, "yyyy-MM-dd") & "' "]
  12.  
  13. =QUERY(DATA, "SELECT B WHERE A='Exit' AND G >= date '" & TEXT(NOW()-30, "yyyy-MM-dd") & "' ")
  14.  
  15. =QUERY('VR Platinum'!A:N, "SELECT * WHERE A='Exited Positions Bullish Stocks' AND G >= date '" & TEXT(NOW()-30, "yyyy-MM-dd") & "' ")
  16.  
  17. =QUERY('VR Platinum'!A:N, "SELECT * WHERE AND G >= date '" & TEXT(NOW()-30, "yyyy-MM-dd") & "' ")
  18.  
  19. query="SELECT B,N,E,G,H,I WHERE A='Exited Positions Bullish Stocks'"
Add Comment
Please, Sign In to add comment