1. Watch this demonstration video about how to use the BTMA Stock Analyzer:\n<\/iframe><\/p>\n<p> <\/p>\n<p>2. While using the BTMA Stock Analyzer, you can get detailed information by clicking on the small blue information “i” icons found throughout the Analyzer.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4823\" src=\"http:\/\/www.beatthemarketanalyzer.com\/blog\/wp-content\/uploads\/2013\/01\/information-icon-buttons.jpg\" alt=\"\" width=\"591\" height=\"300\" srcset=\"https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-content\/uploads\/2013\/01\/information-icon-buttons.jpg 591w, https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-content\/uploads\/2013\/01\/information-icon-buttons-300x152.jpg 300w\" sizes=\"auto, (max-width: 591px) 100vw, 591px\" \/><\/p>\n<p> <\/p>\n<p>3. Watch\u00a0\u00a0here to learn how to use the Qualitative Analysis section of the BTMA Stock Analyzer:<br \/>\n<iframe loading=\"lazy\" src=\" https:\/\/www.youtube.com\/embed\/eBmaWIpVryE?rel=0&vq=large&autoplay=0&showinfo=0&autohide=1&modestbranding=1&controls=1\" width=\"750\" height=\"450\" frameborder=\"1\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p> <\/p>\n<p>4. If you have specific questions about any of the BTMA Stock Investing Products, please contact <a href=\"mailto:Grant@BeatTheMarketAnalyzer.com\" target=\"_blank\" rel=\"noopener noreferrer\">Grant@BeatTheMarketAnalyzer.com<\/a><\/p>\n<p><strong>Here are some of the BTMA products:<\/strong><br \/>\n<a href=\"http:\/\/www.beatthemarketanalyzer.com\/blog\/downloads\/purchase-btma-stock-analyzer\/\" target=\"_blank\" rel=\"noopener noreferrer\">BTMA Stock Analyzer<\/a><br \/>\n<a href=\"http:\/\/www.beatthemarketanalyzer.com\/btmawealthbuildersclub\" target=\"_blank\" rel=\"noopener noreferrer\">BTMA Wealth Builders Club<\/a><br \/>\n<a href=\"http:\/\/www.beatthemarketanalyzer.com\/weeks_best_stocks_to_buy_report\/\" target=\"_blank\" rel=\"noopener noreferrer\">“Best Stocks To Buy” Weekly Report<\/a><\/p>\n<p> <\/p>\n<hr \/>\n<h1><b>(OLD INFORMATION FOR DISCONTINUED Beat The Market Analyzer Spreadsheets Help & Troubleshooting Guide)<\/b><\/h1>\n<p> <\/p>\n<h2><b>Table of Contents:<\/b><\/h2>\n<p>Installation<\/p>\n<p>Help & Troubleshooting<\/p>\n<p>Contact<\/p>\n<p>Thank You<\/p>\n<p>Disclaimer<\/p>\n<hr \/>\n<p> <\/p>\n<h2><b>INSTALLATION<\/b><\/h2>\n<p><b><span style=\"color: #ff0000;\">Requirements: Must have Excel 2007 or newer.<br \/>\n(Not Compatible with Excel Starter versions)<br \/>\n<\/span><\/b>Your computer must be connected to the Internet for the Analyzer to function properly.<br \/>\nThe Analyzer works with Microsoft Excel on the Windows platform.<br \/>\nSorry, no Open Office or Mac Excel compatibility.<br \/>\nMac users: You will need to run Windows Excel on your Mac for the spreadsheet to work.<\/p>\n<p><strong>1. If you’ve downloaded the Analyzer and installed it, but it’s not working properly, then you may need to do a Manual Installation of the required SMF Add-in for Excel:<\/strong><\/p>\n<p style=\"padding-left: 30px;\">First make sure that you have properly downloaded all necessary files.<br \/>\nGo to your C: drive and see if there is a folder named “SMF”. It should contain several files inside the “SMF” folder. If you are missing the “SMF” folder or if it is empty, then you will need to locate the “SMF” folder on your computer and put it into the correct place.<\/p>\n<p style=\"padding-left: 30px;\">Click Start in the lower left hand corner of your computer screen.<br \/>\nIn the search blank, enter:\u00a0 SMF<br \/>\nAfter finding the location of the “SMF” folder,<br \/>\nRight click on the “SMF” folder.<br \/>\nSelect ‘Cut’.<br \/>\nOn your desktop or in the Start Menu, click on “Computer”.<br \/>\nYou will see the Local Disk (C:) or it might be named Vista (C:)<br \/>\nRight click on the Local Disk (C:)\u00a0 or Vista (C:)<br \/>\nNow paste the “SMF” folder into your C:<br \/>\n<strong><span style=\"color: #ff0000;\">The final location should look like this:\u00a0\u00a0\u00a0 C:\\SMF<br \/>\n(The SMF folder must be in the C:\\ for the BTMA Stock Spreadsheet to work properly.)<\/span><\/strong><\/p>\n<p style=\"padding-left: 30px;\">A message might say that “You need administrator permission…”, Just click continue.<\/p>\n<p style=\"padding-left: 30px;\">If you still don’t have permission to access Local Disk (C:), then you will need to ask your computer tech or the appropriate person to help you add the “SMF” folder to the Local Disk (C:)<\/p>\n<p style=\"padding-left: 30px;\">(For Norton Software users, you may want to check out this quick installation guide if you have problems with installation.<br \/>\n<a href=\"http:\/\/www.beatthemarketanalyzer.com\/blog\/wp-content\/uploads\/2013\/01\/BTMA-Windows-with-Norton-Installation.ppt\">BTMA\u00a0Installation with Norton Software<\/a>)<\/p>\n<p style=\"padding-left: 30px;\">Next, open the BTMA Installer file (It is located inside the SMF folder, there should also be a shortcut for it on your Desktop.)<br \/>\nIf you still can’t locate the “SMF” folder on your computer, then contact me at:<br \/>\nGrant(at)BeatTheMarketAnalyzer.com<br \/>\nIf you have the “SMF” folder with files inside of it, then move forward to the next step…<\/p>\n<p><strong>2. BTMA Installer File<\/strong><\/p>\n<p style=\"padding-left: 30px;\">First, be sure to quit Excel if it is running.<br \/>\nNext, open the file on your desktop named “BTMA Installer File”.<br \/>\nFollow the step-by-step instructions carefully and it will help you to correctly configure your computer to use the BTMA Spreadsheet.<br \/>\n(If you can’t open the BTMA Installer File or your computer can’t recognize it, then it probably means that you have an old version of Excel. You will need to download a full-version of Microsoft Excel 2007 or newer.)<a href=\"http:\/\/www.BeatTheMarketAnalyzer.com\/blog\/help\"><br \/>\n<\/a><br \/>\nAfter running the BTMA Installer File, your computer should be correctly configured. You can close the BTMA Installer File without saving changes. Then open the “BTMA Spreadsheet…” file located on your desktop.<\/p>\n<p><strong>3. If you have already run the “BTMA Installer File, and your Stock Spreadsheet is still not properly pulling stock data, then you will need to Manually Activate the SMF Excel add-in for Excel.<\/strong><\/p>\n<p style=\"padding-left: 30px;\">The instructions here are for manual activation of the SMF Add-in for Excel:<br \/>\nThey also apply to situations in which you move your SMF Excel add-in directory to a different location.<\/p>\n<p style=\"padding-left: 30px;\">A. Open Excel then press and hold down the ALT button for 3 seconds and while holding down the ALT button push the buttons \u201cT\u201d and \u201cI\u201d to display the Excel Add-Ins dialog box.<\/p>\n<p style=\"padding-left: 30px;\">B.\u00a0 If “Stock Market Function add-in” is checked, remove the checkmark and click OK to close the Add-Ins dialog box.* Then press and hold Alt+ti again, to redisplay the Add-Ins dialog box. This step is very important!<\/p>\n<p style=\"padding-left: 30px;\">C.\u00a0 In the Add-Ins dialog box, click Browse. A file selection dialog box will appear.<\/p>\n<p style=\"padding-left: 30px;\">D.\u00a0 Locate the SMF add-in directory. The location should be c:\\SMF. To navigate to the default directory, start by clicking the My Computer item then click Local Disk C:, and then go to the SMF folder.<\/p>\n<p style=\"padding-left: 30px;\">E.\u00a0 After you’ve navigated to the directory, select the RCH_Stock_Market_Functions.xla file name and click OK to return to the Add-Ins dialog box. If Excel asks if you want to replace the current location, click Yes.<\/p>\n<p style=\"padding-left: 30px;\">F.\u00a0 In the Add-Ins dialog box, make sure that the “Stock Market Function add-in” item has a checkmark next to it.<\/p>\n<p style=\"padding-left: 30px;\">G.\u00a0 Click OK to close the Add-Ins dialog box.<\/p>\n<p style=\"padding-left: 30px;\">H.\u00a0 For best results, close Excel and then re-start it. This step ensures that the add-in will be installed If Excel crashes during the current session.<\/p>\n<p style=\"padding-left: 30px;\">*After performing these steps, the SMC Excel add-in will be installed, and it will be opened automatically whenever you start Excel.<\/p>\n<p style=\"padding-left: 30px;\">I.\u00a0 After starting Excel, you’ll want to see if your SMF add-in is working properly now.<\/p>\n<p style=\"padding-left: 60px;\">a.\u00a0 In cell A1, type this exact formula:<br \/>\n=RCHGetYahooQuotes(“IBM”,”X”)<\/p>\n<p style=\"padding-left: 60px;\">b.\u00a0 Hit Enter.<\/p>\n<p style=\"padding-left: 60px;\">c.\u00a0 If the cell populates with some data, then your SMF add-in is now working properly and you should be able to start using your BTMA Stock Spreadsheet.<\/p>\n<p style=\"padding-left: 60px;\">If it doesn’t populate with data, then please email me:<br \/>\nGrant(at)BeatTheMarketAnalyzer.com<\/p>\n<p><strong> 4. BTMA Stock Spreadsheet<\/strong><\/p>\n<p style=\"padding-left: 30px;\">After running the BTMA Installer File, you will open your BTMA Spreadsheet. You can open it by clicking the BTMA Spreadsheet shortcut located on your Desktop. (There may be two shortcuts on your desktop: “BTMA Installer File” and “BTMA Spreadsheet…”. Open the “BTMA Spreadsheet…” file.)<\/p>\n<p><b><br \/>\n<\/b> <strong>5. Activation Code for your BTMA Stock Spreadsheet<\/strong><\/p>\n<p style=\"padding-left: 30px;\">The first time you open the BTMA Spreadsheet, it will ask you to activate. Follow the instructions by copying the computer code (provided for you) and click on the link to visit an activation webpage. Enter all the information that it asks and eventually you will be provided with your activation code. Copy your activation code and return to your BTMA Spreadsheet file where you will paste the activation code in the correct blank. After entering the correct activation code, your BTMA Spreadsheet will open and you can begin using it. (If the activation code does not work, make sure that there are no spaces before or after the pasted code.)<\/p>\n<p><strong>6. If you see\u00a0 this message: “This workbook has lost its VBA project…”<\/strong><\/p>\n<p style=\"padding-left: 30px;\">If at any time, you receive a message saying “This workbook has lost its VBA project, ActiveX controls and any other programmability-related features\u201d, then this means that you do not have “Visual Basic for Applications” installed. Therefore, you will need to change your installation.<br \/>\nHere are the instructions how:<br \/>\n<a href=\"http:\/\/www.asap-utilities.com\/faq-questions-answers-detail.php?m=145\">http:\/\/www.asap-utilities.com\/faq-questions-answers-detail.php?m=145\u00a0<\/a><\/p>\n<p><strong> 7. Enable Macros<\/strong><\/p>\n<p style=\"padding-left: 30px;\">If you receive a message about enabling macros, you will need to do so by clicking \u2018Enable Content’. Depending on your version of Excel, you may need to click ‘Options’, then ‘Enable Content’. (This message about enabling content is usually located below the top horizontal toolbar in Excel.)<\/p>\n<p style=\"padding-left: 30px;\">You should also check to make sure that Excel has the correct setting for Macros.<br \/>\nIn Excel, change your Macros settings to “Disable all macros with notification”.<br \/>\nHere’s a pic of what it will look like:<\/p>\n<p><a href=\"http:\/\/www.beatthemarketanalyzer.com\/blog\/wp-content\/uploads\/2013\/01\/option-to-disable-all-macros-with-notification.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4087 alignnone\" src=\"http:\/\/www.beatthemarketanalyzer.com\/blog\/wp-content\/uploads\/2013\/01\/option-to-disable-all-macros-with-notification.jpg\" alt=\"disable macros with notification\" width=\"800\" height=\"219\" srcset=\"https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-content\/uploads\/2013\/01\/option-to-disable-all-macros-with-notification.jpg 800w, https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-content\/uploads\/2013\/01\/option-to-disable-all-macros-with-notification-300x82.jpg 300w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/p>\n<p style=\"padding-left: 30px;\">(By doing this, it will ask you to manually enable macros when you open the BTMA Stock Spreadsheet from now on. This might solve your issue if it’s related to macros.)<\/p>\n<p><b><br \/>\n<\/b> <strong>8. Update Links<\/strong><\/p>\n<p style=\"padding-left: 30px;\">If you receive a message about updating links, you can click ‘Update’.<\/p>\n<p><strong>9. Quick Start<\/strong><\/p>\n<p style=\"padding-left: 30px;\">After opening your BTMA Spreadsheet, you will see different colored sheet tabs at the bottom. Click on the \u2018Quick Start\u2019 sheet tab. There you will find step-by-step directions on:<br \/>\nRequirements<br \/>\nHow to use the BTMA Spreadsheet<br \/>\nHelp & Troubleshooting<\/p>\n<p><strong><span style=\"color: #ff0000;\">10. *If you are using the BTMA Spreadsheet outside of the USA, please see the troubleshooting instructions below titled:<\/span><\/strong><br \/>\n<strong> <span style=\"color: #ff0000;\">“Analyzer doesn’t work outside of the USA”<\/span><\/strong><\/p>\n<p> <\/p>\n<hr \/>\n<p> <\/p>\n<h2><b>Help & Troubleshooting<\/b> <b>(These are common issues and solutions to help you.)<\/b><\/h2>\n<p><strong>1. I can\u2019t copy the SMF folder to the Local Disk (C:)<\/strong> <b><br \/>\n<span style=\"color: #ff0000;\">(This should only be done if your automatic install package failed.)<\/span><\/b><\/p>\n<p style=\"padding-left: 30px;\">Solutions: If you need help to manually install the BTMA Spreadsheet from the beginning, go here:<br \/>\n<a href=\"http:\/\/www.beatthemarketanalyzer.com\/blog\/manual_install\/\">http:\/\/www.beatthemarketanalyzer.com\/blog\/manual_install\/<\/a><\/p>\n<p style=\"padding-left: 30px;\">If you already have downloaded the SMF folder from the BTMA website, then follow these instructions:<br \/>\nRight click on the “SMF” folder.<br \/>\nSelect ‘Cut’.<br \/>\nOn your desktop or in the Start Menu, click on “Computer”.<br \/>\nYou will see the Local Disk (C:)<br \/>\nRight click on the Local Disk (C:)<br \/>\nSelect ‘Paste’.<br \/>\nA message might say that “You need administrator permission…”, Just click continue.<\/p>\n<p style=\"padding-left: 30px;\">If you don’t have permission to access Local Disk (C:), then you will need to ask your computer tech or the appropriate person to help you add the “SMF” folder to the Local Disk (C:)<\/p>\n<p> <\/p>\n<p><strong>2. Value! errors<\/strong><\/p>\n<p style=\"padding-left: 30px;\">The BTMA Spreadsheets pull data from online databases and sometimes Value! errors show up because a particular stock\u2019s data needs refreshed or updated. <b> <\/b><\/p>\n<p style=\"padding-left: 30px;\">Solution: Wait until the online database is updated and the errors will disappear. Most of the time, if you just wait a few hours or a day, the online stock data will be updated.<\/p>\n<p> <\/p>\n<p><strong>3. DIV errors<\/strong><\/p>\n<p style=\"padding-left: 30px;\">DIV errors (#DIV\/0!) occur because of calculations with a null value. This usually happens when a cell or cell range is trying to divide by 0. This DIV error is important because it often tells us that some data is missing from a particular stock\u2019s historical data. It could be because the stock has a short history.<\/p>\n<p style=\"padding-left: 30px;\">Solution: Stocks that have DIV errors or are missing data are automatically penalized by the BTMA Spreadsheet. Therefore, for your safety, they will not be recommended as good investments.<\/p>\n<p style=\"padding-left: 30px;\">If you consistently see many cells with “#DIV\/0!” errors, then it could mean that your Internet Explorer settings need adjusted. <a title=\"Adjust Internet Explorer settings to avoid errors\" href=\"http:\/\/www.BeatTheMarketAnalyzer.com\/blog\/NoDataErrorsFix\" target=\"_blank\" rel=\"noopener noreferrer\">Watch this quick video on how to adjust the settings:\u00a0 www.BeatTheMarketAnalyzer.com\/blog\/NoDataErrorsFix<\/a><b><br \/>\n<\/b><\/p>\n<p> <\/p>\n<p><strong>4. ERROR errors<\/strong><\/p>\n<p style=\"padding-left: 30px;\">If you suddenly experience several errors in your data, do not worry. It is usually temporary. Often times, errors occur because a particular stock\u2019s data is down or not currently listed at the online database.<\/p>\n<p style=\"padding-left: 30px;\">Solution: Wait until the online database is updated or until that particular stock\u2019s data is added to the database. If you try again in a few hours or the next day, the online data sources should be updated.<\/p>\n<p> <\/p>\n<p><strong>5. The spreadsheet numbers are multiplied by 1000.<\/strong><\/p>\n<p style=\"padding-left: 30px;\">This often occurs with users who are outside of the USA.<\/p>\n<p style=\"padding-left: 30px;\">Solution: If you are in a non-US country, then you may need to change your number and region settings to US standards. In the US, a comma Is used to represent thousands and a decimal is used for cents. See the following link for help:<br \/>\n<a href=\"http:\/\/www.mrexcel.com\/forum\/showthread.php?t=64417\">http:\/\/www.mrexcel.com\/forum\/showthread.php?t=64417<\/a><\/p>\n<p> <\/p>\n<p><strong>6. The spreadsheet is running slowly.<\/strong><\/p>\n<p style=\"padding-left: 30px;\">I\u2019ll admit, I also want things to happen RIGHT NOW!<br \/>\nBut because each analyzed stock goes through hundreds, and sometimes thousands of calculations and criteria tests, and is compared to all of your analyzed stocks, it takes time. Even though it\u2019s not as fast as I\u2019d like, it still beats the heck out of doing it manually. But there are a few things we can do to speed up the process.<\/p>\n<p style=\"padding-left: 30px;\">Solutions:<b><br \/>\n<\/b>a. Make sure that auto-calculation is off when you\u2019re using the BTMA spreadsheets.<\/p>\n<p style=\"padding-left: 30px;\">b. Close other programs and other Excel files while using the spreadsheet.<br \/>\nc. Use cable internet vs. wireless if possible<br \/>\nd. In Excel, make sure that you turn on all processors for optimal calculation speed.<br \/>\ne. Defragment your hard drive.<\/p>\n<p style=\"padding-left: 30px;\">f. Use the paid premium BTMA Spreadsheet instead of the free basic version.<br \/>\nIt\u2019s much faster because you can analyze hundreds, even thousands of stocks at the same time instead of doing it one by one with the free basic BTMA Spreadsheet.<\/p>\n<p> <\/p>\n<p><strong>7. Links need to be updated<\/strong><\/p>\n<p style=\"padding-left: 30px;\">When opening the spreadsheet, if you see an error message about links, make sure that macros are enabled. Link errors can also be caused by the SMF folder being located in the wrong location.<\/p>\n<p style=\"padding-left: 30px;\">Solutions:<b><br \/>\n<\/b>a. Always enable macros when using the BTMA Spreadsheets<br \/>\nb. Make sure that the SMF folder is located in the Local Disk (C:) or Vista (C:)<br \/>\nIt should look like this C:\\SMF<\/p>\n<p style=\"padding-left: 30px;\">After making sure that the SMF folder is in the Local Disk (C:) or Vista (C:),then you should open the BTMA Installer File to correctly configure your computer. (The BTMA Installer File is located inside the SMF folder. There should also be a shortcut for it located on your Desktop.)<\/p>\n<p style=\"padding-left: 30px;\">For more specific info about the SMF Excel Add-in created by Randy Harmelink, please join <a href=\"http:\/\/finance.groups.yahoo.com\/group\/smf_addin\/\">Randy’s Yahoo Group<\/a>. It\u2019s loaded with useful advice: <a href=\"http:\/\/finance.groups.yahoo.com\/group\/smf_addin\/\">http:\/\/finance.groups.yahoo.com\/group\/smf_addin\/<\/a><\/p>\n<p style=\"padding-left: 30px;\"><span style=\"color: #ff0000;\">*Please note that Randy Harmelink’s group saves the SMF folder in this location:\u00a0 C:\\Program Files\\SMF<br \/>\nHowever, the BTMA Spreadsheet requires the SMF folder to be located in this location:\u00a0\u00a0\u00a0\u00a0 C:\\SMF<\/span><\/p>\n<p><strong><br \/>\n8. “Macros have been disabled” error message<\/strong><\/p>\n<p style=\"padding-left: 30px;\">If you receive some kind of error message saying the macros has been disabled or that add-ins have been disabled, then you need to reactivate macros and or add-ins.<\/p>\n<p style=\"padding-left: 30px;\">Solution:<\/p>\n<p style=\"padding-left: 30px;\">a. Click the Windows Orb (Excel 2007) or File (Excel 2010) and then click on ‘Excel Options’ or it might just say ‘Options’ (this could be at the bottom of the window.)<\/p>\n<p style=\"padding-left: 30px;\">b. On the left menu, click ‘Trust Center’<\/p>\n<p style=\"padding-left: 30px;\">c. Next, click ‘Trust Center Settings…’<\/p>\n<p style=\"padding-left: 30px;\">d. Click ‘Macro Settings’ and select “Disable all macros with notification”.<br \/>\nHere’s a pic of what it will look like:<\/p>\n<p><a href=\"http:\/\/www.beatthemarketanalyzer.com\/blog\/wp-content\/uploads\/2013\/01\/option-to-disable-all-macros-with-notification.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4087 alignnone\" src=\"http:\/\/www.beatthemarketanalyzer.com\/blog\/wp-content\/uploads\/2013\/01\/option-to-disable-all-macros-with-notification.jpg\" alt=\"disable macros with notification\" width=\"800\" height=\"219\" srcset=\"https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-content\/uploads\/2013\/01\/option-to-disable-all-macros-with-notification.jpg 800w, https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-content\/uploads\/2013\/01\/option-to-disable-all-macros-with-notification-300x82.jpg 300w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/p>\n<p style=\"padding-left: 30px;\">(By doing this, it will ask you to manually enable macros when you open the BTMA Stock Spreadsheet from now on. This might solve your issue if it’s related to macros.)<\/p>\n<p style=\"padding-left: 30px;\">e. In the left menu, click ‘Add-ins’<\/p>\n<p style=\"padding-left: 30px;\">f. Make sure that NONE of the listed options are checked.<\/p>\n<p style=\"padding-left: 30px;\">g. Especially make sure that this is NOT CHECKED: “Disable all Application Add-ins”<\/p>\n<p> <\/p>\n<p><strong>9. Lost Sheet or Can’t Find a Sheet. <\/strong><\/p>\n<p style=\"padding-left: 30px;\">Solutions:<br \/>\nFirst, make sure that you haven’t just accidentally renamed the sheet. The main sheet names should be:<\/p>\n<p style=\"padding-left: 30px;\">Disclaimer<br \/>\nQuick Start<br \/>\nSingle Analyzer<br \/>\nMulti Analyzer<br \/>\nSaved Data<br \/>\nMy Investment Plan<br \/>\nHelp<br \/>\nS&P 500 Tickers<br \/>\nDOW 30 Tickers<br \/>\nRussell 2000 Tickers<br \/>\nNASDAQ 100 Tickers<br \/>\n<span style=\"color: #ff0000;\">* Please do not rename sheets. Renaming sheets could cause possible errors in the future. If you have renamed sheets, please change the sheet names to the exact sheet names listed above.<\/span><\/p>\n<p style=\"padding-left: 30px;\">If you have accidentally hidden a sheet and want to unhide the sheet, follow these directions from within your BTMA Spreadsheet:<br \/>\n1. Click “View” (on the top menu bar)<br \/>\n2. Click “Macros”<br \/>\n3. Click “View Macros”<br \/>\n4. In the macro list, look for “UnHideMainSheets”<br \/>\n5. Select “UnHideMainSheets” and Click the “Run” button.<br \/>\n6. You should now see all of your main sheets.<br \/>\n<span style=\"color: #ff0000;\">* Please do not run other macros from this list. Doing so could cause possible errors in the future<\/span>.<\/p>\n<p> <\/p>\n<p><strong>10.\u00a0Analyzer doesn’t work outside of the USA<\/strong><\/p>\n<p style=\"padding-left: 30px;\">If you are currently located outside of USA, you may need to add an\u00a0extra file to your computer for the Analyzer to work properly.<\/p>\n<p style=\"padding-left: 30px;\">Solutions:<b>\u00a0<\/b>Follow the steps below if you are trying to use the Analyzer outside of the USA.<\/p>\n<p style=\"padding-left: 60px;\">a. Go to Google.com or another search engine<\/p>\n<p style=\"padding-left: 60px;\">b.\u00a0In the search box, type: \u00a0ADVFN<\/p>\n<p style=\"padding-left: 60px;\">c. Click on the link that says ADVFN. If the links don’t work, keep trying different links until you are directed to an ADVFN website.<\/p>\n<p style=\"padding-left: 60px;\">d. Depending on your current country location, you may be directed to:<br \/>\nhttp:\/\/uk.advfn.com\/\u00a0\u00a0 (in Europe)<br \/>\nhttp:\/\/us.advfn.com\/\u00a0\u00a0 (in USA)<br \/>\netc.<br \/>\n(The important part is between the \/\/ and .advfn. (For example the “uk” or “us”<\/p>\n<p style=\"padding-left: 60px;\">e.\u00a0Next,\u00a0search your computer for a folder named SMF.<br \/>\n(It should be located in the Local C:\\ Drive.)<\/p>\n<p style=\"padding-left: 60px;\">Within the SMF folder, create a new\u00a0file called “smf-AdvFN-Prefix.txt”<br \/>\nYou can create the new file by opening a blank document in Notepad, Wordpad, Text Edit, or a similar basic word processor which can save files in “.txt” format.<\/p>\n<p style=\"padding-left: 60px;\">The file should only contain the\u00a0two letters that you found in the website address when you searched for the ADVFN website. For example, if your ADVFN website was <a href=\"http:\/\/uk.advfn.com\/\">http:\/\/uk.advfn.com\/<\/a> then you will open a blank document in Notepad, Wordpad, etc. and type “uk” without quotes or anything else.|<\/p>\n<p style=\"padding-left: 60px;\">After entering your two letters, save the file in the SMF folder with the filename: “smf-AdvFN-Prefix.txt”<br \/>\nIf your SMF folder was already saved in the Local C drive, then your\u00a0default file location should be:<br \/>\nLocal C:\\SMF\\smf-AdvFN-Prefix.txt<\/p>\n<p style=\"padding-left: 60px;\">By adding this new file to your computer, the Analyzer will automatically find your new file and adjust your country settings so that your Analyzer works properly.<\/p>\n<p style=\"padding-left: 60px;\">f.\u00a0Turn off\u00a0any proxy server or proxy sites that you may have running which could change your IP Address.<br \/>\n(If you don’t know what a proxy server or proxy site is, then you can just skip this step because you probably aren’t using a proxy server or proxy site.)<\/p>\n<p style=\"padding-left: 60px;\">g. Completely Exit out of Microsoft Excel and your BTMA Spreadsheet if it is open.<\/p>\n<p style=\"padding-left: 60px;\">h. Re-open your BTMA Spreadsheet.<\/p>\n<p style=\"padding-left: 60px;\">i. Use the Single Analyzer to test if your Analyzer is properly working now. If it’s not working, please contact Grant@BeatTheMarketAnalyzer.com<\/p>\n<p style=\"padding-left: 60px;\">j. IMPORTANT: If you leave this country and go to another country, you will need to do this process again to make sure that you have the correct country code available.<\/p>\n<p><strong>11. If you bought your computer from outside of the U.S.A, or if you believe your computer’s regional settings have been changed, then follow these instructions:<\/strong><\/p>\n<p style=\"padding-left: 30px;\">You may need to change your computer\u2019s regional settings to USA formats in order to display numbers, decimals, and dates in the appropriate way for the BTMA Stock Spreadsheet to work with USA stocks.<br \/>\nGo to Control Panel<br \/>\nRegional Settings<\/p>\n<p style=\"padding-left: 60px;\">Under the \u2018Location\u2019 tab, select United States<br \/>\nUnder the \u2018Administrative\u2019 tab, click \u2018Change System Locale\u2019 and select \u2018(English) United States\u2019<br \/>\nUnder the \u2018Formats\u2019 tab, the format should now be \u2018(English) United States\u2019<br \/>\nUnder the short date format should be: M\/dd\/yyyy<br \/>\nUnder the short date format should be: dddd, MMMM d, yyyy<br \/>\n—<br \/>\nClick \u2018Additional Settings\u2019<br \/>\nUnder \u2018Decimal Point\u2019 should be: .<br \/>\nUnder \u2018Digit Grouping System\u2019 should be: ,<br \/>\nUnder \u2018Digit Grouping\u2019 should be: 123,456,789<br \/>\nUnder \u2018Measurement System\u2019 should be: U.S.<br \/>\nUnder \u2018Use Native Digits\u2019 should be: Never<\/p>\n<hr \/>\n<p> <\/p>\n<h2><b>Contact<\/b><\/h2>\n<p style=\"padding-left: 30px;\">If you have any other questions or feedback, please email me at:<br \/>\n<strong>Grant (at) BeatTheMarketAnalyzer.com<\/strong><\/p>\n<p> <\/p>\n<hr \/>\n<p> <\/p>\n<p> <\/p>\n<h2><b>Thank You<\/b><\/h2>\n<p style=\"padding-left: 30px;\">I\u2019m so glad that you have decided to use the Beat The Market Analyzer Spreadsheet(s). I created the spreadsheets in order to provide a more simple way for common people to invest and receive better than average returns safely.<\/p>\n<p style=\"padding-left: 30px;\">I\u2019m confident that the spreadsheet(s) will also help you to achieve your investing goals. I\u2019ve dedicated a great deal of time and energy into these spreadsheets to make them efficient and convenient for you.<\/p>\n<p style=\"padding-left: 30px;\">I realize that there is always room for improvement and I will never be able to satisfy everyone. However, if you have suggestions or feedback, please let me know. As different needs and suggestions are brought to my attention, I will do my best to improve and update the spreadsheet(s) while still maintaining my purpose of providing a simple and effective product that doesn\u2019t overwhelm users with unnecessary information.<\/p>\n<p style=\"padding-left: 30px;\">Welcome to BTMA,<\/p>\n<p style=\"padding-left: 30px;\">Grant Gigliotti<br \/>\nBeat The Market Analyzer<\/p>\n<hr \/>\n<p> <\/p>\n<h2><b>Disclaimer<\/b><\/h2>\n<p style=\"padding-left: 30px;\">By using the Beat The Market Analyzer spreadsheet(s), you agree to the following: The information and material contained in this spreadsheet is for educational purposes only.<\/p>\n<p style=\"padding-left: 30px;\">The creator of this spreadsheet, Beat The Market Analyzer and its clients and affiliates claim no responsibility for any gain or loss of money from the use of this spreadsheet and or information from Beat The Market Analyzer. It is the user\u2019s responsibility to exercise their own judgment, research, and due diligence when analyzing and making decisions on any and all investments.<\/p>\n<p style=\"padding-left: 30px;\">The information and tools contained within the Beat The Market Analyzer spreadsheet and related material or affiliate sites have no regard to the financial situation or investment goals or objectives of any visitor or user. This spreadsheet and any related material from Beat The Market Analyzer is for informational purposes only and is not to be construed as an offer to buy or sell securities or any other financial instruments. Beat The Market Analyzer along with its, affiliates, clients, associates, and other related parties may have an interest in the securities of any entities from Beat The Market Analyzer or the Beat The Market Analyzer Spreadsheets.<\/p>\n<p style=\"padding-left: 30px;\">Any data, information, or references made to third parties are based on information gathered from sources believed to be reliable, but are not guaranteed as being accurate. It is the visitor\u2019s responsibility to exercise their own judgment, do their own research, and apply due diligence when analyzing and making decisions on any and all investments. Any opinions expressed in this spreadsheet or related Beat The Market Analyzer material is subject to change without notice and Beat The Market Analyzer or any affiliated authors or websites are not under any responsibility or obligation to update or keep current the information contained within this spreadsheet or related Beat The Market Analyzer materials.<\/p>\n<p style=\"padding-left: 30px;\">Beat The Market Analyzer accepts no liability whatsoever for any loss or damage of any kind arising out of the use of all or any part from Beat The Market Analyzer or any of the information, materials, or tools containing the name Beat The Market or Beat The Market Analyzer. The information and comments in this spreadsheet and within related materials are an expression of opinion. Even though we believe our statements to be true, they always depend on the reliability of our own credible sources and should not be accepted as fact.<\/p>\n<p> <\/p>\n","protected":false},"excerpt":{"rendered":"<p>BTMA Stock Analyzer Help 1. Watch this demonstration video about how to use the BTMA Stock Analyzer: 2. While using the BTMA Stock Analyzer, you can get detailed information by clicking on the small blue information “i” icons found throughout the Analyzer. 3. Watch\u00a0\u00a0here to learn how to use the Qualitative Analysis section … <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.beatthemarketanalyzer.com\/blog\/help\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> “Help”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-46","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Help - Beat The Market Analyzer<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.beatthemarketanalyzer.com\/blog\/help\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Help - Beat The Market Analyzer\" \/>\n<meta property=\"og:description\" content=\"BTMA Stock Analyzer Help 1. Watch this demonstration video about how to use the BTMA Stock Analyzer: 2. While using the BTMA Stock Analyzer, you can get detailed information by clicking on the small blue information “i” icons found throughout the Analyzer. 3. Watch\u00a0\u00a0here to learn how to use the Qualitative Analysis section … Continue reading "Help"\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.beatthemarketanalyzer.com\/blog\/help\/\" \/>\n<meta property=\"og:site_name\" content=\"Beat The Market Analyzer\" \/>\n<meta property=\"article:modified_time\" content=\"2017-06-25T13:48:31+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.beatthemarketanalyzer.com\/blog\/wp-content\/uploads\/2013\/01\/information-icon-buttons.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"19 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/help\\\/\",\"url\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/help\\\/\",\"name\":\"Help - Beat The Market Analyzer\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/help\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/help\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/wp-content\\\/uploads\\\/2013\\\/01\\\/information-icon-buttons.jpg\",\"datePublished\":\"2013-01-07T12:40:07+00:00\",\"dateModified\":\"2017-06-25T13:48:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/help\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/help\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/help\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/wp-content\\\/uploads\\\/2013\\\/01\\\/information-icon-buttons.jpg\",\"contentUrl\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/wp-content\\\/uploads\\\/2013\\\/01\\\/information-icon-buttons.jpg\",\"width\":591,\"height\":300},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/help\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Help\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/\",\"name\":\"Beat The Market Analyzer\",\"description\":\"Simple Stock Investing Help without the BS\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Help - Beat The Market Analyzer","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.beatthemarketanalyzer.com\/blog\/help\/","og_locale":"en_US","og_type":"article","og_title":"Help - Beat The Market Analyzer","og_description":"BTMA Stock Analyzer Help 1. Watch this demonstration video about how to use the BTMA Stock Analyzer: 2. While using the BTMA Stock Analyzer, you can get detailed information by clicking on the small blue information “i” icons found throughout the Analyzer. 3. Watch\u00a0\u00a0here to learn how to use the Qualitative Analysis section … Continue reading \"Help\"","og_url":"https:\/\/www.beatthemarketanalyzer.com\/blog\/help\/","og_site_name":"Beat The Market Analyzer","article_modified_time":"2017-06-25T13:48:31+00:00","og_image":[{"url":"http:\/\/www.beatthemarketanalyzer.com\/blog\/wp-content\/uploads\/2013\/01\/information-icon-buttons.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"19 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.beatthemarketanalyzer.com\/blog\/help\/","url":"https:\/\/www.beatthemarketanalyzer.com\/blog\/help\/","name":"Help - Beat The Market Analyzer","isPartOf":{"@id":"https:\/\/www.beatthemarketanalyzer.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.beatthemarketanalyzer.com\/blog\/help\/#primaryimage"},"image":{"@id":"https:\/\/www.beatthemarketanalyzer.com\/blog\/help\/#primaryimage"},"thumbnailUrl":"http:\/\/www.beatthemarketanalyzer.com\/blog\/wp-content\/uploads\/2013\/01\/information-icon-buttons.jpg","datePublished":"2013-01-07T12:40:07+00:00","dateModified":"2017-06-25T13:48:31+00:00","breadcrumb":{"@id":"https:\/\/www.beatthemarketanalyzer.com\/blog\/help\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.beatthemarketanalyzer.com\/blog\/help\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.beatthemarketanalyzer.com\/blog\/help\/#primaryimage","url":"https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-content\/uploads\/2013\/01\/information-icon-buttons.jpg","contentUrl":"https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-content\/uploads\/2013\/01\/information-icon-buttons.jpg","width":591,"height":300},{"@type":"BreadcrumbList","@id":"https:\/\/www.beatthemarketanalyzer.com\/blog\/help\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.beatthemarketanalyzer.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Help"}]},{"@type":"WebSite","@id":"https:\/\/www.beatthemarketanalyzer.com\/blog\/#website","url":"https:\/\/www.beatthemarketanalyzer.com\/blog\/","name":"Beat The Market Analyzer","description":"Simple Stock Investing Help without the BS","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.beatthemarketanalyzer.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-json\/wp\/v2\/pages\/46","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-json\/wp\/v2\/comments?post=46"}],"version-history":[{"count":76,"href":"https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-json\/wp\/v2\/pages\/46\/revisions"}],"predecessor-version":[{"id":4874,"href":"https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-json\/wp\/v2\/pages\/46\/revisions\/4874"}],"wp:attachment":[{"href":"https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-json\/wp\/v2\/media?parent=46"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}