buy

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...

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

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

=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...

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

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...

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...