Excel question

Forums › ProRealTime English forum › General trading discussions › Excel question

Viewing 8 posts - 1 through 8 (of 8 total)
  • 09/21/2017 at 10:12 AM #46772
    Despair

    I have a question regarding Excel. Yesterday I wanted to enter some commands I found in a (english) book but noticed they did not work. If I wrote commands like COUNTIF I got an error message. Excel expected this commands in swedish  (obviously because swedish windows is installed on the PC)!? I had to write ANTAL.OM instead. This felt extremely weird- who translates commands?!

    Anyway so Excel obviously expects commands in your country language. So I changed COUNTIF to ANTAL.OM but it still did not work. Then I figured out that swedish excel expects a semicolon where the english version has a comma. WTF?! How shall one work with this?

    But then I noticed if i download a spreadsheet from an english author who surely has not written the spreadsheet in swedish my excel converts it somehow because if I look I find swedish commands in the code?

    Can anybody tell me how I can deal with that? It would be great if I could make my Excel except also english commands when i type them but nt only from a file.

    09/21/2017 at 10:44 AM #46774
    Andre Vorster

    Have you tried to change the language option in Excel?

    From the menu-
    File  – options – language. Here you can add or change languages.

    Have a look at these websites with the English to Swedish translation for the various formulas. Hope it helps.

    http://www.piuha.fi/excel-function-name-translation/?page=svenska-english.html

    http://www.piuha.fi/excel-function-name-translation/index.php?page=english-swedish.html

    http://www.excelfunctions.eu/COUNTIF/English-Swedish

     

     

    09/21/2017 at 11:12 AM #46780
    Despair

    Thanks Andre that is some help but: I tried changing the language but it did not help. It only changes date format, currency and such stuff.

    The links you send are great BUT they ignore this strange change in syntax. For example:

    =COUNTIF(B2:B25,”Nancy”) is in swedish excel =ANTAL.OM(B2:B25;”Nancy”)  You see the semicolon after B25? This is really very annoying that one version wants a comma and another a semicolon. And this isn’t mentioned on the website you linked to. I’m really amazed about such problems with a program like excel which was around for ages.

    And why did microsoft this in the first place? There’s nothing like a swedish version of visual basic for example.

    09/21/2017 at 11:35 AM #46787
    Andre Vorster

    Uhhmm.. yes I see. Don’t know why Microsoft will do this.

    The other option is to use the normal “Insert function” wizard when creating formulas so it will automatically put in the correct symbols.

    You can also do the following (which I don’t think you will want to do) –
    Change your Microsoft office default language to English.
    Keyboard US layout.

    09/21/2017 at 11:42 AM #46789
    Despair

    I also tried changing the default language – same result. Only date format and such stuff changes.

    The only thing that makes me think there is a solution is that if I download a spreadsheet which is obviously not in swedish my excel translates it to swedish (so excel can do so). So there are english commands no problem but if I type in new commands it only accepts swedish.

    09/21/2017 at 12:18 PM #46799
    Andre Vorster

    Despair.

    Seems you need an English language pack for your Office.
    I don’t know which Office version you have so I send you options you can chose from.

    Here is list of Office Language packs and Language Accessory packs. Make your pick J
    https://support.office.com/en-us/article/Do-I-need-a-language-pack-Language-Accessory-Pack-LAP-or-a-Language-Interface-Pack-LIP-4548ec6b-6d0e-40aa-8780-7bbee9554e04?ui=en-US&rs=en-US&ad=US

    “Applies To: Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 OneNote 2016 Publisher 2016 Access 2016 Visio Standard 2016 Excel 2013 Word 2013 Outlook 2013 Publisher 2013 Access 2013 Visio 2013 InfoPath 2013 Excel 2010 Word 2010 Outlook 2010 PowerPoint 2010 Access 2010 OneNote 2010 Publisher 2010 Visio 2010 Project 2010 InfoPath 2010 Excel 2007 Word 2007 Outlook 2007 PowerPoint 2007 Access 2007 Publisher 2007 Visio 2007 OneNote 2007 Visio Professional 2013 Project Standard 2013 Project Professional 2013 Project Standard 2016 Visio Standard 2007 Project Standard 2010 Visio Standard 2010”

    Language Accessory Pack for Office
    https://support.office.com/en-us/article/Language-Accessory-Pack-for-Office-82ee1236-0f9a-45ee-9c72-05b026ee809f

     

    Just for interesting sake to change your office default language form one language to another and back again when needed.
    https://support.office.com/en-us/article/Choose-or-permanently-change-the-language-of-your-Office-installation-f5c54ff9-a6fa-4348-a43c-760e7ef148f8

     

    If none of these options work you might need to buy a language pack form Microsoft.

     

    09/21/2017 at 2:02 PM #46809
    Despair

    Thank you Andre. But I’m afraid changing the whole language of the PC is not good idea. It’s my wife Laptop I use and she would NOT like that hahaha. I personally use Mac but MS office on Mac is sooooo incompatible with the PC version that it is impossible  to work with it.

    I simply have to adapt to it (and this is OK). Thank you for all you help Andre!

    09/21/2017 at 2:20 PM #46814
    Andre Vorster

    Pleasure to help where I can.

    As another option, you can install Open office or Libre office. It’s free.
    Compatible with MS Office. Does not have all of the bells & whistles of MS Office but it does the job.
    Becuse it’s free you can always uninstall it again if it does not work for you and no money lost.

    https://www.openoffice.org/
    https://www.libreoffice.org/

    1 user thanked author for this post.
    avatar Despair
  • Author
    Posts
Viewing 8 posts - 1 through 8 (of 8 total)

Find exclusive trading pro-tools on ProRealCode Marketplace

Similar topics:
a question regarding the sar parabolic indicator
another hedging question
magical trend strategy question
multi timeframe question
question about acumulated positions
rookie question — back testing issues
supertrend movement coding question

Create your free account now and post your request to benefit from the help of the community
Register or Login