Spreadsheet: 166977d1341857086-weighting-calculation-with-the-ability-to-remove-and-add-specific-stocks-in-weighting-dummy-work-book
Sheet: Sheet1

Company names | Number of shares | Price | Price x Shares | Weight | Cross off?
a | 1.256927895539535 | 62.85 | 78.99791823465979 | 1.579867734585445 | n | 1.579867734585445
b | 0.5283539425959427 | 89.47 | 47.27182724405899 | 0.2791578886566767 | n | 0.2791578886566767 |  |  |  | if you want to cross off some then remove any characters from row F
c | 0.7644402583127707 | 77.88 | 59.53460731739858 | 0.5843689085292957 | n | 0.5843689085292957
da | 0.7095217514213025 | 40.48 | 28.72144049753432 | 0.5034211157399525 | n | 0.5034211157399525
gag | 3.183614005795405 | 9.997 | 31.82658921593666 | 10.13539813789667 | n | 10.13539813789667
hd | 1.553249320703954 | 56.1 | 87.13728689149184 | 2.412583452267296 | n | 2.412583452267296
sfsdg | 1.397484682123797 | 57.1 | 79.79637534926881 | 1.95296343677065 | n | 1.95296343677065
gdsgsd | 8.69203458438926 | 5.181 | 45.03343118172076 | 75.55146521621897 | n | 75.55146521621897
herher | 0.5432543824763463 | 56.42 | 30.65041225931546 | 0.2951253240797563 | n | 0.2951253240797563
j | 1.687103503598443 | 29.2 | 49.26342230507455 | 2.846318231854143 | n | 2.846318231854143 |  |  |  |  | TOTAL
trere | 0.9626239276418621 | 13.51 | 13.00504926244156 | 0.9266448260686448 | n | 0.9266448260686448 |  |  |  |  | 1404.918890339146
a | 9.133203598845148 | 2.66 | 24.29432157292809 | 83.41540797795795 | n | 83.41540797795795
fghgdfh | 1.225975693834902 | 14.761 | 18.09662721669698 | 1.503016401873968 | n | 1.503016401873968
adh | 1.506443567177938 | 35.335 | 53.23018344623243 | 2.269372221091789 | n | 2.269372221091789
dfh | 1.035421249734717 | 49.83 | 51.59504087428094 | 1.072097164402203 | n | 1.072097164402203
adf | 1.573813282461365 | 27.385 | 43.09887674020448 | 2.476888248051816 | n | 2.476888248051816
had | 5.034672130843666 | 8.502 | 42.80478245643285 | 25.3479234650939 | n | 25.3479234650939
fhad | 10.76973231282956 | 2.44 | 26.27814684330412 | 115.9871340900051 | n | 115.9871340900051
fhd | 4.475517249474359 | 16.87 | 75.50197599863245 | 20.03025465034253 | n | 20.03025465034253
tue | 3.381551800340122 | 16.84 | 56.94533231772765 | 11.43489257838352 | n | 11.43489257838352
5e | 0.3599450768390388 | 73.56 | 26.47755985227969 | 0.1295604583406615 | n | 0.1295604583406615
frh | 3.225391094377287 | 10.18 | 32.83448134076078 | 10.40314771168831 | n | 10.40314771168831
djkyktykd | 2.257880343187423 | 9.94 | 22.44333061128298 | 5.098023644152153 | n | 5.098023644152153
gh | 2.31488667124585 | 18.055 | 41.79527884934382 | 5.358700300711692 | n | 5.358700300711692
fdghj | 6.451911789208141 | 3.3 | 21.29130890438687 | 41.627165735723 | n | 41.627165735723
fghgdfh | 6.526262392814884 | 5.066 | 33.0620452820002 | 42.59210081986985 | n | 42.59210081986985
rjsfg | 23.60792135392318 | 1.012 | 23.89121641017026 | 557.3339506530222 | n | 557.3339506530222
fgjsfg | 1.561072460856928 | 12.145 | 18.95922503710739 | 2.436947228045906 | n | 2.436947228045906
sere | 0.3582563492027588 | 79.67 | 28.54228334098379 | 0.128347611744089 | n | 0.128347611744089
ejjtrt | 0.4515924941714155 | 120.75 | 54.52979367119842 | 0.20393578079196 | n | 0.20393578079196
rjrjtrs | 0.272039457594427 | 111.6 | 30.35960346753806 | 0.07400546648827007 | n | 0.07400546648827007
fhad | 6.328704406894919 | 1.547 | 9.79050571746644 | 40.05249946985117 | n | 40.05249946985117
fhd | 0.4028368622468295 | 92.47 | 37.25032465196433 | 0.1622775375848711 | n | 0.1622775375848711
wed | 1.560506437191125 | 15.505 | 24.1956523086484 | 2.43518034051494 | n | 2.43518034051494
5e | 1.279787411046577 | 12.27 | 15.7029915335415 | 1.637855817473301 | n | 1.637855817473301
frh | 0.8270246098845557 | 32.785 | 27.11400183506516 | 0.6839697053547016 | n | 0.6839697053547016
djkyktykd | 15.81974665336175 | 4.899 | 77.50093885481921 | 250.2643841765503 | n | 250.2643841765503
gh | 1.562084583716753 | 45.55 | 71.15295278829808 | 2.440108246685541 | n | 2.440108246685541
fdghj | 2.036532763219304 | 59.75 | 121.6828326023534 | 4.147465695665652 | n | 4.147465695665652
fghgdfh | 0.9274047901825774 | 43.095 | 39.96650943291817 | 0.8600796448535903 | n | 0.8600796448535903
rjsfg | 0.8975681521226617 | 35.785 | 32.11947632370945 | 0.8056285877048898 | n | 0.8056285877048898
fgjsfg | 0.7402357405925191 | 28.18 | 20.85984316989719 | 0.5479489516505551 | n | 0.5479489516505551
sere | 1.491131893172726 | 66.64 | 99.36902936103047 | 2.223474322836879 | n | 2.223474322836879
ejjtrt | 1.3115215845947 | 17.525 | 22.98441577002212 | 1.720088866857794 | n | 1.720088866857794
rjrjtrs | 6.725595473603812 | 9.875 | 66.41525530183765 | 45.23363447456009 | n | 45.23363447456009
fhad | 3.75265481004949 | 36.06 | 135.3207324503846 | 14.08241812338757 | n | 14.08241812338757
fhd | 2.624221766094466 | 26.935 | 70.68341326975442 | 6.886539877643956 | n | 6.886539877643956
thu | 0.1541791690362526 | 149.05 | 22.98040514485345 | 0.02377121616470936 | n | 0.02377121616470936
5e | 2.159231751583722 | 14.62 | 31.56796820815401 | 4.662281757047307 | n | 4.662281757047307
frh | 0.2430988406179814 | 130.9 | 31.82163823689377 | 0.05909704630980674 | n | 0.05909704630980674