1. ### XLOOKUP Conundrum

Hi All I'm trying to implement a trailing stop loss for simulated stock trading. See the mini sheets, which is are stripped back versions of my actual file as it would be too large. TL;DR: I need to achieve the result in column U "trailing sl time", without using any of the purple columns F:H...
2. ### Excel forex formula help needed

Soo, I have this worksheet as seen in the attached picture. Basically, I have this table with live exchange rates that refresh every minute. The exchange rate data is sourced from a website. The only relevant exchange rate from the table is the EUR/USD. On the left-hand side We have the current...
3. ### Stop Loss Backtesting Formula

Hi, I’m trying to figure out a formula that I’m finding a bit tricky. I’m backtesting a trading strategy and currently focusing on optimising a stop loss percentage. I have 8.5 years worth of data and I want to be able to tweak a Stop Loss percentage number to see what would have given optimum...
4. ### Count the number of "TRUE" cells in an adjacent field in a table?

I have an Excel table with a field called TradingDay that simply stores Boolean values of whether a given date is a trading day. I used the formula described here to get whether the date is a trading day or not: https://exceljet.net/formula/date-is-workday Now I want to create a new field...
5. ### Stock market 15 minute calendar

Hi, So, I'm having a rough go at it trying to create a calendar without manually entering every 26th row. I am attempting to create a 15 minute calendar for Stocks. For example: COL A 9/3/19 9:30 AM 9/3/19 9:45 AM = WORKDAY(A1,1,[holidays])+15/1440 9/3/19 10:00 AM =...
6. ### Dynamic criteria for SUMIF or dynamic getpivotdata

Hi Everyone, I need help with a spreasheet issue related to my trading strategy. It would be great if I could upload the excel file, but it is too large. So I will carefully explain the problem with several images labelled in a word document -...
7. ### Average ifs for filtered data (visible data)

Hi Everyone, This is my first post here! I am trying to play around with data on a trading strategy I have been working on. I have attached my problem into a new spreadsheet. The real original spreadsheet will be too large to attach here. What I need: I want to be able to filter data e.g...
8. ### pivot table filter by Row where either of 2 Column values <>0

I have multiple pivot tables (PT) in a workbook, which are all based on the same source data. Each pivot table is identical except for the unit acronym used in the Report Filter. I just noticed an issue with one of them, and have searched for a while now, without success. I'm certain one of you...
9. ### VBA issue with JSON body send

Hi, I am building a program in Excel/VBA to execute operations in the trading platform CEX.io. I am using their API and it is working perfectly for any public call. However, when I need to use Private calls, I cannot manage to correctly send the parameters requested for the authorization. Every...
10. ### Column in table based on previous rows

Here is what my Excel spreadsheet formatted as a table looks like: <table> <tr> <th>Date</th> <th>Month Name</th> <th>Trading Day</th> </tr> <tr> <td>12/1/2017</td> <td>12</td> <td>TRUE</td> </tr> <tr> <td>12/2/2017</td> <td>12</td> <td>FALSE</td> </tr> <tr> <td>12/3/2017</td> <td>12</td>...
11. ### Help with setup of pivot table

Hello again everyone! I was wondering if someone could help me with a problem i have. I work for a company that sells commodities (for this case i jsut need help with coffee), I have a sheet with our internal countries of origins and destinations along with the amount (in tons) that we send...
12. ### Calculate long/short positions

Hi I’m an excel newbie. I have Mac excel 2010. I’m trying to perform trading backtesting and calculate long and short positions. In column A I have Google stock closing price In column B I have “BUY” or no information at all In column C I have “SELL” or no information at all In D2 I have...
13. ### Trouble with Looping Formula

Hi All, I am trying to use formulae for a trading calculator which uses a minimum working amount (A2:A12) of \$30 and increments it to 10 percent once it is over \$500. It then calculates profits F2:F12 based on wins (C2:C12) or losses (C2:C12). This works fine when I am using a test balance...

dear programmers, i am using excel 2007, and i was hoping if someone can help me. i am using DDE stock quotes from think or swim. i want to capture the quotes and have them being stored so i can run some analysis on the data. below is what i want to accomplish: SHEET1 column A column B...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back