Hi everybody there. I want to keep records of Daily Share prices. I have list of around 1800 plus companies from which i have sorted out for example say 500 companies. I download daily price and trading quantity of 1800plus companies and have to sit and work out to delete unwanted names of the companies and price to keep the companies only which are in my list. I have made graphs of important companies in Excel program. After sorting the companies i copy and paste in each file where i have graphs which automatic updates.
What i need is a software or programing in Excel to sort out the companies and their price daily from the download complete list and keep aside the unwanted companies so that i can check the separated companies to see if there is any new company and than delete all myself. By this i only have to copy paste everyday the price and trading quantity of companies in mylist to update the graphs.
Can somebody help me for this.
Thanks in advance and Best regards
Additional Information - Is an '05 Honda Civic Sedan DX-G SE worth $13,888 CAD? Is an '05 Honda Civic Sedan DX-G SE with 53,500 KM (33K miles) worth ,888 Canadian? See, what happened was, we got this '04 Honda Civic Sedan DX for ,527, but the dealership kind of messed us up. Apparently, it's an uncommon thing (though, at this point, how well do......
- Online Stocks? I've been told that online stock sites allow 4 trades within 5 business days and that a "sell" is a trade. You can "sell" 4 times in 5 days. So, when exactly does this 5 day count start?? As soon as I buy and sell 4 stocks.. or even when......
- Alternative Income Streams Progress - Early December This is the fourth installment tracking of my alternative income streams plan and progress. This month I'm showing very good progress in creating more money outside my job. I had at least 6 Prosper.com loans get verified in the last two weeks and this blog has been getting a little......
- Weight Tracking (Last Attempt) Total Weight Lost: 58lbs Here is my weight tracking page... It will evolve as I get more accustomed to my new lifestyle, but for starters if you want to know about the Jumpstart Medicine weight loss program that I am following read this post WeightLadder Reset — 390lbs and Starting......
Chris I 9th March 2010
VLOOKUP() should work for your needs, as long as the company names in your spreadsheet match exactly with the info you download.
Basically, it’s a formula that searches a table for matches (in your case the company name) and returns a cell next to it (any length away is fine). Assuming all your data is on the same row, this should work.
In this example, I have your company name you want to look up in A1. The data copied from your daily source is in sheet3,A1:F1800. And the share price is the third column in this table. The name has to be the first column of this table. I give the price as the third column because the second might be volume or something.
=VLOOKUP(A1, Sheet3!$A$1:$F$1800, 3, FALSE)
If your data is formatted weird (multiple lines per company, and the name and price is on different lines), this may not work.
If the data is displayed horizontally (not normal), and the company names are all on one row, and the share price is below each name, you need HLOOKUP().