A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | README | ||||||||||||||||||
2 | Wed, 02 Oct 2024 | ||||||||||||||||||
3 | |||||||||||||||||||
4 | |||||||||||||||||||
5 | |||||||||||||||||||
6 | STEP 1 | In the "PORTFOLIO" tab, insert the following inputs | HOW TO FIND COMPANY TICKER | MARKET COVERAGE | |||||||||||||||
7 | a) | Ticker | Using Google search, type in the "company name" followed by "share price" | Here are a list of our stock market coverage | |||||||||||||||
8 | See "How To Find Company Ticker" | For example, "ferrari share price". Here's a screenshot. | Australia | Mexico | |||||||||||||||
9 | b) | Date purchased | Austria | Netherlands | |||||||||||||||
10 | Date which shares were purchased | Belgium | Poland | ||||||||||||||||
11 | c) | # of shares | Brazil | Russia | |||||||||||||||
12 | Number of shares purchased | Canada | Saudi Arabia | ||||||||||||||||
13 | d) | Avg purchased price | Denmark | South Africa | |||||||||||||||
14 | Average purchased price | Finland | South Korea | ||||||||||||||||
15 | e) | Industry | France | Spain | |||||||||||||||
16 | Select the industry that best fits the stock from list | Germany | Sweden | ||||||||||||||||
17 | STEP 2 | Hit the "Refresh" once all inputs have been done | Hong Kong | Switzerland | |||||||||||||||
18 | *Note this needs to be refreshed every time after new inputs | India | Turkey | ||||||||||||||||
19 | STEP 3 | In the "DASHBOARD" TAB, the required inputs are | Indonesia | UK | |||||||||||||||
20 | a) | Base currency | The ticker you're looking for is BIT:RACE | Israel | US | ||||||||||||||
21 | Currency which PnL will be calculated | Make sure there are no spaces between the letters for tickers. | Italy | ||||||||||||||||
22 | b) | Benchmark | That's it! | ||||||||||||||||
23 | Relative index which alpha and beta are calculated. | ||||||||||||||||||
24 | STEP 4 | Click "Update" button | Don't forget to read the disclaimer. Invest at your own risk. | ||||||||||||||||
25 | *Note this needs to be updated every new trading day | ||||||||||||||||||
26 | HOW TO AUTHORISE APP SCRIPT | ||||||||||||||||||
27 | Please visit the link here. You will only need to enable once. | ||||||||||||||||||
28 | Please contact us at here if you have any feedback or ideas to improve. | ||||||||||||||||||
29 | ZagInvestor.com | ||||||||||||||||||
30 | Copyright 2020. All rights reserved. | ||||||||||||||||||
31 | |||||||||||||||||||
32 | |||||||||||||||||||
33 | |||||||||||||||||||
34 |