Usar texto da célula como texto para fórmula - EXCEL

Question

Usar texto da célula como texto para fórmula - EXCEL

Saulo 1

Gostaria de usar o texto de uma coluna como variável numa fórmula que calcula o preço de uma ação em tempo real. Exemplo:

Ação Preço atual
MGLU3 R$ 9,25

A seguinte fórmula calcula automaticamente o preço do ativo a cada instante, tomando como base o aplicativo Profit:

=RTD("rtdtrading.rtdserver";; "MGLU3_B_0"; "ULT")

A ideia é trocar o texto MGLU3 constante na fórmula e inserida de maneira manual em cada um dos registros pelo texto contido na célula com o nome da ação. Como é uma fórmula que tende a ser replicada para demais campos, gostaria de usar a opção de selecionar a célula e arrastar para que as demais células também fossem alteradas para a fórmula com os dados referentes ao valor da coluna ação nas linhas subsequentes.

Já fiz vários testes e procurei em vários lugares, mas sem sucesso. Agradeço a ajuda!

2 answers

Your answer

Answer 1

Hi @Saulo

Currently in Microsoft Q&A we only support English, could you please edit your question into English？Then we can help to solve your issues better, thanks for your understanding.

Via the translation tools, I got the following content. Any misunderstanding, please feel free to let me know.

Based on my research, this formula is manually created using RTD, which is one of Profit’s tools.
As I do not have Profit to do tests and check whether RTD supports references to cells, such as A1, B2 and ect, if you could provide an explanation for theformula, I would try to transform it to Excel formulas.

Besides, to better help you, I would suggest you contact the support of Profit.
Thanks for your understanding.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Thanks for your attention, @Emily Hua-MSFT .

I'll try explanning better. So, I've used the Profit example because this is the final objective, but it isn't only the possible example.

I'm trying to get the value in real time and this is the model. The variable MGLU3 (enterprise ticker on the stock Exchange) is the text that I'd like to use in my formula. This formula will be replicated to another field and I'd like to use the code of the name (MGLU3) as a variable to can replicate. See:
Col A .......... Col B
______________________________________________
1 Assets | Actual Price
_____________________________________________
2 MGLU3 | Formula XPTO.MGLU3
3 BBAS3 |
4 PETR4 |
____________________________________________
In the example, I'd like to use MGLU3 as a variable using the code A2, for example. Then, I could use the replication tool when I selected de field with mouse and use the plus signal to down. So, A2 changes to A3, A4, etc.

The asset name is used in the middle of the formula and the Actual Price will be the of the new asset name. MGLU3 changes to BBAS3, later PETR4, and so on.

Let me know if you need more information, I'll try to explain.

Thanks for help me.

Share via

Usar texto da célula como texto para fórmula - EXCEL

2 answers

Your answer