• Home
  • Forums
  • Trades
  • News
  • Calendar
  • Market
  • Brokers
  • Login
  • Join
  • User/Email: Password:
  • 7:02pm
Menu
  • Forums
  • Trades
  • News
  • Calendar
  • Market
  • Brokers
  • Login
  • Join
  • 7:02pm
Sister Sites
  • Metals Mine
  • Energy EXCH
  • Crypto Craft

Options

Bookmark Thread

First Page First Unread Last Page Last Post

Print Thread

Similar Threads

MT4 to Excel through Excel RTD (Finally!) 599 replies

I need to calculate ADX in Excel - Please help me 2 replies

Live price quotes, multiple brokers, 1 excel sheet - Please help! 0 replies

Excel help required 1 reply

Market Sessions Indicator Required - Please Help! 2 replies

  • Platform Tech
  • /
  • Reply to Thread
  • Subscribe
  • 1
Attachments: Excel help required please
Exit Attachments
Tags: Excel help required please
Cancel

Excel help required please

  • Post #1
  • Quote
  • First Post: May 18, 2016 3:07pm May 18, 2016 3:07pm
  •  nick2112
  • | Joined Mar 2009 | Status: Member | 126 Posts
Hi everyone,

I have enclosed an Excel file that I have used for a few years - until yesterday :-)

I have been using the file on a Mac under Office 2008. Yesterday I bought the Office 2016 version. On opening the Excel file there now seem to be a few programming problems or changes in code, they become apparent upon opening the file as I have entered a few bits of data to highlight the problem. I only have very basic Excel knowledge. I know there are a lot of very skilled people on FF and I was hoping someone might be able to have a quick look at the file and maybe fix the problem. I would be eternally grateful, and who knows, someone might find the file useful.

Many thanks in advance to anyone who takes the time to have a look.

Happy trading.
Attached File(s)
File Type: xlsx SPS 1.xlsx   391 KB | 206 downloads
  • Post #2
  • Quote
  • Last Post: Edited 12:35am May 19, 2016 12:21am | Edited 12:35am
  •  aud
  • | Joined Apr 2008 | Status: Member | 964 Posts
I doubt that I would be the one to fix this, but to get started there is input needed in your Data Copy worksheet.

The price entries at line 10 trade 3 are inconsistent with the other entries, ie not to 5 decimal places.
I think you need to enter a S/L for all entries.

HTH

Edit: This seems to clean up a lot of the errors on your journal worksheet.

If you now look at cell E13 on this worksheet ie #DIV / 0! - this will occur when you have a formula that boils down to zero divided by zero. So again it looks like incomplete data entry or an entry that's not expected.
Good Trading
 
 
  • Platform Tech
  • /
  • Excel help required please
  • Reply to Thread
0 traders viewing now
Top of Page
  • Facebook
  • Twitter
About FF
  • Mission
  • Products
  • User Guide
  • Media Kit
  • Blog
  • Contact
FF Products
  • Forums
  • Trades
  • Calendar
  • News
  • Market
  • Brokers
  • Trade Explorer
FF Website
  • Homepage
  • Search
  • Members
  • Report a Bug
Follow FF
  • Facebook
  • Twitter

FF Sister Sites:

  • Metals Mine
  • Energy EXCH
  • Crypto Craft

Forex Factory® is a brand of Fair Economy, Inc.

Terms of Service / ©2023