1. H

    Calculating 15 minute high and low value for stock trading

    Hello people, i'm a newbie stock market trader and i trying my hand on algo trading for a while and i thought of doing all the calculation on my excel sheets. now i'm stuck with a problem for past few days and i'm not able to solve it, so i'm need of a help from fellow members of this forum to...
  2. A

    Top 5 high scores

    Hello, Is there a way to have a result of the top 5 highest scores? Here's my example. Entered manually: A1 = Dan - B1 = 63 A2 = Bill - B2 = 54 A3 = Steve - B3 = 73 A4 = Ben - B4 = 38 A5 = Patrick - B5 = 45 A6 = Jack - B6 = 104 A7 = Craig - B7 = 73 I put the tie on...
  3. O

    Looking for an If formula

    I am looking to use a IF formula but not sure how to write it so it returns the value i want. I have a list of SKU's that have a location by them, i also have a separate list of locations. I want the If formula to return a value of 1, if the SKU's location appears in my 2nd list...
  4. R

    ERROR FOUND 0x80072ee7. The server name and address could not be resolved

    Hi All, I am new to coding and programming in excel vba. Actually I have 50 Stock Tickers in Column "C".I am trying to download data from the Yahoo Finance website using their API. But when i run the code , an error is coming that: Run-time error '-2147012889( 0x80072ee7)': The server...
  5. mole999

    Scripting Dictionary

    I know these appear really fast, I have a worksheet that grows every day and currently 98% has to be looked up manually (basically a location, that then develops into postcode ad easting & northing plus A&B identifier's In the table shown as A I am developing values in Col AN I want to keep...
  6. D

    Offset Match Max - Priority Issue

    Hi folks, I am relatively new to Excel functions, but have set up a shared sheet in Google docs for my friends and I to do an online auction for our Fantasy Football draft in real time. I have each of our names in a separate column across row 11, and a blank cell below each name in row 12 for...
  7. R

    How to download 52 week high and 52 week low

    Hi all, I am new to coding and programming and would appreciate any suggestions you can give me in creating my first real code. So here i want the solution of how to download the 52 week high and 52 week low of a particular company into excel using the vba code. That's really all I am...
  8. O

    Attendance sheet

    Can you give me solution for Attendance sheet with public holidays should be high lighted in kuwait region
  9. Z

    IF(OR/AND) Formula

    Hi, I was trying to use IF, AND, OR formula to build the condition below but I'm not sure why it's not working. The condition should be: if Category is high or Critical and Status is Express then it's TRUE, otherwise False. The results column is the desired results. Category Status Results...
  10. I

    SUMIFS and numbers/ text in the same cell

    Hi there I would love some help in figuring out how to report subtotals from an existing dataset that has been created by combining values from two separate lists. List 1 - Category: Adoption, Process, People, Technology, Tools, and Location List 2 - Impact: 0 - No impact, 1 - Extremely Low...
  11. D

    VBA function IF

    Hi all, I try to make appear on the cell Cells(emptyRow, 11) the value ''HIGH'', ''MEDIUM'' or ''LOW'' in function of the value of the cell Cells(emptyRow, 10).value I mean if the value of that cell is more than 6 the value of Cells(emptyRow, 11) is ''HIGH'', if its value is less than 1...
  12. S

    Formula Help - High to Low and Odd to Even

    Hello everyone, I have 2 requests but they refer to the same cell range Cell range = A1 through C1 Example: Each cell can have a value from 0 through 9 A1 = 0 B1 = 0 C1 = 0 Even to Even formula A1 = 0 (even) B1 = 0 (even) C1 = 0 (even) So the result would be 2 (even follows an even (B1...
  13. C

    Finding the correct % value

    I have 20 assets (devices) 9 of the devices have vulnerabilities. Device 1 has 8 x critical vulnerabilities and 20 x High vulnerabilities. How do I correctly determine the true percentage values of Critical vulnerabilities and High vulnerabilities against number of assets with issues...
  14. P

    Need help

    I have code that High Lights Duplicates in a Workbook. Out of the 12 sheets only 7, I want to find dup's. All 7 are formatted as Table's and are identical. It also high lights the tab when one is found. It works perfect but I cant figure out how to exclude 4 of the sheets. Columns are A - T and...
  15. A

    Compare two means and calculate p value with pivot table

    Hi, I've built this table: <style type="text/css"><!--br {mso-data-placement:same-cell;}--></style> <tbody> #d9d9d9[/URL] "] #d9d9d9[/URL] "]s_male #d9d9d9[/URL] "]Values #d9d9d9[/URL] "] #d9d9d9[/URL] "] #d9d9d9[/URL] "] #d9d9d9[/URL] "] #d9d9d9[/URL] "] #666666[/URL] , align: right"]0...
  16. A

    Compare two means and calculate p value with pivot table

    Hi, I've built this table: <style type="text/css"><!--br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 178px"><col width="171"><col width="152"><col width="112"><col width="171"><col width="152"><col width="112"></colgroup><tbody> #d9d9d9[/URL] "] #d9d9d9[/URL]...
  17. M

    Assign value to dropdown

    Hi, I'm trying to create a dropdown that show a text value e.g. High but has a value associated to it so I can calculate it. https://we.tl/t-GCnCPTCPcA Thanks Matt
  18. M

    Dynamically derive data from websites into excel.

    I wish to automate the calculation of my portfolio at the end of day for my analysis purposes. https://nseindia.com/live_market/dynaContent/live_watch/get_quote/GetQuote.jsp?symbol=SBIN The above web address needs to be dynamically modified to obtain data of stocks. In the above address "SBIN"...
  19. DRSteele

    Averages per Day

    Can someone please help me? I have a Query Table of climate data from 1/1/1900 to today which I update regularly. I wish to calulate the mean High for each of the days (e.g., month 2 day 19) and compare it to the High for each date (e.g. all of the Feb 19s), subsequently indicating whether it...
  20. A

    Checking multiple cells to see if they contain any of a list of choices

    Good morning guys... I have been racking my (less-than-ample) brain on this one for a couple of days... please help... If i have a questionnaire which contains something like "What countries do you do business with?" and it yields a single cell with all their answers delimited by a comma, is...

Some videos you may like

This Week's Hot Topics