buy

  1. L

    VBA code which show a Pop Box in Excel if condition is meet.

    Hello Friends I am in little trouble hope you will help me. I have a excel sheet and into this sheet data is fetch from another Software (Live Data). <colgroup><col><col span="2"><col></colgroup><tbody> Company Name Value Reaching Value Status A 1000 2500 Sell B 5000 2500 C 4000 2500...
  2. kweaver

    VBA Helper's Guide by Fluff, Dante, Joe4, et al

    Where's the book, folks? You are all generous and very, very helpful. I'll buy the first copy!
  3. D

    Random selection from range where the selection is constrained of whether or not another cell on the same row ISTEXT

    Dear folks, hope that all is well. I have a frustrating problem with a random selection from a range given that another cell on the same row is text/not blank. Below table might help to explain the circumstances. What I would like to do is to select a row completely random, constrained on the...
  4. C

    RE: Multiple display of timed userforms ...

    RE: Multiple display of timed userforms ... Action1: it's 8:00 AM. Open a new Userform1(blank textbox1): Enter data: Userform.DTPicker1.value = Time 10:00 AM (display time) Userform1.Textbox1.value = Buy oranges close userform Action2: 5 minutes later: open a new Userform1(blank...
  5. W

    Excel VBA buy and sell stock market API

    I am an expeienced VBA programmer. I have been researching like crazy to see if I can find an API that would support VBA. The only one I found doesnt exist anymore. I want to buy and sell stocks from the stock market automatically when I initiate a VBA macro and leave the house to let it do...
  6. S

    Summing an array based on cell number that can be a decimal

    Hi all, I have had a good look round the forums and still can't find what I am looking for. (Probably because I am not searching for the right thing!!) I am hoping the below can be dealt with using a new function, but open to all ideas. I am trying to build a forecasting tool for predicting...
  7. A

    Match closest time

    Hello, I have a list of stocks that were bought at a specific time but i don't know the price. I have a list of prices by time but it may differs from the time of action (differ in ms). Hoe can i match it to the closest time please in order to find the price? Time Action Price...
  8. D

    VBA Inputbox issue with values higher than 1

    After multiple searches using different keywords, I've yet to find anyone having even a similar problem, so I'm not sure what to think here. I have an inputbox that requests a value (building it now so no code written for invalid value types yet). I've written code that adds the value input to...
  9. T

    Excel/access question

    Hello I need a help manipulating data on a spreadsheet. The spreadsheets columns are buy or sell, ticker, price, trade date, execution time. The rows are filled in with varying trade information, with either a buy or sell. I'm trying to identify all trades that took place on the same day and...
  10. S

    Trying to pull data based on certain criteria

    I am trying to create a document for the VP’s of my companyto be able to type in a Region number and date and have it display only thosestores that have items sold that are under 35. I would also like to break it up buy hour. I have beentrying the formula...
  11. L

    create and print files automatically

    I want to create and print files with the following logic : file 1 : keep row 1 Id Account Asset Class Sub Asset Class Action Qty/Nominal Symbol Name ISIN Exchange Currency Last price at CRE Run Counterpart and add row 2 11814 30000 stock sell 28300 ATW ATWOOD OCEANICS INC US0500951084 US...
  12. X

    Sorting multi-level data in a table

    Hey guys, hoping I can figure out if this is possible to do. So basically I'm constructing a sort of project manager buy breaking down the steps. The below table is an example of what I am trying to achieve. <tbody> Priority Project Step #1 Step #2 Step #3 2 Education >> Reading >> Think...
  13. J

    Sum until blank cell

    Hi, I've been looking on this for a while and can't seem to figure it out. I've fried looking for a solution on the internet, but it won't help. So, in column E I want to sum up all amounts in C until a blank cell is reached. So for cell E3 I want to sum up 195,97 and for cell E8 I want to sum...
  14. L

    how to sort and then move data to new column?

    Hi. I've been debating on how to do this but so far couldn't find a way. I have 3 columns, A, B and C. Column A show my buy and sell orders. Column B show how many products I bought and sold Column C show the price at which I bought and sold My goal is to sort columns A, B and C and transfer...
  15. Y

    Copy subsequent row to same row based on multiple condition

    Hi, Need some help if can do this in VBA or Pivot. Unable to figure out the way on this. I have the following Data: from Column A to K for Equity Option Trading: <tbody style="box-sizing: border-box;"> No Date/Time Strategy Method Qty Pos Effect Equity Expiry Date Strike Price Transaction Type...
  16. J

    Min and If Statements Combined with VLookup?

    Hi, VLookup is probably not the right starting point, but it's the best way I can describe what I'm trying to do. <tbody> Store Y/N Sales Formula 1 Best Buy No 4 No Target Yes 5 Yes Target No 3 Yes Best Buy No 9 No </tbody> Formula 1: Search for any "Yes" entries in column B, if...
  17. J

    Add agrument to formula

    =IF(AND(H14="USD",E14="USD"),"No FX Trade Needed",IF(H14=E14,"BUY", "SELL")) How can I add a new agrument to this statement? If fields H and E are left blank I dont want the value to be returned as "BUY" I would like it to be blank. I tried added IF(H13="","") but I get error messages. There...
  18. J

    Samples about Matrix Formulas?

    hey anyone have samples or a ebook to buy about Matrix formulas? thanks
  19. U

    Complicated Formula into VBA Macro using Compare - Maybe a Challenge for Advanced Programmer

    Hi, I have been working on this vba script for a while now and this is the piece that I need to complete it. I tried to do this myself with STRCOMP Function but it didn't work or not the correct function. Compare Colum H (Total Buy Box Price) & Column J (Seller Price) if Column H (Total Buy...
  20. Y

    VBA to extract data based on first occurrence in column; Trading Analysis

    Hi, I have an excel file with 1500 columns and each column has 4500 rows of data. Here is an example of what my spreadsheet looks like: https://imgur.com/a/n9mZ7 Here is what i'm looking to do. 1. I want excel to look at every 4th column starting from B. So the first column excel would...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top