symbol

Hello fellow developers. I would like you to give feedback on this macro I coded. educational value: the code contains comment lines to explain various coding techniques. Did it help to understand how some things can be done? Working with a dictionary Return multiple values from a function...

Can anyone help me get custom symbols into Excel without using a third party software? I want to add a macro to the ribbon with a custom symbol. When you add it, you have the option of renaming it which pops up a symbol box that can be assigned to the macro. Should I just save the image in a...

I'm, in a way, attempting to replicate the popular StockQuotes function that is useless now that Yahoo took down the ichart site. I have saved excel files with historical price data named by the stock symbol (ex: BABA.xls, MSFT.xls). Based on Symbol and Date, I've been trying to use VLOOKUP with...

Hello, I have a data set that ends with Euro symbol sign. For exambple 2,353.00 € These symbols are in both horizontal and vertical cells. Because the data looks quite complex. Is there a way to give the Euro symbol a different color (red) The cells are formatted as Euro Currency with...

I am trying to display a symbol based on the condition that a cell is larger then/smaller then another cell, if larger or equal to then I want to display a ✓ and if the cell is smaller then I want do display a ✕. Also if one or both cells are empty, 0 or "" I want to display a ✕. Finally, I...

Hi, I have written this formula, but it doesn't work! I am trying to add 1 to the result of the first formula (in brackets), if there is a '&' symbol in AZ10. I think what is confusing it is that I mean for it to look for a & within text, for example, 'Mr & Mrs Smith'. For this reason, I...

Hi experts, I have a conditional formatting problem I need help with; Context: I work in an manufacturing company and I want to check if my actual product dimensions are within the tolerance range. The excel sheet looks a little like this: Column 1...

Hello everyone! I`m trying to use a Split for find and replace invalid symbols from my data, as there are A LOT of symbols, doing it line by line seems not correct. I like to use Split for these types of things, but this time it is not working as Split adds "" to the values... This would be...

I have a spreadsheet with 20+ worksheets. Throughout each sheet there are cells formatted for either "Currency" or "Accounting", depending on how I wanted the cell justified. The cells are currently set to show the USD symbol, but I would like for my users to be able to set the symbol to...

I have inserted symbols in S1 & T1 to indicate in increase (up) or decrease (down) . Have used the up nd down arrow using Wingdings 3 I have set up a formula to compute the increase or decrease and to include the increase symbol (up sign) and decrease 9down sign) at the end of the formula but...

I have a list of symbols in Tab "TSM_Picks" Col G starting in row 3. In a second Tab "Services" I have rows of information, each row associated with a symbol in Col E. I need a macro that reads each symbol in "TSM_Picks", identifies all the rows associated with the same symbol in "Services"...

I have a cell (BB1) that has a symbol (1 to 5 letters, e.g., HUN) that I know occurs 14 times in cells A2:AZ1000. With a macro, a function or conditional formatting, I need those 14 cells to become red. Of course, I will be searching from different symbols in BB1. Thanks, Ric

I can't seem to figure out if there is an issue with my code or if this just isn't possible. If you go to the following url it will download a csv file containing stock info. https://www.alphavantage.co/query?function=TIME_SERIES_DAILY_ADJUSTED&symbol=MSFT&apikey=demo&datatype=csv Now if I...

hi Experts.. how can i parse the data from this website into excel? :confused: https://api.binance.com/api/v1/ticker/allPrices into 2 columns Symbol and Price really appreciate the help :)

Good evening everyone, I'm build a sheet following an investment portfolio and I need to extract all dividend data so I can update the portfolio total value in chronological order. I'm currently using a database (Factset) which is feeding by some of the raw data (Dividend amounts, dates etc)...

Using VBA I'm trying to read a cell (with a dropdown list of symbols) -- like "QQQ," and then use this symbol to refer to a worksheet in a formula such as: Range("N38").Formula = "=Offset(QQQ!AL10, 4, 2, 1, 1)" so that I can use whatever symbol is in the dropdown and have it refer to to a...

Hi! This actually appeared in Word VBA. I have a code that changed text tot other text. The problem is the text is almost always the same, there is one word inside it that always differs so I tried to use the * symbol and it does not work. Sub ChangeText() With Selection.Find .ClearFormatting...

how can I subtract the end time from the start time. when I run what I thought would work below it gives me an error for using that (-) symbol =SUMIF(Table3[[Host]:[Participant11]],'Employee Table'!$A2,Table3[[EndTime]-[StartTime]])

Hello, In the attached file there are lists that recurring every 5 columns. Every first columns has > symbols. Firstly I neet to filtre all page by > symbol. Secondly every second columns has abbreviation name. I need to check there are abbreviation name in every second columns. After...

Hi In tables is there anyway of hiding the Filter symbol so it only appears when you click on the header? Thanks