# high

1. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### Attendance sheet

Can you give me solution for Attendance sheet with public holidays should be high lighted in kuwait region
9. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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...