' Last Update: 20200212 

' Local Path: "C:\DAN\Budget\Fidelity\Retirement\_Watchers\qry_Trump_Effect.txt"

  SELECT MID([D.FUND_NAME],1,30) AS NAME_30, W.AS_OF, W.SYMBOL, W.PRICE,
         FORMAT ((5000/W.PRICE), "#.0") AS SH_4_5K, W.NOTES
    FROM tbl_Watchers AS W, tbl_SYM_DESC_01 AS D
   WHERE W.AS_OF IN (#11/04/2016#, #11/14/2014#, #12/31/2015#, #12/30/2016#,
                     #01/03/2017#, #06/30/2017#, #09/29/2017#, #12/27/2017#,
                     #2/24/2018#,  #12/31/2018#, #1/2/2019#,   #3/29/2019#,
                     #6/29/2019#,  #10/4/2019#, #11/22/2019#,  #1/10/2020#,
                     #1/31/2020#,  #2/11/2020#
                    )
     AND W.SYMBOL NOT IN ("F_ALL")
     AND W.SYMBOL  = D.SYMBOL
ORDER BY W.SYMBOL, W.AS_OF DESC
         ;