Microsoft Excel is multifaceted, versatile software that can be used for many functions. The built-in features of Excel make it a very good tool to manipulate and analyze data. Stock market data is probably some of the most manipulated and analyzed data on the planet. For the small investor, using Excel to sort, inspect, graph and analyze stock information is a natural fit.
Step 1
The add-in you need is RCH_Stock_Market_Functions.xla at the smf_addin group files. Be sure to install the add-in in the directory C: Program Files SMF Add-In in order for the spreadsheet to work. The SMF (Stock Market Functions) add-in adds a number of functions to EXCEL that can allow data to be extracted and/or retrieved from the web and placed directly into EXCEL cells or ranges. > the SMF folder, select the 'RCH_Stock_ Market_Functions', and click 'OK'. > At this point Excel informs me that a file with that name already exists in > that location and asks if I want to replace it. How do I get historical stock data for all of the stocks of NSE in an Excel spreadsheet? Update Cancel. Chenanda Shithil Nanaiah. Download this application.install it. Set your preference. Best way of not losing money in stock market is not to trade in stock market:P. SMF Addin Documentation - Free download as PDF File (.pdf), Text File (.txt) or read online for free. Stock Market Functions - Excel Addin Documentation. 2 Documentation for RCHGetElementNumber() function.
Open Internet Explorer or Firefox and navigate to the Yahoo! Finance website. The finance site can be found by first going to the Yahoo! main page and selecting the finance category.
Step 2
Enter the stock quote information desired in the text entry box next to the 'Get Quotes' button. Enter 'F' to receive information on Ford Motor Company. Multiple stocks can be received by using a blank space to separate them. Entering 'F GE WMT' would return Ford , General Electric and Wal-Mart. Press the 'Get Quotes' button to recieve the stock information.
Step 3
After the page with your selected quotes has loaded, click on the link 'Download to Spreadsheet.'
Step 4
Click on 'Open' when the prompt box is displayed on your screen. This will open Excel with the stock data in the spreadsheet.
Select 'File' then 'Save As' to save the data to an Excel spreadsheet on your computer. Use the 'Save As' function, as the data opened in the spreadsheet will be in read-only mode. The .csv file type that the information comes in is short for comma separated values, which uses a comma to delineate the individual values in the file.
Tips
- After you have entered in many stock quotes and clicked 'Get Quotes', bookmark the page. This will keep you from having enter the stocks in for subsequent requests.
- If Excel is not available, you can use the spreadsheet program found in the OpenOffice suite called Calc, which is a free, open source spreadsheet similar to Excel.
Items you will need
- Internet Explorer or Firefox browser
- Microsoft Excel
Video of the Day
Rch Stock Market Functions Download Free
More Articles
Rch Stock Market Functions Download
This question is about using a set of functions found on yahoo.financial.groups.justcovered calls. The issues are in the material below.
The issues are followed by the responses of the author of the system. So far, I do not understand what the responses mean.
John and I think the problem is with the 'link' function. The value of the system is that it repopulates the functions in real time. The author refers to the link issue arising'whenever the person opening the workbook with add-in formulas has the add-in in a different location than the person that saved the workbook.'
Can anyone help?
Gene Farber
Re: [justcoveredcalls] RCH SMF