MacQueen

You've loaded an old revision of the document! If you save it, you will create a new version with this data.

====== Stocks ======

===== 2025 4 26 =====

* 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!

===== 2025 3 21 =====

* 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.

===== 2024 12 11 =====

* 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

===== 2024 12 09 =====

* 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.

===== 2024 09 01 =====

* 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

==== 2023 11 15 ====

* 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 
 
====2022 02 04====
  * 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

=====2021 2 26=====
  * 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!

==== Selling ====

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

==== To do ====
  * Get TRP SEP-IRA merged
  * Where did new horizons come from?

==== Vanguard ====

* Fully invested except for $2k
  * Select the individual fund form the list to trade.
  * Consolidate the IRAs once all the money gets there.
 
====Fidelity====
  * Fine
  * Fees <code>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. </code>

====TRP====
  * About $60k left to invest

====Spreadsheet====

- 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.
  - EA is .15 * (amount invested / number of funds with dollars invested).
  - 2021/12/3 - new percentage calc in FSRFX checks that dollars invested is > zero.

====Add New Funds====

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

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

Edit summary

Note: By editing this page you agree to license your content under the following license: CC Attribution-Share Alike 4.0 International