Hi,
I tried to upload my MS Excel Eikon based template which contains three (3) worksheets but I'm keep getting this discussion board's uploading feature's error message that file is too big to be uploaded. I tried to delete two worksheets and have file uploaded with only one worksheet to reduce the file size but it's still showing me that the file is too big. I really wanted to upload the file Excel file (eikon template) here directly to my post because I'm assuming people who could possible help me won't want to use external downloading links but due to too large file size, uploading here just doesn't work. So I had to look up for the most trustworthy and most safe file uploading website and I came to WeTransfer. In case if you prefer me to deliver that file anyhow differently then please let me know. I uploaded my Excel template file on the following link:
I have three questions for each worksheet in existing template which I hope it is now downloaded and opened in front of you while reading this message. Please check my template of alternatively kindly let me know please how else could I deliver the file to you.
In each of three worksheets, you see the column D which is ''Volume'' and instead of assuming the answer, may I politely ask if you could please carefully check each column D of each worksheet and kindly inform me what Volume is this? You see the formulas that are taking care for auto updating of files when logged in from excel to eikon but I'm asking what Volume is this in all three columns D on all three worksheets? Is this Volume quantity of outstanding (floating) stocks or is this volume in currency unit which would mean quantity of outstanding (floating) stocks MULTIPLIED with price per stock? Again, I would like to politely ask again to please look at the file so you wouldn't think just ''volume is always...'' but then in reality in my file is something else.
Second question: For average of how many days is this ''Volume'' defined? How could I set that it's is for the average of my own wanted quantity of days (65)? It's very likely that the volume is for average of different quantity of days.
Third question: This has nothing to do with volume or above two questions. I would like to have between E and F column, added additional column. That would be stock instrument Market Cap of publicly traded company. Could anyone please tell me how can I add Market Cap of the publicly traded company into the worksheet? It's worth to emphasize that we cannot know in advance how many lines in total will there be after auto updating of the data.
Your 3 answers would be greatly appreciated.
Thank you in advance.