Stocks

Excel

• Fidelity balance is minus the LOC
• The download is correct.

• To add a new stock, update funds.csv, prices.xlsx, alpha, yahoo, and change line 113 in resetPrices.py
• be sure the cash line includes all new purchases
• be sure the total at the far right includes all current values

• To trade in Schwab, buy the stock then sell the $ amount in SNVXX.
• John is in SLV.

• VanEck Gold Miners ETF (GDX)
• MAGA ETF

• Installed Excel 2010 32 bit.
• Also downloaded but did not install Visual Basic 2010 Express.
• Not sure if it is needed.
• new version of resetPrices.py and uptdatePrice.py to write to prices.xlsx.
• Excel 2010 will convert .xls to .xlsx but blows away the .xls file.
• copied all .xls file to Copied sub directory.
• opened each file.
• replaced indirect.ext] with indirect].
• replaced .xls] with .xlsx].
• then converted to .xlsx.
• some cells in val.xls were missing Van4 in summations.
• recorded a macro in consolidatedDaily.xlsm (.xls with macro) to open all referenced files with ctrl-o
• seem to work ok, but need more comparison with older .xls files.
• new version of resetPrices.py and uptdatePrice.py to write to prices.xlsx.
• capitalization important when referencing sheet names.

• Excel 1997 will not install on current Win 10
• Excel 2003 (not sure where that came from) craps out at 95% loading ConsalidatedDaily
• Must got to 2010!

• In Excel 2010 use ='Z:\Filepath\[File.xlsx]SheetName'!A1 instead of using INDIRECT
• Look at AY999 if getting #REF!. The formula will show where the #REF is.

• no more stock history at yahoo
• Highs and lows at https://www.barchart.com
• use marketwatch - https://www.marketwatch.com/investing/fund/VIG/download-data
• to add a new stock, add it to
  • funds.csv
  • prices.xls which must exist. it does not get created by updatePrices.py
  • yahoo where the order is not important. updatePricesfigures it out
  • create new worksheet with proper name in the ARM model
  • update consolidatedDaily

• Problems with Van4 locking up when pasting prices from check
• pasting one by one found a circular reference to the summary at the right had columns.
• The suggested “buy” of $12 is problematic and probably not needed at all.

• Excel is MS Office 2000.
• ISO on Synology
• Use add-on More func from https://ccm.net/downloads/professional/6989-morefunc-macro-add-in-for-excel/?n=&version=windows

• got a copy of 64 bit excel from pirate bay and installed it.
• consolidatedDaily does not come up becasue it uses indirect.ext
• would be a lot of work to conver to excel 2010
• put it on synshare/software.
• keys availabel on ebay for #29

• sold 14 last week and bought just 2 - FNARX and FFGCX 2022 02 04
• sold 14 last week and bought just 2 - FNARX and FFGCX

• Got 3 Buy signals on Vanguard Health VGHCX om 2/26/2021 and sold all 25k.
• If I'd sold just the recommended 8k, I would be ahead $1600 on 9/13/2021.
• Never sell all!

• On TRP, select Exchange, then From fund.
• On Vanguard, select Sell, then pick fund to sell.

• Get TRP SEP-IRA merged
• Where did new horizons come from?

• Fully invested except for $2k
• Select the individual fund form the list to trade.
• Consolidate the IRAs once all the money gets there.

• Fine
• Fees

  For our mutual fund accounts, we put messaging regarding 
   our account service fee on our second quarter statements, and in July 
   we send an email or letter to clients that are at risk of the fee. 
   We pull the balance information on the last business day of August, 
   and this information informs who is charged the account service fee. 
   The fee itself is assessed in early September every year.
  
  If there is anything else we can do to assist you, please feel free 
  to reply to this email. You may also call a customer service 
  representative at 1-800-225-5132. 

• About $60k left to invest

1. To calculate amount to sell, use Exchange Amount. If current week price is ⇐ 95% of last week's price, use 2 * EA if account balance is >= $1500 + 2 * EA. Otherwise use EA after balance check.
2. EA is .15 * (amount invested / number of funds with dollars invested).
3. 2021/12/3 - new percentage calc in FSRFX checks that dollars invested is > zero.

1. Copy an existing sheet, preferably one with few positions.
2. Update Yahoo with new symbols
3. update python/funds.csv.The order is not important; excel8.py figures it out
4. Rename the sheets and cell A1
5. Clear any buying history

1. In 25 September, use =IF(AM94>0, AM94/SUM(AJ$93:AJ94)-1,0)
2. Use custom Percentage formatting of 0.00%;[Red]-0.00%