{"id":89,"date":"2013-01-15T05:56:13","date_gmt":"2013-01-15T05:56:13","guid":{"rendered":"http:\/\/www.beatthemarketanalyzer.com\/blog\/?p=89"},"modified":"2013-10-15T02:34:27","modified_gmt":"2013-10-15T02:34:27","slug":"how-to-use-btma-spreadsheet","status":"publish","type":"post","link":"https:\/\/www.beatthemarketanalyzer.com\/blog\/how-to-use-btma-spreadsheet\/","title":{"rendered":"How To Use The BTMA Spreadsheet"},"content":{"rendered":"

 <\/p>\n

 <\/p>\n

 <\/p>\n

Click Here for the video
“How To Use The BTMA Spreadsheet”<\/span><\/span><\/a><\/p>\n

 <\/p>\n

 <\/p>\n

For additional written tips on “How To Use The BTMA Spreadsheet”, use the guide below.<\/p>\n

Or if you are looking For Installation Help or Troubleshooting Help, Click Here.<\/a><\/p>\n

Contents:<\/b>
Thank You
Worksheets
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Disclaimer
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Quick Start
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Single Analyzer
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Multi Analyzer
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Saved Data
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 My Investment Plan
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Help
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 Ticker Sheets<\/p>\n

 <\/p>\n

Thank You<\/b><\/h2>\n

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

Welcome to BTMA,<\/p>\n

Grant Gigliotti
Beat The Market Analyzer<\/p>\n

This guide below explains each part of the BTMA Spreadsheet. The various sheets of the spreadsheet are located at the bottom of the BTMA Spreadsheet. You can access each sheet by clicking on the colored tabs at the bottom of your BTMA Spreadsheet.<\/span><\/p>\n

\"Sheet<\/a><\/p>\n

Disclaimer<\/b><\/h2>\n

Purpose: To remind you that investing is ultimately your responsibility. <\/b><\/p>\n

You can use the BTMA Spreadsheet for informational purposes to analyze stocks, but you must do your own due diligence when making any investments.<\/p>\n

\u00a0<\/b><\/p>\n

Quick Start<\/b><\/h2>\n

Purpose: To provide when first beginning to use the BTMA Spreadsheet. <\/b><\/p>\n

Here you will find directions on:
Requirements
How to use the BTMA spreadsheet
Help & Troubleshooting<\/p>\n

\u00a0<\/b><\/p>\n

Single Analyzer<\/b><\/h2>\n

Purpose: To analyze individual stocks, one-by-one.<\/b><\/p>\n

Be sure to enter:<\/b>
1. A stock symbol (can be any US stock symbol)
2. A Start Date (this will automatically be set to today’s date)
3. An End Date (this will automatically be set to today’s date + 1 year.)<\/p>\n

After entering the stock symbol,<\/b>
Go to the small blue Calculation Button at the top left of the sheet and click \u2018ON\u2019.
Please wait while your stock is analyzed.
There will be a message at the bottom of the screen that tells you about the calculation % finished.<\/p>\n

Save Data<\/b>
After analyzing data, you should save that row of data.
Scroll to the right of the sheet and you will see buttons that say \u201cSave Row Data\u201d and \u201cSave All Rows of Data\u201d.
Click these buttons to move your analyzed data into the \u2018Saved Data\u2019 sheet.
This is where you will collect all of your analyzed data to be compared and sorted.<\/p>\n

Clear Data<\/b>
You can use the \u2018Clear All Rows\u2019 or \u2018Clear Row\u201d buttons to clear rows of data.<\/p>\n

 <\/p>\n

Multi Analyzer<\/b><\/h2>\n

Purpose: To analyze multiple stocks at once. This is a powerful automated system to analyze up to hundreds or even thousands of stocks at once.<\/b><\/p>\n

Be sure to enter:<\/b>
1. A stock symbol (can be any US stock symbol)
\u00a0
Next, hit the \u2018Analyze Multi Data\u2019 button.<\/p>\n

Analyze Multiple Stocks<\/b>
Many people like to analyze the complete S&P 500, the Dow 30, or other indexes to find the best stocks to buy among a group of stocks.
For your convenience, you can go to the Ticker sheets.
(All sheets are labeled with colored tabs at the bottom of the screen. The ticker sheets are at the far right of the sheet tabs.)<\/p>\n

You can copy ticker symbols from the Ticker sheets and paste them into the Multi Analyzer. <\/p>\n

Automatic Save<\/b>
The Multi Analyzer will show you a message about how it automatically saves your spreadsheet every few minutes to ensure that you don\u2019t lose data if there is a power outage or computer crash, etc.<\/p>\n

Estimated Time<\/b>
Next, you will be given the estimated time it might take to analyze your stocks.
This is just an estimate. The actual time will depend on your Internet speed, your computer, how many stocks you\u2019re analyzing, etc.
Please be patient. The Analyzer is processing thousands of calculations and statements for each stock. The screen may flash or look blank at times, but it is still processing the data.
You can check the bottom of the screen to see the calculation %. You can also tell that the Analyzer is working if the cursor wheel is spinning. When the Multi Analyzer has finished, it will produce a \u2018ding\u2019 sound and a confirmation message will appear.<\/p>\n

Sorted Data<\/b>
The Multi Analyzer also scores, compares, and sorts your analyzed stocks into the \u2018Saved Data\u2019 sheet. The best investments will be at the top and the worst or riskiest at the bottom.<\/p>\n

Help Choosing Investments
<\/b>The Multi Analyzer will also offer to help you custom pick the best investments from your current analyzed data for you. To do this, it utilizes the \u2018My Investment Plan\u2019 sheet. For more information on this, please see the \u2018My Investment Plan\u2019 sheet details below.<\/p>\n

 <\/p>\n

Saved Data<\/b><\/h2>\n

Purpose: This is where all of your analyzed data is stored. This sheet also gives your stocks a score, compares them, and sorts them with the best investments at the top and the worst or riskiest investments at the bottom.<\/b><\/p>\n

Color Coding
<\/b>Dark Green (if an entire row is highlighted in dark green, it is a recommended buy)
Yellow (if an entire row is highlighted in yellow, it is a possible buy)
Light Green (is universally a good sign)
Red (is universally a bad sign)<\/p>\n

Company Rating<\/b>
Each company is given a Company Rating score out of 100 points
A score of 70+ is a sign of a good company and a good potential investment<\/p>\n

Bargain Price<\/b>
The Analyzer calculates each stock\u2019s intrinsic value (estimated value) according to current data and 5-10 years of historical data. This estimated value is then given a conservative margin of safety to lower your risk and increase your chance of higher returns.
If the stock\u2019s current price is less than the margin of safety value, then the stock is considered to be at a \u2018Bargain Price\u2019.<\/p>\n

Recommended Buys and Possible Buys<\/b>
If a stock has a company rating of 70 or more and is at a bargain price, it has a chance to be labeled as a recommended buy or possible buy. However, it will still need to pass other criteria which are evaluated by the Analyzer. For example, it must have 5 to 10 years of solid data. If the company is too new or is lacking in data, the Analyzer automatically penalizes this company.<\/p>\n

Other criteria includes: good scores in most categories such as Return on Equity, Earnings Per Share, Return on Invested Capital, Gross Profit Margin, PE Ratio, etc. The Analyzer is not made to pick all of the winners. Sometimes, very volatile and risky stocks make a good return. However, the Analyzer\u2019s job is to help you to avoid picking losers and risky stocks. It is very conservative in picking companies and in pricing. Therefore, by using the Analyzer, you can significantly lower your risk and increase your chances of higher profits.<\/p>\n

 <\/p>\n

My Investment Plan<\/b><\/h2>\n

Purpose: After you have analyzed stocks and collected some recommended buys and\/or possible buys, then you can use the \u2018My Investment Plan\u2019 sheet to help you custom pick the best investments, specifically for you.<\/b><\/p>\n

Create My Investment Plan button
<\/b>When you click this button, the Analyzer will gather your current recommended buys and possible buys, and ask you questions about this companies. After answering the questions, your investment plan will be created and the most recommended stocks for you to buy will be added to the \u2018My Investment Plan\u2019 sheet.<\/p>\n

Notes<\/b>
If a stock\u2019s \u2018Start Date\u2019 (\u2018Buy Date\u2019) is not recent, then a message will appear telling you to analyze the stock again with a more recent \u2018Start Date\u2019. This will ensure that you are using the most recent data when evaluating a stock to buy.<\/p>\n

Clear Data<\/b>
You can use the \u2018Clear Individual Rows\u2019 or \u2018Clear Row Range\u201d buttons to clear rows of data.<\/p>\n

How many shares of a company should I buy?<\/b>
This is a great question and one of the first questions that we ask ourselves after we have chosen a stock to invest in. Enter your information in the yellow cells and click \u2018Calculate\u2019. This calculator will tell you what return you will need to make if you bought a specific amount of shares in a company. This can be extremely helpful so that we know if it\u2019s actually worth investing at this time or better to wait until we have more money to invest.<\/p>\n

 <\/p>\n

Help<\/b><\/h2>\n

Purpose: The title says it all.<\/p>\n

<\/b>Go here for :
Help and troubleshooting
A Video on How To Use The BTMA Spreadsheet<\/p>\n

 <\/p>\n

Ticker Sheets<\/b><\/h2>\n

Purpose: Use the ticker sheets to copy and paste stock symbol tickers into the \u2018Multi Analyzer\u2019 sheet. You can also use the Ticker sheets as a reference for finding a stock\u2019s symbol.<\/b><\/p>\n

Available Ticker Sheets
<\/b>S&P 500
DOW 30
Russell 2000
NASDAQ 100
<\/b><\/p>\n

Suggested Usage
<\/b>Many people like to analyze the complete S&P 500, the Dow 30, or other indexes to find the best stocks to buy among a group of stocks.
They will typically save their current BTMA Spreadsheet or export the \u2018Saved Data\u2019.
Next, they will save the BTMA Spreadsheet as a new name and clear all data in the \u2018Saved Data\u2019 sheet.
After, they will copy and paste desired tickers from the Ticker sheets into the \u2018Multi Analyzer\u2019.
Next, they will click the \u2018Analyze Multi Data\u2019 button.<\/p>\n

After the analyzing is completed, you will have a nice sorted list of recommended stocks to buy at the top and risky stocks at the bottom.
\u00a0<\/p>\n

—————————————————-<\/p>\n

The End<\/p>\n

\u00a0<\/b><\/p>\n","protected":false},"excerpt":{"rendered":"

      Click Here for the video “How To Use The BTMA Spreadsheet”     For additional written tips on “How To Use The BTMA Spreadsheet”, use the guide below. Or if you are looking For Installation Help or Troubleshooting Help, Click Here. Contents: Thank You Worksheets \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Disclaimer \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Quick Start \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Single … <\/p>\n

Continue reading “How To Use The BTMA Spreadsheet”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"class_list":["post-89","post","type-post","status-publish","format-standard","hentry","category-help"],"yoast_head":"\nHow To Use The BTMA Spreadsheet - 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\/how-to-use-btma-spreadsheet\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Use The BTMA Spreadsheet - Beat The Market Analyzer\" \/>\n<meta property=\"og:description\" content=\"      Click Here for the video “How To Use The BTMA Spreadsheet”     For additional written tips on “How To Use The BTMA Spreadsheet”, use the guide below. Or if you are looking For Installation Help or Troubleshooting Help, Click Here. Contents: Thank You Worksheets \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Disclaimer \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Quick Start \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Single … Continue reading "How To Use The BTMA Spreadsheet"\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.beatthemarketanalyzer.com\/blog\/how-to-use-btma-spreadsheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Beat The Market Analyzer\" \/>\n<meta property=\"article:published_time\" content=\"2013-01-15T05:56:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-10-15T02:34:27+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.beatthemarketanalyzer.com\/blog\/wp-content\/uploads\/2013\/01\/Sheet-Tabs.jpg\" \/>\n<meta name=\"author\" content=\"Grant\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Grant\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/how-to-use-btma-spreadsheet\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/how-to-use-btma-spreadsheet\\\/\"},\"author\":{\"name\":\"Grant\",\"@id\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/#\\\/schema\\\/person\\\/c018a8229dcdda52d1ccfafba9d2abed\"},\"headline\":\"How To Use The BTMA Spreadsheet\",\"datePublished\":\"2013-01-15T05:56:13+00:00\",\"dateModified\":\"2013-10-15T02:34:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/how-to-use-btma-spreadsheet\\\/\"},\"wordCount\":1559,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/how-to-use-btma-spreadsheet\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/wp-content\\\/uploads\\\/2013\\\/01\\\/Sheet-Tabs.jpg\",\"articleSection\":[\"Help\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/how-to-use-btma-spreadsheet\\\/\",\"url\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/how-to-use-btma-spreadsheet\\\/\",\"name\":\"How To Use The BTMA Spreadsheet - Beat The Market Analyzer\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/how-to-use-btma-spreadsheet\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/how-to-use-btma-spreadsheet\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/wp-content\\\/uploads\\\/2013\\\/01\\\/Sheet-Tabs.jpg\",\"datePublished\":\"2013-01-15T05:56:13+00:00\",\"dateModified\":\"2013-10-15T02:34:27+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/#\\\/schema\\\/person\\\/c018a8229dcdda52d1ccfafba9d2abed\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/how-to-use-btma-spreadsheet\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/how-to-use-btma-spreadsheet\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/how-to-use-btma-spreadsheet\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/wp-content\\\/uploads\\\/2013\\\/01\\\/Sheet-Tabs.jpg\",\"contentUrl\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/wp-content\\\/uploads\\\/2013\\\/01\\\/Sheet-Tabs.jpg\",\"width\":768,\"height\":480},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/how-to-use-btma-spreadsheet\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Use The BTMA Spreadsheet\"}]},{\"@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\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/#\\\/schema\\\/person\\\/c018a8229dcdda52d1ccfafba9d2abed\",\"name\":\"Grant\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7475c67f4dc98eb46e77dd4feeac6f75366f16055c92b9450967266e16e5b3a7?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7475c67f4dc98eb46e77dd4feeac6f75366f16055c92b9450967266e16e5b3a7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7475c67f4dc98eb46e77dd4feeac6f75366f16055c92b9450967266e16e5b3a7?s=96&d=mm&r=g\",\"caption\":\"Grant\"},\"url\":\"https:\\\/\\\/www.beatthemarketanalyzer.com\\\/blog\\\/author\\\/grant\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Use The BTMA Spreadsheet - 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\/how-to-use-btma-spreadsheet\/","og_locale":"en_US","og_type":"article","og_title":"How To Use The BTMA Spreadsheet - Beat The Market Analyzer","og_description":"      Click Here for the video “How To Use The BTMA Spreadsheet”     For additional written tips on “How To Use The BTMA Spreadsheet”, use the guide below. Or if you are looking For Installation Help or Troubleshooting Help, Click Here. Contents: Thank You Worksheets \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Disclaimer \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Quick Start \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Single … Continue reading \"How To Use The BTMA Spreadsheet\"","og_url":"https:\/\/www.beatthemarketanalyzer.com\/blog\/how-to-use-btma-spreadsheet\/","og_site_name":"Beat The Market Analyzer","article_published_time":"2013-01-15T05:56:13+00:00","article_modified_time":"2013-10-15T02:34:27+00:00","og_image":[{"url":"http:\/\/www.beatthemarketanalyzer.com\/blog\/wp-content\/uploads\/2013\/01\/Sheet-Tabs.jpg","type":"","width":"","height":""}],"author":"Grant","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Grant","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.beatthemarketanalyzer.com\/blog\/how-to-use-btma-spreadsheet\/#article","isPartOf":{"@id":"https:\/\/www.beatthemarketanalyzer.com\/blog\/how-to-use-btma-spreadsheet\/"},"author":{"name":"Grant","@id":"https:\/\/www.beatthemarketanalyzer.com\/blog\/#\/schema\/person\/c018a8229dcdda52d1ccfafba9d2abed"},"headline":"How To Use The BTMA Spreadsheet","datePublished":"2013-01-15T05:56:13+00:00","dateModified":"2013-10-15T02:34:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.beatthemarketanalyzer.com\/blog\/how-to-use-btma-spreadsheet\/"},"wordCount":1559,"commentCount":0,"image":{"@id":"https:\/\/www.beatthemarketanalyzer.com\/blog\/how-to-use-btma-spreadsheet\/#primaryimage"},"thumbnailUrl":"http:\/\/www.beatthemarketanalyzer.com\/blog\/wp-content\/uploads\/2013\/01\/Sheet-Tabs.jpg","articleSection":["Help"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.beatthemarketanalyzer.com\/blog\/how-to-use-btma-spreadsheet\/","url":"https:\/\/www.beatthemarketanalyzer.com\/blog\/how-to-use-btma-spreadsheet\/","name":"How To Use The BTMA Spreadsheet - Beat The Market Analyzer","isPartOf":{"@id":"https:\/\/www.beatthemarketanalyzer.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.beatthemarketanalyzer.com\/blog\/how-to-use-btma-spreadsheet\/#primaryimage"},"image":{"@id":"https:\/\/www.beatthemarketanalyzer.com\/blog\/how-to-use-btma-spreadsheet\/#primaryimage"},"thumbnailUrl":"http:\/\/www.beatthemarketanalyzer.com\/blog\/wp-content\/uploads\/2013\/01\/Sheet-Tabs.jpg","datePublished":"2013-01-15T05:56:13+00:00","dateModified":"2013-10-15T02:34:27+00:00","author":{"@id":"https:\/\/www.beatthemarketanalyzer.com\/blog\/#\/schema\/person\/c018a8229dcdda52d1ccfafba9d2abed"},"breadcrumb":{"@id":"https:\/\/www.beatthemarketanalyzer.com\/blog\/how-to-use-btma-spreadsheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.beatthemarketanalyzer.com\/blog\/how-to-use-btma-spreadsheet\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.beatthemarketanalyzer.com\/blog\/how-to-use-btma-spreadsheet\/#primaryimage","url":"https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-content\/uploads\/2013\/01\/Sheet-Tabs.jpg","contentUrl":"https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-content\/uploads\/2013\/01\/Sheet-Tabs.jpg","width":768,"height":480},{"@type":"BreadcrumbList","@id":"https:\/\/www.beatthemarketanalyzer.com\/blog\/how-to-use-btma-spreadsheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.beatthemarketanalyzer.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How To Use The BTMA Spreadsheet"}]},{"@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"},{"@type":"Person","@id":"https:\/\/www.beatthemarketanalyzer.com\/blog\/#\/schema\/person\/c018a8229dcdda52d1ccfafba9d2abed","name":"Grant","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/7475c67f4dc98eb46e77dd4feeac6f75366f16055c92b9450967266e16e5b3a7?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/7475c67f4dc98eb46e77dd4feeac6f75366f16055c92b9450967266e16e5b3a7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7475c67f4dc98eb46e77dd4feeac6f75366f16055c92b9450967266e16e5b3a7?s=96&d=mm&r=g","caption":"Grant"},"url":"https:\/\/www.beatthemarketanalyzer.com\/blog\/author\/grant\/"}]}},"_links":{"self":[{"href":"https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-json\/wp\/v2\/posts\/89","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"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=89"}],"version-history":[{"count":22,"href":"https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-json\/wp\/v2\/posts\/89\/revisions"}],"predecessor-version":[{"id":91,"href":"https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-json\/wp\/v2\/posts\/89\/revisions\/91"}],"wp:attachment":[{"href":"https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-json\/wp\/v2\/media?parent=89"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-json\/wp\/v2\/categories?post=89"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.beatthemarketanalyzer.com\/blog\/wp-json\/wp\/v2\/tags?post=89"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}