1. How to use GuruFocus - Tutorials
  2. What Is in the GuruFocus Premium Membership?
  3. A DIY Guide on How to Invest Using Guru Strategies
GuruFocus
Articles 

GURUF Mac Version Is Released: New Feature Announcement

Installation manual is here

August 08, 2017

We are very pleased to announce that we have developed the MAC version of user-defined-function GURUF. At this point we are still working on improving the function. Please feel free to give us feedback in the comment area of the article.

This is the installation manual. Version 1.0.0.1

1. Installation Instructions

1.1. Install GuruFocus Excel Add-in

Go to this link http://www.gurufocus.com/excel_Add_in.php and click the large download button (GURUF For Mac)

1

1.2. Import GURUF_MAC.xlam

After you successfully download the GURUF for Mac, open excel -> new blank sheet -> tool -> Excel add-ins.

2

Then you come to this screen:

3

Click ‘Browse’ button, find the GURUF_MAC.xlam which you just downloaded.

4

Then you need to activate GURUF add-in:

After it is done, you will see ‘GuruFocus Beta’ tab.

1.3. Unlock GURUF

There is the last thing you need to do before you use GURUF, unlock GURUF. Click ‘Unlock GURUF’.

Click on "Get Your Token", copy your token, and click ‘Paste’. (use command + V may not work at this time)

And click start.

9

During this process, GURUF_MAC may grant access to some files, follow the steps to grant access, those files are used to store some data relate to GURUF.

Functions Instructions

2.1 Insert GURUFinsert

If you are a user of GURUF for Windows, you will take advantage of it quickly. Click Insert GURUF, there will be a pop up window shown as below.

2

Ticker and Calculation is required. You can search Calculation by inputting key words in Calculation combo Box. The picture shows all calculations which are related to key word ‘price’.

3

4

Besides, you can see the function preview in GURUF preview panel. After you finish all desired parameters, Click OK, the correct GURUF will be inserted to the selected cell.

7

2.2. Expand All Functions

Since Excel is not smart enough to resize an array function automatically, we make this function to expand your array formulas (Array formula’s result is occupied with more than 1 cell). For example, the above picture has array formula. After you click ‘Expand All Functions’, the result shown below.

5

2.3. Check Updates

If there is an update available, there will be a notification for it.

6

The latest version will be downloaded to your local drive, and you can replace the add-in by yourself. The process is same as  1.2

GURUF works for Premium and PremiumPlus members only. Premium members have up to 2000 function calls a month, and PremiumPlus members have unlimited function calls. If you are not a subscriber of GuruFocus, we invited you for a Free 7-day trial.

Have fun!

About the author:

GuruFocus
Charlie Tian, Ph.D. - Founder of GuruFocus. You can now order his book Invest Like a Guru on Amazon.

Rating: 5.0/5 (1 vote)

Voters:

Comments

dementor
Dementor premium member - 1 week ago

Doesn't work for me.... Keeps crashing and formula variables are not being picked up.

ZhenyuChen
ZhenyuChen premium member - 1 week ago

@Dementor Hi, what kind of error message did you get? Can you please describe it in detail?

dcwill43
Dcwill43 premium member - 6 days ago

All I get is a compile error when I try to click ok after selecting the addin. The addin appears as GuruFocus.mac.xlam. After selecting it and clicking ok I get the compiler error. Tried it three times

ZhenyuChen
ZhenyuChen premium member - 6 days ago

@Dcwill43 premium member Did you follow the manual to register this add-in? You can open a ticket to us, and send some error screenshots. Then we can go further. https://www.gurufocus.com/ticket/open.php

dcwill43
Dcwill43 premium member - 5 days ago

The manual says to download it. Then find and activate it. Finally to unlock it with a token. I never get to fully activate it before the compiler error. As soon as I click ok after finding the downloaded file I get the error. Also my screen for excel add-ins does not have the browse button. It says select. Maybe my version of excel is different.

ZhenyuChen
ZhenyuChen premium member - 5 days ago

@Dcwill43 premium member We have a new version released, you can download it and see if there still exists the same problem.

liuherms
Liuherms premium member - 1 day ago

Neither works for me, keeps saying cannot complie.

Please leave your comment:


More than 500,000 people have already joined GuruFocus to track the stocks they follow and exchange investment ideas.

Performances of the stocks mentioned by GuruFocus


User Generated Screeners


pbarker46Hist dividend yield
pepebellMagic Formula Mod
HOLKLSUNew Top 10 Group NON Trends Q3
liuzishuNon-div M-score
blomgGreenblatt
pbarker46Momentum
merknt84div5
merknt84div4
merknt84div3
merknt84div2
Get WordPress Plugins for easy affiliate links on Stock Tickers and Guru Names | Earn affiliate commissions by embedding GuruFocus Charts
GuruFocus Affiliate Program: Earn up to $400 per referral. ( Learn More)

GF Chat

{{numOfNotice}}
FEEDBACK