Ahora Opciones Binarias funes en español: Forex Dde Excel

No puedo conseguir esto para trabajar en Excel 2010 y Windows7 (64bits). Excel se bloquea sin actividad en el Administrador de tareas.

MT4 Versión 4.00 Build 445

Lo sentimos, si nadie responde (todavía), parece que todo el mundo está ocupado ahora mismo.

Generalmente instalamos MT4 fuera de C: \ Archivos de programa \. Como en C: \ Mi programa \ MT4. Si todavía no funciona, intente instalar la versión de 32 bits de MT4. Presione la tecla de logotipo de Windows + R, para iniciar 'Ejecutar'. Busque el lugar donde se encuentra el ejecutable de instalación de MT4, haga clic en él y agregue / 32 en Ejecutar Windows y presione Aceptar.

Intente hacerlo primero y responda con el resultado. Espero que otros foros - que tienen 7/64 - también responde.

Gracias pero no gracias. No veo cómo la ubicación de los ejecutables afectará el rendimiento. Ya estoy usando 32 bits MT4. También he publicado en el foro de Microsoft. Parecen tener un montón de quejas sobre esto también.

Esperaré a alguien en la comunidad para que me ayude a verificar si tampoco funciona para ellos.

Gracias pero no gracias. No veo cómo la ubicación de los ejecutables afectará el rendimiento.

Tal vez deberías leer sobre temas de la UAC tanto en este Foro como fuera de él.

He leído que DDE no funciona con Excel 2010. el uso de Google, hacer algunas investigaciones.

He hecho todo eso. La búsqueda en Internet es sólo una búsqueda salvaje de ganso. Divertido algunas personas están culpando a otras aplicaciones como Chrome.

Solo necesito uno en el & gt; 500.000 instala MT para verificar. Seguramente uno de ellos tendrá la misma disposición que la mía.

Excel 2010 (64 bits)

No te preocupes. Ya tengo una publicación en el foro de Microsoft.

He hecho todo eso. La búsqueda en Internet es sólo una búsqueda salvaje de ganso. Divertido algunas personas están culpando a otras aplicaciones como Chrome.

Solo necesito uno en el & gt; 500.000 instala MT para verificar. Seguramente uno de ellos tendrá la misma disposición que la mía.

Excel 2010 (64 bits)

No te preocupes. Ya tengo una publicación en el foro de Microsoft.

Sólo hay 32 bits MT4. Tengo Excel 2010 64 bits corriendo en Windows 7 Professional 64 bits, puedo probar algunas cosas si quieres, pero no voy a actualizar mi MT4 para construir 445. 438 parece ser una mejor opción para mí.

Gracias, puedes intentar abrir una hoja de cálculo en blanco y luego ingresar la fórmula en cualquier celda. UAC puede estar apagado o encendido, he intentado ambos.

Sólo dime qué pasa. Mi Excel no se agota y se bloquea. Tienes que ir al Administrador de tareas para matarlo.

Gracias, puedes intentar abrir una hoja de cálculo en blanco y luego ingresar la fórmula en cualquier celda. UAC puede estar apagado o encendido, he intentado ambos.

Sólo dime qué pasa. Mi Excel no se agota y se bloquea. Tienes que ir al Administrador de tareas para matarlo.

Necesito habilitar DDE Server en MT4?

Gracias, puedes intentar abrir una hoja de cálculo en blanco y luego ingresar la fórmula en cualquier celda. UAC puede estar apagado o encendido, he intentado ambos.

Sólo dime qué pasa. Mi Excel no se agota y se bloquea. Tienes que ir al Administrador de tareas para matarlo.

La primera vez que he visto este trabajo. Así que puedo confirmarlo parece trabajar apenas fino.

... y no desea utilizar manualmente el "EURUSD", "EURJPY", etc, sino que preferiría vincular la sintaxis a la celda de arriba?

He intentado, p. 'MT4' | BID! B7 o 'MT4' | BID! (B7) o similar, pero no funcionó.

Introduzca el nombre de un par en una celda - USDCAD, por ejemplo. A continuación, mientras esta celda todavía está seleccionada, escriba el mismo texto en el cuadro de nombre (junto a la barra de fórmulas en la cinta de Excel). A partir de entonces, en lugar de escribir la fórmula completa, puede hacer referencia a la celda con nombre después de haber escrito el & quot;! & Quot; En su fórmula.

Lo intenté en mi hoja y funcionó tan esperanzadamente él para usted también.

Creo que tengo exactamente la misma pregunta que Larry.

Con respeto, no creo que tu respuesta o solución sea lo que Larry quería.

Creo que quiere (y yo también) ser capaz de alterar el contenido de una célula y luego lo que está escrito en la célula se utiliza en la solicitud DDE

No quiero tener que alterar el CELLNAME, sólo el contenido de la celda.

En su ejemplo, acaba de nombrar la celda con un par de FX válido, es decir, EURUSD

Usted solución no funciona si usted nombró este FXPAIR o BLAH etc

Cualquier ayuda adicional que pueda proporcionar sería apreciada.

Si lo entiendo correctamente, quiere que lo que escriba en una celda se agregue a la parte de la fórmula DDE reservada para el nombre del par de divisas. Supongo que le gustaría poder hacer esto para que cada fórmula DDE se actualizaría cada vez que cambia el texto (contenido) en la celda que utilizaría para nombrar el par? Si es así, entonces me temo que está más allá de mi conocimiento de Excel. Por lo que sé, sólo puede nombrar la celda como lo demostré porque la fórmula DDE sólo está interesada en el nombre de la celda y no en el contenido de la celda, de hecho, la celda podría estar vacía. Tal vez hay una manera con la codificación VBA. Si encuentras una solución, estaría interesado en la respuesta.

Si lo entiendo correctamente, quiere que lo que escriba en una celda se agregue a la parte de la fórmula DDE reservada para el nombre del par de divisas. Supongo que le gustaría poder hacer esto para que cada fórmula DDE se actualizaría cada vez que cambia el texto (contenido) en la celda que usaría para nombrar el par? Si es así, entonces me temo que está más allá de mi conocimiento de Excel. Por lo que sé, sólo puede nombrar la celda como lo demostré porque la fórmula DDE sólo está interesada en el nombre de la celda y no en el contenido de la celda, de hecho, la celda podría estar vacía. Tal vez hay una manera con la codificación VBA. Si encuentras una solución, estaría interesado en la respuesta.

Han estado buscando lo mismo al final escribí una macro para hacer precisamente eso,

Células (1, 1).Valor = \ vskip1.000000 \ baselineskip \ vskip1.000000 \ Células (1, 2).Valor = "Oferta" Células (1, 3).Valor = "Pregunta" Células (1, 4).Valor = Alto & quot; Células (1, 5).Valor = "Bajo" Células (1, 6).Valor = \ vskip1.000000 \ baselineskip Tiempo \ Células (1, 7).Valor = "Completo"

Para iRow = 2 a 1000 Si las celdas (iRow, 1) = & quot; & quot; A continuación, Salga para Finalizar si las celdas (iRow, 2).Value = & quot; = MT4 | BID! & Quot; &erio; Cells (iRow, 1).Value Cells (iRow, 3).Value = & quot; = MT4 | ASK! & Quot; &erio; Cells (iRow, 1).Value Cells (iRow, 4).Value = & quot; = MT4 | HIGH! & Quot; &erio; Cells (iRow, 1).Value Cells (iRow, 5).Value = & quot; = MT4 | LOW! & Quot; &erio; Cells (iRow, 1).Value Cells (iRow, 6).Value = & quot; = MT4 | TIME! & Quot; &erio; Cells (iRow, 1).Value Cells (iRow, 7).Value = & quot; = MT4 | QUOTE! & Quot; &erio; Cells (iRow, 1).Value Siguiente

Este es el mejor que me ocurrió, tal vez alguien puede hacer mejor, pero sirve el propósito por el momento.

Para usar, crear esto en el editor de VBA y adjuntarlo a una tecla de acceso directo, a continuación, cada vez que presione la combinación de teclas de acceso rápido se actualiza la tabla.

La hoja de cálculo se ve así,

Han estado buscando lo mismo al final escribí una macro para hacer precisamente eso,

Para iRow = 2 a 1000 Si las células (iRow, 1) = & quot; & quot; A continuación, Salga para Finalizar si las celdas (iRow, 2).Value = & quot; = MT4 | BID! & Quot; &erio; Cells (iRow, 1).Value Cells (iRow, 3).Value = & quot; = MT4 | ASK! & Quot; &erio; Cells (iRow, 1).Value Cells (iRow, 4).Value = & quot; = MT4 | HIGH! & Quot; &erio; Cells (iRow, 1).Value Cells (iRow, 5).Value = & quot; = MT4 | LOW! & Quot; &erio; Cells (iRow, 1).Value Cells (iRow, 6).Value = & quot; = MT4 | TIME! & Quot; &erio; Cells (iRow, 1).Value Cells (iRow, 7).Value = & quot; = MT4 | QUOTE! & Quot; &erio; Cells (iRow, 1).Value Siguiente

Este es el mejor que me ocurrió, tal vez alguien puede hacer mejor, pero sirve el propósito por el momento.

Para usar, crear esto en el editor de VBA y adjuntarlo a una tecla de acceso directo, a continuación, cada vez que presione la combinación de teclas de acceso rápido se actualiza la tabla.

La hoja de cálculo se ve así,

2010/05/17 17:27 1.25823 1.25888

2010/05/17 17:27 0.85395 0.85423

2010/05/17 17:27 1.25823 1.25888

Si agrega un nuevo símbolo y pulsa el acceso directo, se añadirá la nueva fila.

Vine con una solución ligeramente diferente en el final - aquí es un vid si usted está interesado.

Oneday: Vine para arriba con una solución ligeramente diferente en el extremo - aquí es un vid si usted está interesado.

Han estado buscando lo mismo al final escribí una macro para hacer precisamente eso,

Cells (1, 1).Value = "Symbol" Cells (1, 2).Value = "Bid" Cells (1, 3).Value = "Ask" Cells (1, 4).Value = 1, 5).Value = "Low" Cells (1, 6).Value = "Time" Cells (1, 7).Value = "Full"

Para iRow = 2 a 1000 Si las celdas (iRow, 1) = "" Entonces salga para el final si las celdas (iRow, 2).Value = "= MT4 | BID!" &erio; Células (iRow, 1).Value Cells (iRow, 3).Value = "= MT4 | ASK!" &erio; Células (iRow, 1).Valores (iRow, 4).Valor = "= MT4 | ALTO!" &erio; Células (iRow, 1).Value Cells (iRow, 5).Value = "= MT4 | LOW!" &erio; Células (iRow, 1).Value Cells (iRow, 6).Value = "= MT4 | TIME!" &erio; Células (iRow, 1).Value Cells (iRow, 7).Value = "= MT4 | QUOTE!" &erio; Cells (iRow, 1).Value Siguiente

Este es el mejor que me ocurrió, tal vez alguien puede hacer mejor, pero sirve el propósito por el momento.

Para usar, crear esto en el editor de VBA y adjuntarlo a una tecla de acceso directo, a continuación, cada vez que presione la combinación de teclas de acceso rápido se actualiza la tabla.

La hoja de cálculo se ve así,

Herramienta DDE para MT5

Concepción

La herramienta "DDE MT5" permite exportar simultáneamente todos los datos del usuario (información de la cuenta, historial de cotizaciones, valores de los indicadores, operaciones abiertas y cerradas, etc.) desde varios terminales MT5 diferentes a Excel por protocolo DDE en tiempo real.

Dynamic Data Exchange (DDE) es una tecnología para la comunicación entre múltiples aplicaciones bajo Microsoft Windows u OS / 2. El protocolo DDE es compatible con muchas aplicaciones de Windows. La aplicación más usada comúnmente es Excel.

Para acceder a los datos DDE de Excel, debe agregar enlaces DDE especiales en celdas de hoja de cálculo de Excel. Así que en la actualización de los datos en MT4 los datos relacionados en las celdas de Excel se actualizarán simultáneamente en tiempo real.

Con la herramienta "DDE MT5" puede realizar las siguientes tareas:

Exportar historial comercial para construir diagramas de Excel. Ejemplo: Puede exportar historial comercial de 3 cuentas diferentes simultáneamente y luego construir 3 diagramas para comparar estrategias comerciales.

Exportar datos de indicadores para crear diagramas de Excel

Tarea de acumulación de datos:

Acumular historial de ticks en las filas de Excel y guardarlo en un archivo

Acumular historial de cotizaciones en filas de Excel y guardarlo en un archivo

Encuentre min. Y máx. Spread entre las cotizaciones de diferentes corredores para encontrar la mejor diferencia para la estrategia de arbitraje rentable

Encuentre min. Y máximas operaciones rentables

Mostrar balance de cuenta / Patrimonio / Maring / Margen libre de diferentes terminales MT4 en la misma hoja de Excel

Agregue alertas emergentes o sonoras en una celda por condición (para alertar sobre Drawdown máximo, etc.)

Tareas de agregación de datos:

Operaciones de grupo por períodos de comercio: por día, por semana, por mes, etc.

Operaciones de grupo por símbolo comercial

Ordenar los oficios

Ejemplos

Hay los siguientes ejemplos provistos con la herramienta "DDE MT5":

Información de símbolo de cuenta y comercio:

CA, AD, Alligator, ADX, ATR, AO, BearsPower, BullsPower, Bandas, Índice de Fuerza, Fractales, Gator, Ichimoku, MACD, MarketFacilitation, Momentum, MoneyFlow, MA, Osma, OBV, PSAR, RSI, RVI, StdDev, Stochastic , Volúmenes, WPR

Uso

Ejecute la aplicación DDESrv_MT5.exe desde la carpeta raíz "DDE_MT5".

Ejecute el terminal MT5. Se recomienda ejecutarlo con derechos administrativos y con la clave "\ portable".

Adjunte cualquier experto de muestra DDE en cualquier gráfico. El símbolo y el tiempo no importan.

Sólo tiene que adjuntar una instancia de cada experto de muestra para evitar la duplicación innecesaria de los datos exportados.

Supongamos que ha adjuntado al experto e-BJF-DDE__AccountInfo. mq4 en el gráfico EURUSD. En este caso, no es necesario adjuntarlo a la GBPUSD.

Debe mantener los siguientes ajustes para el experto adjunto:

Permitir importaciones de Dll [Comprobado]

Abra el archivo de Excel de la carpeta "DDE_MT4 \ Excel" relacionada con el experto de la muestra MT5. Permitir actualización de enlaces automáticos (si tiene advertencia de seguridad de Excel). Ejemplo:

Supongamos que ha adjuntado al experto e-BJF-DDE__AccountInfo. mq4 en el gráfico EURUSD. En este caso, debe abrir el archivo de Excel DDE4__AccountInfo. xlsx.

PD. No es necesario pegar vínculos DDE a celdas de Excel manualmente. Puede copiar el vínculo seleccionado (o grupo de enlaces) de la aplicación DDESrv_MT5.exe al portapapeles (haciendo clic con el botón derecho del ratón) y luego pegarlo en celdas de Excel.

Podemos agregar la característica adicional para el honorario adicional: Envía señales que negocian de Excel a MT5

Herramienta Excel_to_MT5 Descripción

Esta herramienta hace posible enviar señales de regreso de Excel a MT5 en tiempo real. La parte de Excel es una hoja de cálculo estándar con celdas y macros VBA (Visual Basic para Aplicaciones). La parte MT5 tiene asesor experto para recibir y procesar datos de Excel.

Las macros VBA envían periódicamente a MT5 los valores de las columnas A, B y C.

MT5 experto tiene la siguiente lógica:

Comprar si A1> 1000 Y B1> 1000 Y C1> 1000

Vender si A1 0 OR B1> 0 OR C1> 0

Así que toda la lógica comercial tiene que ser implementada en mq5 experto. Excel es sólo fuente de datos. Ofrecemos la herramienta Excel_to_MT5 con el experto mq4 personalizado para usted. El costo se basa en la lógica del asesor experto.

pago único

soporte gratuito

30 días garantía de devolver el dinero

Cómo utilizar AmiBroker con una fuente de datos externa DDE

Nota: la versión más reciente de este documento se puede encontrar en: http://www. amibroker. com/dde. html. Consulte esta página para obtener actualizaciones.

QUÉ ES DDE

DDE (Dynamic Data Exchange) es un protocolo de Windows utilizado para permitir que las aplicaciones intercambien datos. Por ejemplo, cuando cambia un formulario en su programa de base de datos o un elemento de datos en un programa de hoja de cálculo, pueden configurarse para cambiar también estos formularios o elementos en cualquier lugar que se encuentren en otros programas que pueda utilizar. DDE utiliza un modelo cliente / servidor en el que la aplicación que solicita datos se considera el cliente y la aplicación que proporciona datos se considera el servidor. Miles de aplicaciones utilizan DDE, incluyendo Microsoft Excel, Word, Lotus 1-2-3 y Visual Basic.

DDE PARA LOS COMERCIANTES

Qué ofrece DDE para los comerciantes? Básicamente en tiempo real citas de streaming. No hay BACKFILL vía DDE. Muchos proveedores de datos en tiempo real y corretaje proporcionan la capacidad de obtener datos en tiempo real por medio de DDE. Debe preguntar a su proveedor de datos de corretaje / tiempo real si ofrecen enlace DDE. El complemento DDE ahora disponible para AmiBroker permite vincular a (casi) cualquier fuente DDE (servidor) que suministra citas en tiempo real. Esto lo convierte en una opción atractiva para todas las fuentes de datos que no tienen plugin dedicado.

CUANDO NO USAR DDE PLUGIN

Si utiliza eSignal, IQFeed, Quote. com y cualquier otra fuente que tenga un plugin dedicado, debe usar este complemento dedicado en lugar de DDE. Esto es así porque plugins dedicados son siempre mejor opción (proporcionar más características, además de que son más rápidos) que DDE genérico.

DDE PLUGIN CARACTERÍSTICAS RESUMEN

Servidor DDE / tema / elemento definible por el usuario para cada campo (abierto, alto, bajo, cierre, volumen, tamaño de comercio, volumen total, oferta, tamaño de oferta, preguntar, pedir tamaño, tiempo)

Soporta hasta 500 símbolos de transmisión en tiempo real (versión 1.1.0)

Soporta todos los intervalos de tiempo de base: diaria, horaria, 15-, 5-, 1-minuto, 15-, 5 segundos, tick

1.0.0 - versión inicial (BETA)

INSTRUCCIONES

Para utilizar el complemento de datos DDE con AmiBroker es necesario:

(Opcional *) Descargue el plugin DDE de la versión más reciente desde http://www. amibroker. com/bin/DDE. dll y cópielo a la subcarpeta PLUGINS del directorio AmiBroker. * Versión 1.2.2 de DDE. DLL (7 de junio de 2007) ya está incluido en AmiBroker 5.00 configuración completa

Active DDE en el software de terceros que está utilizando como servidor DDE (consulte la documentación del software del proveedor de datos / corretaje para obtener detalles sobre cómo habilitar DDE)

Ejecute AmiBroker y cree una nueva base de datos con & quot; DDE universal plugin de datos & quot; Como fuente de datos, siguiendo estos pasos:

Corre AmiBroker

Elija Archivo - & gt; Nueva base de datos

Escriba un nombre de carpeta nuevo (por ejemplo: C: \ Archivos de programa \ AmiBroker \ DDE) y haga clic en Crear como se muestra en la imagen siguiente:

Elija el complemento de datos universales DDE de Combo de origen de datos y "Habilitar" desde Almacenamiento de datos local

Introduzca 10000 o más en & quot; Número de barras para cargar & quot; campo

Ahora elija Intervalo de tiempo base. Los intervalos admitidos son: EOD, cada hora, 15 minutos, 5 minutos, 1 minuto. Edición Profesional de AmiBroker permite también seleccionar Tick, 5 segundos, intervalos de 15 segundos.

Haga clic en el botón CONFIGURAR - IMPORTANTE: en el botón & CONFIGURAR & quot; Debe configurar todos los campos siguiendo la descripción de su proveedor de datos.

Compruebe también el párrafo siguiente ( "CONFIGURACIÓN DE DIGITAL PLUGIN PARA TRABAJAR CON SU VENDEDOR") para obtener una descripción detallada. ATENCIÓN: no se puede saltar esta parte - sin configurar los campos específicamente para su proveedor de datos, el DDE no funcionará.

El indicador de estado del complemento debe cambiar de amarillo & quot; ESPERA & quot; A Verde "OK" En pocos segundos. Si no cambia a "Aceptar" Significa que: a) el nombre del servidor y / o los campos no están configurados correctamente o b) el servidor DDE (aplicación de terceros) no se está ejecutando o no está habilitado

Si el indicador muestra "Aceptar" - entonces los cutos en tiempo real fluyen hacia AB. Puede comprobarlo mostrando Ventana - & gt; Cotización en tiempo real. Nota: puesto que no hay relleno necesitaría esperar por lo menos 3 barras de datos que se recogerán antes de que el gráfico aparezca.

CONFIGURACIÓN DE DDE PLUGIN PARA TRABAJAR CON SU VENDEDOR

Varios proveedores de datos vienen utilizar diferentes cadenas de conexión DDE, aquí se muestran algunos ejemplos típicos.

La mayoría de la documentación de DDE utiliza la sintaxis de Excel DDE que se ve como sigue: = SERVER | TOPIC! ITEM

Server es un nombre del servidor DDE como WINROS, IQLINK, REUTER, CQGPC, MT, MTLink, etc. El tema es el tema de la conversación DDE. Dependiendo del tema de la fuente de datos, puede ser el símbolo del ticker (como en IQFeed) o el nombre del campo (como en winros). El elemento es el elemento de la conversación DDE. Dependiendo de la fuente de datos, puede ser el nombre del campo (como en IQFeed) o el símbolo ticker (como en Winros).

Por lo tanto, la cadena de conexión DDE en dos estándares más comunes tiene el siguiente aspecto:

Ahora la pantalla de configuración del complemento DDE se ve así:

En la parte SUPERIOR del cuadro de diálogo puede ver & quot; Servidor DDE & quot; campo. En este campo debe ingresar la parte SERVER de la cadena de conexión DDE (= SERVER | TOPIC! ITEM) sin marca de ecuación y sin | personaje.

A continuación, puede ver 12 cuadros de entrada de texto en los que puede definir el tema DDE y el elemento para cada campo de datos que proporciona su fuente de datos. Aquí debe ingresar TOPIC! ITEM par de la cadena de conexión DDE (= SERVER | TOPIC! ITEM) con marca de exclamación entre el tema DDE y el elemento DDE.

Como se puede ver en la imagen anterior, el complemento DDE le permite usar unas cuantas cadenas especiales, a saber:,,,, que se evalúan en tiempo de ejecución para cada símbolo por separado permitiendo construir cadenas DDE dinámicas (dependiendo del ticker seleccionado por ejemplo ) Requerido por la mayoría de las fuentes de datos:

- se evalúa como el símbolo ticker de la seguridad dada

- se evalúa con el nombre de campo correspondiente (sin espacios), es decir, Abrir, Alto, Bajo, Último, LastSize, Volumen, Preguntar, AskSize, Bid, BidSize, Time, Req

- los nombres de campo similares a los de 2 palabras tienen espacios, a saber: & lt; Last Size & quot; Ask Size & quot ;, & quot; Tamaño de la oferta & quot;

- evalúa el nombre del servidor

Desarrollo Rápido de Aplicaciones / Desarrollo Avanzado de Excel

Los enlaces 'normales' en Excel son celda de hoja de cálculo a celda de hoja de cálculo o nombre a nombre, etc.

Esta página cubre el otro tipo de enlace, el no tan común.

Intercambio dinámico de datos (DDE)

Esta es una tecnología muy antigua en estos días, más de 10 años de edad. En general Microsoft ahora parece recomendar a los desarrolladores elegir una tecnología diferente para el intercambio de datos en vivo entre 2 aplicaciones dispares.

Independientemente del consejo contrario, hay muchas aplicaciones que ponen sus datos a disposición de Excel a través de DDE. La mayoría de los proveedores de datos de mercado (Reuters, Bloomberg, Platts, etc.) proporcionan acceso DDE a sus datos.

Si alguna vez ves una fórmula inusual algo como esto:

(Observe el carácter de la tubería) Si ve esto. Entonces es probable que tenga vínculos DDE con otra aplicación.

La estructura básica de la fórmula es:

Nombre del programa | tema. Campo

Es una aplicación VB6 muy simple:

Proporciona 2 datos (o campos en lenguaje DDE) el tiempo y un número aleatorio. Si hace doble clic en la fórmula, puede pegarlas directamente en una celda y verlas actualizarse mientras juega con los controles de formulario.

Puede utilizar Edt & gt; Links & gt; Actualizar para actualizar los valores de celda de la hoja de cálculo si se descomponen con la aplicación. Esto parece ocurrir más cuando el libro tiene muchos enlaces.

Si cierra el exe e intenta actualizar los enlaces, obtendrá este cuadro de diálogo de advertencia:

Esta advertencia de "Datos remotos no accesibles" es el equivalente al error del libro no encontrado al intentar actualizar enlaces normales. Si hace clic en Sí, Excel intentará iniciar el exe a través de DDE. Esto sólo funcionará si Windows sabe dónde encontrar la aplicación, y se da con bastante facilidad con esto:

Para asegurarse de que Windows puede encontrar la aplicación (que debería funcionar bien desde cualquier lugar, en Windows XP), debe agregar su ubicación a la 'ruta de acceso'. Esta es la lista de carpetas que Windows busca al buscar archivos ejecutables (exe y dll).

Puede agregar caminos al PATH haciendo clic con el botón derecho del ratón en "Mi PC" & gt; & gt; & gt; & gt; Avanzado & gt; & gt; & gt; & gt; variables de entorno y, a continuación, haga clic en ruta y, a continuación, edítelo y agregue uno nuevo al final con un punto y coma; Para separarlo del anterior.

Las fórmulas de enlace DDE en general mantienen su último valor conocido, incluso cuando la aplicación de datos de origen no se está ejecutando. A veces, pasan brevemente a # N / A mientras esperan una respuesta, especialmente en Excel 2007 y 2010.

Para saber si tiene vínculos DDE, puede buscar en la columna Tipo del cuadro de diálogo Editar & gt; & gt; para cualquier cosa que no sea 'Hoja de trabajo'. Para encontrar dónde se usan, puede hacer un hallazgo en la tubería '|', o utilice la herramienta Codematic Link Manager (versión comercial).

Codematic Link Manager

El control y la gestión ricos de enlaces externos ha sido una característica importante de muchas de nuestras tareas de consultoría que hemos desarrollado una utilidad para ayudar. Esa utilidad ahora se ha refinado en un complemento de Excel comercial de Excel, más información está aquí.

Enlace DDE para hojas de cálculo

Dynamic Data Exchange (DDE) es un proceso de comunicación que permite a las aplicaciones compartir datos. Barchart Trader le permite conectar cualquier quoteboard utilizando DDE a Microsoft Excel, OpenOffice Calc o LibreOffice Calc y actualizar automáticamente la hoja de cálculo a medida que Barchart Trader obtiene nuevos datos.

DDE está disponible sólo en instalaciones de Windows, y sólo desde un Presupuesto o un Presupuesto fijo.

Hojas de cálculo y macros

Para utilizar DDE, su hoja de cálculo debe permitir que se ejecuten macros. Normalmente, se trata de una configuración de seguridad que se encuentra en Herramientas o puede ser una configuración que se le pide que habilite al iniciar la conexión DDE.

Si utiliza OpenOffice Calc. Debe habilitar manualmente macros de Visual Basic.

Inicie OpenOffice Calc.

Seleccione Herramientas & gt; Opciones & gt; Cargar / Guardar & gt; Propiedades de VBA

Active la casilla de verificación Código ejecutable.

Iniciar una conexión DDE

Abra un cuadro de cotización o un cuadro de cotización fijo y colóquelo en su área de trabajo.

Haga clic en el menú Acción, que se encuentra en la esquina superior derecha de la tabla de capas, seleccione Exportar tabla de precios. A continuación, seleccione con Excel (DDE) o OpenOffice (DDE).

Resultado. El Quoteboard se guarda como un archivo. xls (Excel) o un archivo. ods (OpenOffice) en su computadora. El cuadro de diálogo le muestra la ubicación del archivo y le permite abrir la ubicación / carpeta donde se colocó el archivo, abrirlo o descartarlo pulsando OK:

la hoja de trabajo

El archivo ahora se puede abrir con el software de hoja de cálculo.

Importante: Barchart Trader debe estar abierto para que la hoja de cálculo reciba actualizaciones.

Si ha abierto la hoja de cálculo antes de abrir la aplicación o para reiniciar la conexión DDE, haga clic en el botón Actualizar todo en la parte superior de la hoja de cálculo.

La hoja de cálculo se rellenará con nuevos datos de Barchart Trader. Si lo desea, puede agregar o cambiar símbolos en la hoja de cálculo.

Añadir un símbolo

Coloque el cursor en una celda abierta en la columna Símbolo.

Introduzca el símbolo deseado. Resultado. La hoja de cálculo extrae automáticamente las columnas de datos restantes y continuará actualizándose utilizando datos de la aplicación. El símbolo NO se agrega a la tabla de cotas en Barchart Trader.

Cambiar un símbolo

Coloque el cursor en la celda que contiene el símbolo que desea cambiar.

Introduzca el símbolo deseado. Resultado. La hoja de cálculo extrae automáticamente los datos del nuevo símbolo. El símbolo NO se agrega a la tabla de cotas en Barchart Trader.

Cómo formatear la hoja de cálculo

Una vez que los datos se importan a la hoja de cálculo, puede ser necesario dar formato a las celdas para recibir el tipo de datos que se recuperan a través de DDE. Por ejemplo, los campos de precio pueden necesitar ser formateados con los decimales o comas y los campos de tiempo pueden necesitar ser formateados como HH: MM: SS.

Fórmulas subyacentes

DDE coloca una fórmula en cada celda de la hoja de cálculo para poder extraer los datos apropiados de la aplicación. Si lo desea, puede introducir estas fórmulas en celdas nuevas para extraer datos que no estaban en el tablero original de la aplicación.

Excel Formula = Trader | Quotes! [Symbol]. [Field] Ejemplos:

OpenOffice / LibreOffice Formula = DDE ( "Trader", "Cotizaciones", "Symbol. Field") o = DDE ( "Trader", "Cotizaciones") donde A5 = columna / Fila que contiene el símbolo

= DDE ( "Trader", "Quotes", "AAPL. last")

= DDE ( "Trader", "Quotes", "ZW * 0.previous")

= DDE ( "Trader", "Quotes", CONCATENATE ($ A23; "volumen"))

Campos de cotización disponibles

Excel se cuelga con vínculo MT4 DDE

Plataforma Tech @ Forex Factory - www. forexfactory. com

Tengo una hoja de cálculo de tamaño de posición que utiliza enlaces DDE a MT4 para calcular el tamaño de posición para diferentes valores de cuenta, riesgo% y valor de detención.

He utilizado esto con bastante éxito dentro y fuera durante varios años, con una variedad de diferentes descargas MT4. Ahora estoy encontrando que cuando esta hoja de cálculo intenta actualizar los enlaces DDE, simplemente cuelga Excel. Presumiblemente porque no puede encontrar el servidor MT4 DDE. Tengo el servidor DDE habilitado en MT4 y la hoja de cálculo utiliza la sintaxis estándar eg = MT4 | BID! EURUSD.

Así que algo parece haber cambiado, ya sea en el lado MS o el lado MT4 y no puedo averiguar qué.

Estoy utilizando: MT4 build 220, Excel 2003 (11.8237.8221) SP3 y Vista Ultimate

Fecha: 7 de junio de 2013

Mensajes relacionados

En Windows 10, mi hoja de cálculo de ds excel no puede abrir y se congela excel para el primero vamos a decir 5min después de Windows se inició up. Excel no responde durante este tiempo (XL 2010 o 2013, he probado ambos y han probado varias máquinas con Win10) Si la hoja de cálculo se abre más allá de este 5min.

Hola, Para obtener cotizaciones en tiempo real en Excel con la plataforma MT4, aquí está el procedimiento: 1) Ir a Herramientas> Opciones> Comprobación del servidor Permitir exportar DDE.2) Ir a la carpeta de instalación su plataforma mt4 (normalmente ubicada en C / Archivos de programa / disco duro) y allí debería ver y excel el archivo llamado "D.

Yo uso MT4 para los futuros y los datos de precios de las acciones, y alimentar a este vivo a una hoja de cálculo de Excel a través de DDE. Sé que esto es la tecnología antigua, pero funciona. Sin embargo, ahora, por alguna razón, aunque esto funciona bien en mi computadora portátil, PC, excel simplemente se bloquea cuando selecciono enlaces de actualización.

Es posible enviar órdenes para comprar o vender desde Excel DDE Sample a MT4? Exporte MT4 de la muestra de DDE de Excel, y pregunto: Cuál es la fórmula que ingreso en Excel para abrir un pedido pendiente LÍMITE DE VENTA? Cuál es la fórmula que ingreso en Excel para abrir una orden pendiente? Lo que es t.

Es posible recuperar datos con comandos dde (desde mt4 a excel) que no sean los valores diarios? Como el horizonte de tiempo alto y bajo de 1H? Hay una manera de obtener esos datos en tiempo real en Excel con otras herramientas? Muchas gracias

Quiero comparar el p / l vivo total de un grupo de monedas con el total p / l vivo de otro grupo para encontrar el balance? Y? Pico? puntos. Tengo actualmente un acoplamiento de DDE de MT4 a la alimentación de Excel él viven los datos de la señal. Lo que estoy tratando de hacer es hacer un gráfico en Excel que actualiza (como cualquier fia.

Conexión de dos Metatrader a Excel con DDE.

Hola, Esto va a ser largo: Tengo un plug-in para excel (Qlink de E-señal), que me da datos en Excel. Necesito copiar desde aquí y pegar (sólo valores) en sheet1 del mismo archivo. Los datos se basan en el tiempo (intervalo de 5 minutos, intervalo de 15 minutos, etc.). Quiero que la Macro / VBA compruebe si.

He oído que usted puede utilizar Broco MT4 feed para conseguir esta cosa para actualizar con la opción de servidor DDE activado en metatrader. Pero parece que algunas de las referencias de celda necesitarán ser actualizadas. Mientras que lentamente vadeo a través de él, aquí está para cualquier persona si usted desea a tinker. Imagen adjunta (haga clic para ampliar)

Tengo una hoja de cálculo de tamaño de posición que utiliza enlaces DDE a MT4 para calcular el tamaño de posición para diferentes valores de cuenta, riesgo% y valor de detención. He utilizado esto con bastante éxito dentro y fuera durante varios años, con una variedad de diferentes descargas MT4. Ahora estoy descubriendo que cuando esto se propaga.

Bienvenido a Yahoo Groups.

Think or Swim Thinkscript programador es un Grupo restringido con 3210 miembros.

Aunque el ejemplo específico es la integración de AmiBroker con thinkorswim, pensé que esta información podría ser útil para este grupo como un ejemplo del mundo real de cómo la interfaz de DDE de thinkorswim se puede utilizar más allá de Excel y Visual Basic. Y no sólo para datos en tiempo real, sino también para datos históricos.

Se dio cuenta de que la interfaz DDE de thinkorswim funciona con onDemand también? Por lo tanto, puede iniciar una repetición de OnDemand y acceder a la reproducción en vivo & quot; Datos a través de DDE. Si desea una fecha exacta y una marca de tiempo, sólo necesita ajustar la marca de tiempo restando la diferencia entre la fecha y la hora actuales cuando inicia la reproducción y la fecha y la hora de la solicitud. Si hubiera un campo de fecha y hora en la interfaz DDE, no tendría que realizar ese ajuste.

Si sólo hubiera una interfaz con los datos de thinkBack, tendríamos datos históricos de fin de día a partir del 12/27/02.

---------- Mensaje reenviado ---------- De: David Fecha: dom, 23 de mayo, 2010 a las 22:32 Asunto: Aquí es cómo integrar AmiBroker con Thinkorswim vía DDE para citas en tiempo real de opciones, etc. A: amibroker@yahoogroups. com

He integrado AmiBroker con thinkorswim a través de DDE para obtener citas de streaming en tiempo real de todos los instrumentos que se pueden intercambiar a través de thinkDesktop, p. Opciones, futuros, acciones, ETFs, divisas.

Para hacer lo mismo, simplemente siga las instrucciones en http://www. amibroker. com/dde. html y copie esta pantalla después de hacer clic en el botón CONFIGURAR. Estas entradas distinguen entre mayúsculas y minúsculas.

Dado que AmiBroker no usa los dos últimos campos de todos modos, los uso para obtener datos adicionales que desee. I used the first field for the Strike of an option so AmiBroker can find the option I'm looking for more quickly than having to parse the Ticker field for that info (I'm perhaps incorrectly assuming that AmiBroker indexes that first field). I used the second field for the VIX-style Implied Volatility index of the underlying stock, index, future, etc. You can chose any of the thinkorswim DDE fields below instead of the two I chose.

52HIGH 52LOW ASK ASKX ASK_SIZE AX BACK_VOL BA_SIZE BETA BID BIDX BID_SIZE BX CALL_VOLUME_INDEX CLOSE COVERED_RETURN CUSTOM1 CUSTOM2 CUSTOM3 CUSTOM4 CUSTOM5 CUSTOM6 CUSTOM7 CUSTOM8 CUSTOM9 DELTA DESCRIPTION DIV DIV_DATE DIV_FREQ DT EPS EXCHANGE EXPIRATION EXTRINSIC FRONT_VOL GAMMA HIGH HTB_ETB IMPL_VOL INTRINSIC LAST LASTX LAST_SIZE LOW LX MARK MARKET_CAP MAX_COVERED_RETURN NET_CHANGE OPEN OPEN_INT OPTION_VOLUME_INDEX PE PERCENT_CHANGE PROB_OF_EXPIRING PROB_OF_TOUCHING PUT_CALL_RATIO PUT_VOLUME_INDEX RHO ROC ROR SHARES STRIKE SYMBOL THETA VEGA VOLUME VOL_DIFF VOL_INDEX YIELD

Warm regards, David

The NOTAB option also can be used to store full character strings, including embedded blanks, in a single spreadsheet cell. For example, if a link is established between the SAS System and the Excel application, and a SAS variable contains a character string with embedded blanks, each word of the character string is normally stored in a single cell. To store the entire string, including embedded blanks in a single cell, use the NOTAB option as in the following example:

It is possible to establish multiple DDE sessions. The previous example uses two separate DDE links. When the HOTLINK option is used and there are multiple cells referenced in the item specification, if any one of the cells changes, then all cells are transmitted.

Unless the HOTLINK option is specified, DDE is performed as a single one-time data transfer. That is, the values currently stored in the spreadsheet cells at the time that the DDE is processed are values that are transferred.

Using the! DDE_FLUSH String to Transfer Data Dynamically

& # 13; DDE also enables you to program when the DDE buffer is dumped during a DDE link. Normally, the data in the DDE buffer are transmitted when the DDE link is closed at the end of the DATA step. However, the special string '!DDE_FLUSH' issued in a PUT statement instructs the SAS System to dump the contents of the DDE buffer. This function allows you considerable flexibility in the way DDE is used, including the capacity to transfer data dynamically through the DATA step, as in the following example:

Here's the code that can read these data correctly into a SAS data set:

In this example, the NOTAB option tells the SAS System not to convert tabs that are sent from the Excel application into blanks. Therefore, the tab character can be used as the delimiter between data values. The DLM= option specifies the delimiter character, and '09'x is the hexadecimal representation of the tab character. The DSD option specifies that two consecutive delimiters represent a missing value. The default delimiter is a comma. For more information about the DSD option, see SAS Language Reference: Dictionary . The MISSOVER option prevents a SAS program from going to a new input line if it does not find values in the current line for all the INPUT statement variables. With the MISSOVER option, when an INPUT statement reaches the end of the current record, values that are expected but not found are set to missing.

The INFORMAT statement forces the DATA step to use modified list input, which is crucial to this example. If you do not use modified list input, you receive incorrect results. The necessity of using modified list input is not DDE specific. You would need it even if you were using data in a CARDS statement, whether your data were blank - or comma-delimited.

STREAMING SHARE PRICES IN EXCEL

With ADVFN, you can stream share prices directly into an Excel spread sheet.

Many different values are available, from current price, bid and offer to the volume of shares flagged as sells or yesterday's closing bid price.

See below for a full description of what's available.

HOW DO I GET LIVE STREAMING SHARE PRICES IN EXCEL?

Subscribe to ADVFN Stealth. This will let you stream unlimited live LSE prices into a spread sheet. When you're not using your spread sheet, the subscription will also let you get unlimited live prices via the ADVFN apps for Android and iPhone/iPad and on the website (when the boss isn't looking).

Download and install the ADVFN DDE software .

Download your Monitor list as a spread sheet using the box below. Make a note of where you're saving the file; you'll need to find it later (the default is normally the Downloads folder). The spread sheet will contain all the symbols in your monitor available via DDE as well as all the columns available via the platform. See below for more details on the markets and bits of information you can get in DDE.

Subscribe to ADVFN Stealth to download your monitor list. Haga clic aquí para mas información.

Run the DDE software by going to the Start menu at the bottom left of your screen > All programs > ADVFNDDE and clicking on the ADVFNDDE program. You'll need to enter your normal ADVFN username and password.

Open your Monitor spread sheet. You might be prompted to update and enable links to other data sources or something similar (depending on the version of Excel you are using). Click Update or OK and prices will start to stream into your spread sheet.

DO I HAVE TO USE EXCEL?

Excel is great, but can be a little pricey. If you don't have access to Excel, there are a couple of great free pieces of software you can try, OpenOffice and LibreOffice. Both include free versions of word processing, spread sheet and presentation software.

As DDE is a widely used technology, you may be able to get ADVFN prices into other software. We concentrate on and support it in Excel, OpenOffice and LibreOffice.

CAN I CUSTOMISE MY SPREAD SHEET?

Any formulae, charts, styles, conditional formatting, or anything else available in your spread sheet software can be applied to the figures you stream from ADVFN.

Being able to apply your own customised analysis to the figures is one of the most useful things about getting price data streaming into a spread sheet and you can do pretty much anything you like by combining Excel with ADVFN DDE.

CAN I BUILD A SPREAD SHEET FROM SCRATCH?

Sí. You can build up your own sheet of streaming prices by entering the formula corresponding to the bit of data you after into each cell. The formula is slightly different depending on whether you're using Excel or OpenOffice/LibreOffice, but you'll quickly get the hang of it.

A handy tool for generating the code you need is below.

=DDE("ADVFN";" EXCHANGE _ SYMBOL ";" COMMAND ")

Whilst this might seem daunting initially, have a closer look and you'll see that there are only 3 things you need to put in to get the value you want: EXCHANGE. SYMBOL & COMMAND. The rest of the formula stays the same every time.

EXCHANGE is the market the symbol trades on. For instance, you would use LSE if your stock trades on the London Stock Exchange.

SYMBOL is what you'd normally use on the site to get a quote. For instance, VOD if you want to see a quote for Vodafone.

COMMAND is the bit of data you want. For instance, you would use CHANGE if you want to know the change value.

Putting these all together, we would get the change value for Vodafone's listing on the London Stock Exchange. Here is what the formula would look like in this case:

=ADVFN| LSE _ VOD. CHANGE

worksheet change vs calculate for DDE Excel (trading system)

Problem Solved

It is a miracle! I had the right answer from a friend on an Italian forum. This time it seems to work perfectly. If you add to the top of my file this code, then everything works and it doesn't freeze:

Dim valori(1) As Double

Private Sub Worksheet_Calculate() On Error Resume Next

If Cells(2, 3).Value + Cells(4, 3).Value = valori(0) + valori(1) Then Exit Sub valori(0) = Cells(2, 3).Value valori(1) = Cells(4, 3).Value

Essentially, this code tells the sub routine "calculation" to not calculate unless there are changes on those two famous cells.

Convert Excel RTDTo DDE or Import Live data from Excel

I have just discovered Amibroker and think it has amazing potential and am looking forward to my journey, however have encountered my first challenge.

My broker supplies live data in Excel RTD format NOT DDE. This presents a problem as Amibroker's plug in is only compatible with DDE and NOT RTD.

Therefore I am assuming I have two options:

1. Have a script written to convert the data from RTD to DDE. (The RTD program I have from my broker is in VBA)

2. Use excel as a DDE server for live quotes and configure Amibroker DDE accordingly

I have countless hours trying to do the latter, and as I have no programming skills, I respectfully ask for any assitance with either option.

I'm sure my problem is not unique. (Of course things would be much easier if Amibroker just released a RTD plug in. Afterall DDE was superceded in 2002 when Microsoft introduced RTD)

Originally Posted by barnzee

I have just discovered Amibroker and think it has amazing potential and am looking forward to my journey, however have encountered my first challenge.

My broker supplies live data in Excel RTD format NOT DDE. This presents a problem as Amibroker's plug in is only compatible with DDE and NOT RTD.

Therefore I am assuming I have two options:

1. Have a script written to convert the data from RTD to DDE. (The RTD program I have from my broker is in VBA)

2. Use excel as a DDE server for live quotes and configure Amibroker DDE accordingly

I have countless hours trying to do the latter, and as I have no programming skills, I respectfully ask for any assitance with either option.

I'm sure my problem is not unique. (Of course things would be much easier if Amibroker just released a RTD plug in. Afterall DDE was superceded in 2002 when Microsoft introduced RTD)

Note: For a list of DDE commands, check out the support article listing WinWedge DDE Commands .

WinWedge makes it very easy for Excel to communicate with the device. This isn't limited to simply logging data from the device to Excel, but WinWedge also enables Excel to send data directly from VBA using WinWedge's SENDOUT and SEND DDE Commands

Sending a Command to the Device using SENDOUT DDE Command

The following VBA subroutine sends a string of control codes out the serial port by issuing the DDE command "[SendOut()]" to WinWedge. In this example, we're sending four characters: an ASCII 27 (an ESC character), a capital 'P', and a carriage return and line feed characters (ASCII 13 and 10).

Sending a String to the Device using SEND DDE Command

The following subroutine shows how to send a text string passed as an argument to the routine.

The following subroutine sends a column of data out the serial port starting in the currently active cell. After each cell's data is sent it reads the cell directly below the current cell. If the cell contains no data then it stops otherwise it continues sending until it hits an empty cell.

The following subroutine demonstrates how to send the contents of any string variable out the serial port - even strings that contain control characters or non printable ASCII characters. The string to be sent out the serial port is passed as an argument to the SendString subroutine.

The following subroutine demonstrates how you would call the above routine passing it the contents of a spreadsheet cell thus sending the cell contents out the serial port.

The following Excel VBA subroutine demonstrates how to transmit data out the serial port by "DDEPoking" to the WinWedge OutputBuffer DDE item.

Categories: Macro / Code Sample. Microsoft Excel. Data Collection. Serial (RS232). WinWedge

Many futures/options brokers in HK and China use Sharppoint's SPTrader software for real-time price feed and placing orders. Some time ago, many of these brokers started offering a FREE service called SP Native API which allows end-users to write software program to extract price feed and place their own orders. It opened a new door to in-expensive automated trading.

In the past, end-users in Hong Kong and China can only use sophisticated trading platform like Interactive Brokers for automated program trading. However that platform is much less popular than Sharppoint's SPTrader in Hong Kong and it's protocol is a lot more complex than SP Native API.

Although much simpler, SP Native API still requires you to write a software program. Avidsoft Ltd has taken the hard work out of it by offering you Spark, a simple and easy to use software using SP Native API for live feed and placing orders.

Please click on the Menu Bar above to see other features of Spark.

To Get a FREE TRIAL, send us an email .

Please take a look at Frequently Asked Questions before you start your trial.

Building an Automated Spread Trading System

Building an Automated Spread Trading System in Excel - Windows Software $79.95 . This online course shows you how to build an automated spread trading model using MS Excel. The System captures the price difference between security pairs of any type - indexes, stocks, futures, options, LEAPs, currencies. The System uses three proven technical indicators - exponential moving averages, Percentage Price Oscillator (PPO), and Donchian Channels - to capture spread movements when profits are likely to be greatest. Includes three spread strategies for Swiss Franc - Japanese Yen futures, Nasdaq - S&P 500 E-Mini, and 10-Year vs 5-Year U. S. Treasury Notes. The System is optimized for use with daily or hourly data, but can be used on any time interval.

Build an Automated Spread English

You are shown how to build a data "hub" with a DDE link, or run the model with free. csv data files from Yahoo! Finance or another source. A PDF Guide is provided along with the online course so you can choose how to learn in the most comfortable way. Also included is a complete backtesting model -- simply import historical data and see statistical and graphical results for your chosen spread strategy. What You Get: A TREMENDOUS 3-IN-1 VALUE! - PDF Guide - Online course including everything in the PDF Guide PLUS VBA Code and FAQs sections - Pre-built Backtesting Model in MS Excel with graphs and trade statistics - Online access to the course materials Benefits - Integrate Excel, VBA, formulas, and data sources into a profitable trading tool - Acquire knowledge applicable to any Excel modeling project - Save money by eliminating recurring software costs - Calculate Buy/Sell signals on multiple spread pairs within seconds Technical Requirements - MS Excel for Windows - Adobe Acrobat Reader - 5Mb disk space - Date-Time-Close price data on your chosen time interval - (OPTIONAL) DDE data import link for Excel

Building Excel Spreadsheet Vba Macro Dde Active Quote. Price Index Stock Future Option LEAP Fund Currency FX Exponential Moving Average Donchian Oscillator.

Build an Automated Spread Trading System

Software Download from Financial-edu. com / Venus United Capital

Captura de pantalla

Win 3.1x, Win95, Win98, WinME, WinNT 3.x, WinNT 4.x, Win2000, WinXP, Win2003

No Install Support

New Release

Bull's-Eye Broker is an advanced software package which constructs and maintains Point & Figure Charts. Point figure charts. Features include: High clarity full-screen charts, relative strength, bullish %, user defined box sizes and trend lines, buy and sell watch lists. eToro is an innovative Forex Trading platform, enabling you to easily practice and trade forex in a friendly and innovative environment. Etoro Forex. The power tool to read and analyze news. Knowledge mining from news. Market news. Features: RSS news feeds, Stock Navigator, Stock Research, News statistics, Rating news, News Statistics and News Rating Charts. Automatic monitor of more than 8000 stocks. Powerful financial software to monitor and analyze the performance of investments. Autoupdate worldwide market indices & Múltiples carteras. Stocks and securities manager. Set alerts, look up stock symbols, retrieve realtime quotes. Link to news, charts & online trading account. Compare stock or option transactions. Input transaction data. Stock option profit calculator. Calculates profit from transactions, potential loss, annualized profit (in dollars and as percentage), and annualized potential loss. Factors in commission fees. Stores results. 101Quote is an easy to use free intraday stock market quote tool. Portfolio quotes for stock investing. Integrated with portfolio tracking, customizable display settings, export to Excel and friendly with firewall and corporate networks, it is a must have for all market participants. Stock portfolio manager with advanced charting & statistics. Portfolio manager toolkit. PortfolioTK is a stock portfolio manager that provides both accurate quantitative statistics and advanced charting. 100% Free COM. NET and XML Web service providing 25+ technical indicators for the construction of technical trading systems. Trading system TA. By using these methods with our included JDBC mediator you will be able to iteratively apply these indicators to a DBMS. StocksAloud helps you manage your investments and business interests by tracking companies for you. Stock quotes. It let's you specify stock information to be read aloud for quick updates or full updates as well as listen to related news headlines. DAXA-Chart Privat is a freeware German program for analyzing and charting shares and portfolio management. Free stock analyzing. It is supplied with an initial database of 120 German stocks. Download further stockmarket price updates from our homepage for free. Trading and stock quotes downloading software for Microsoft Excel. Library of 146+ technical analysis functions. Technical analysis with stock quotes. You can download historical end-of-day and real time quotes into spreadsheets. Portfolio, stock options, stock charts, intraday. Free TSXV penny stock screener & research tool. Scan, analyze and screen for penny stocks using this all-in-one browser. Penny stock investing OTC and bb markets. Look up company profiles, news, market depth, trading signals and more. Simple and it works. TradeBullet is a multi-broker application that handles fully automated order routing to your broker from most chartingsoftware, MS Excel, Collective2 or any custom application. Automated Trading software. Built on an industrial-strength framework, TradeBullet is blazing fast. Ashkon Stock Watch es un software avanzado de gráficos para información de mercados financieros. Stock market charting. It allows to display several technical indicators for a single security on the same chart, open multiple chart documents and test investment strategies. Stock Market Investment Software for the Intelligent Investor. Stock investing. Make Better Decisions by following a systematic approach using the strategies of the all time investing greats (Buffett, Graham, Lynch, etc.). Paper trade with Forex Currency Paper Trader before you open a demo account. Paper forex trading. Keep track of your winning trades and build up your confidence before you open a demo trading with your favorite broker. Wintraday, a market data display software program designed for investors. Streaming quotes live. Wintraday is the result of new market data display technology, and allows individual investors to keep on top of their investments with up-to-the-minute updates on stock activity. Money Management Explorer allows you to learn secrets of money management and position sizing. Money management for position sizing. Now you will know how much to trade. forex trading intraday daily trade calculator on major forex trading pairs. Forex day trading. forex trading intraday daily trade calculator on major forex trading pairs strategy test profitable plan. TradUtil is an editor and repair tool for the MetaStock 3. Metastock computrac. 01 security format. Free Stock Market Analysis Selection Software finds the best stocks by sector. Based on the famous M7 technology. Investing in stocks. Shows strengths, weakness, and profit potential. Colorful graphic display w true 3D shadows. Rápido. Uses free Internet data. Pocket Charts is a sophisticated charting application for the Pocket PC operating system. Stock charts. It enables you to quickly download stock/index price data off the Internet and then view it in the form of interactive charts on your PDA. Free trial available. Forex Arbitrage Calculator allows to determine risk free arbitrage opportunities. Forex arbitrage trading. Forex Arbitrage Calculator allows to determine risk free arbitrage opportunities on forex cross rates. Maintain historical quote database, automatically discover & backtest strategies. Automated stock market system. Maintain a historical stock quote database, automatically discover and backtest powerful new strategies and distribute daily trading signals via daily emails. FREE Quote Watchlist Software for over 50 exchanges worldwide. Stock quotes with ticker. Keep track of your trades with this easy to use quote watchlist tool, data feeds are free so you can monitor your trades with zero cost. Anfield Capital Pty Ltd www. stator-afm. com. Stock Quotes and Chart for Smartphone. Control your stocks while you work or while you are mobile. Stock quotes. Besides, you can view news relevant to the selected stock, set customizable alerts, search for ticker and get company summary information. EZQuote allows you to download historical end-of-day quotes for virtually any stock, index, ETF or mutual fund publicly traded in USA and other world markets. Stock quotes downloader. The data can be stored in Metastock or ASCII format. Mr. Bigshot. the Bodacious Stock Market Game. Stock market game. Discounted Cash Flow Analysis of 14 cash flow series with 5 discount rates. Discounted cash flow analysis. Discounted Cash Flow Analysis Calculator performs a quick analysis of 14 cash flow series using 5 different discount rates per series.

This site as well as basic level software here’s meant just being an intro to the dimension as well as evaluation associated with Currency talents. It’s meant like a extremely swift, absolutely no trouble method of viewing what’s occurring within the complete Foreign exchange majors marketplace. For example from Birmingham open up or even Ny open up or even Ny collateral open up at the end from the 2nd hr. Or even frequently with regard to coming back customers through the years, on a higher effect financial discharge such as NFP to acquire a common concept of moves.

Haga clic aquí para descargar una nueva herramienta de comercio y estrategia GRATIS

Therefore, the actual power graph over is supposed to supply an over-all concept of common moves or even extreme emotion modifications. (discussed additional beneath underneath the downward slope section) However primarily, it’s meant much more with regard to finish associated with day time as well as weekend break representation as well as investigation. This particular software is actually not really meant to end up being examined on the minute-by-minute foundation with regard to temporary choice producing. Because mentioned in the event that this particular is actually your own purpose, make sure you acquire real expert resources which make use of loading information. That’s obviously, should you choose intend on creating a profession of the buying and selling point.

The actual simplified portion price associated with alter way of examining power associated with individual sets differs compared to regular Currency power method precursor that’s utilized inside our brand new 5NITRO+ Metatrader four Meters.

Free Realtime Data. With DDE

Originally Posted by avhsprao

Dear Friends, This is my first post to Traderji. com, I searched the entire form but was unable to find any support on DDE system, For those who dosent know what DDE is, DDE is a facility through which data can be sent from one program to another. I used RQT Download which gets NSE & BSE data from yahoo server and was able to export this data into a software I designed. Can anybody give me information on if NEAT or ODIN supports DDE transfer. My ultimate goal is to design a system where everybody will be able to get realtime data free of cost to their desktop.

Gr8 hope though. let me tel u my frnd that u can find an Excel sheet (Created by Cooltetra) which pulls Data From Yahoo to Amibrker SW. http://www. traderji. com/software/6866-coolworks. html

Now the matter of Fact is thatIf u hav Neat or Odin u dont hav to look around for anythng Else. because they can be easily used to Transfer Tick by Tick data to the Charting SW's. Now as u hav quite ambitius Plans to create a source of Rt data u can just Refer to that Excel sheet and hopefuly ul come thru some Idea.

I dont hav much idea of Computer programming But ican suggest that if u can create a SW which not only pulls data from yahoo BUT also NSE's SIte it can be gr8 help. Plus u can also look at the Codes from the NSe site. hope it all works.

Excellent inititive. support Guarenteed.

This is a though one… Everybody wants real time market data – in MS Excel, in Matlab, in Java, in Theta Suite etc. But, obtaining market data is very hard and cost intensive because the stock exchanges do not want to provide real-time data for free. Ok, but what can you do about it?

Artículos relacionados

About Excel This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

Currency Strength Review

Haga clic aquí para descargar una nueva herramienta de comercio y estrategia GRATIS

Otras personas buscadas:

Mensaje de navegación

Otros buscados

Archivo

Some Searches

Mensajes recientes

Categorías

Powerful stock quotes downloading software for Microsoft Excel. DownloaderXL package includes the following products: DownloaderXL, RTQuotesXL, OptionsXL and PortfolioXL.

DownloaderXL downloads free historical stock, index and mutual fund data into Microsoft Excel spreadsheets from Yahoo Finance. Historical data goes back at least 15 years and is available for exchanges of USA, Canada, UK, Germany, France, Italy, Australia, New Zealand, India and more countries. DownloaderXL easily builds charts.

RTQuotesXL downloads free 15-minutes delayed and fee-based real-time quotes for stocks, indexes, options, mutual funds, financial futures, commodity futures and other securities from Yahoo Finance and PCQuote. DDE feature is accessible. RTQuotesXL can be used for real-time charting, real-time technical analysis and monitoring current market situation.

OptionsXL is a option chains and LEAPS series downloader for Microsoft Excel.

PortfolioXL is a portfolio tracking add-in for Microsoft Excel.

Business & Finance / Personal Finance

Win95, Win98, WinME, WinXP, WinNT 3.x, WinNT 4.x, Windows2000, Windows2003

Top Personal Finance / Business & Finance programs

1) Smartstock 7.2.0 GsnIndia: Stock Trading software design to Increase Your Return, Minimise Your Losses by capturing the Stock Volatility. It is Designed for BSE which is Based on Robert Lichello Investment Theory.

2) Gas Mileage MPG Tracker 1.0 Gas Mileage Tracker is a program designed to help you understand and track your gas mileage and gasoline usage. Track total miles and gas mileage. Record each fill-up and MPG for multiple cars and vehicles. City and Highway MPG and miles tracked.

3) JD Free Calculator 1.15 JD Free Calculator is a complete replacment to the standard windows calculator. Not only does it perform all the functions of the windows calculator it also offers: Complete printable tape, A basic loan calculator with comparisons

4) iCash 6.0 iCash is a software intended to control your personal finance, keeping track of incomes, expenses, credits, debts and Banks transactions for you. As simple as creating the accounts you need and move money between them!

5) Portfolio Performance Monitoring 1.0 The Portfolio Performance Monitoring model enables the ongoing monitoring and periodic valuation of a portfolio of financial investments. Amount and timing of investment and divestment transactions are taken into account in performance calculations.

6) Budget Tracker 1.0 Budget Tracker is an easy to use program that will help you track and understand your monthly expenses. Each month you can enter in a number of specific monthly expenses including Rent/Mortgage, Utilities, Grocery, Entertainment, Phone, Medical, etc.

7) Mortgage Wizard Plus 6.7b Calculate US, Canadian and foreign loans. Very intuitive. Does late payments, lumpsum payments, changed payments, interest changes, etc. Use 360-day and Exact day factor methods. Crush your US or Cdn mortgage sooner and save on cumulative interest.

8) TigerTom's 100 Clever Finance Tips 1.0 An ebook covering one hundred personal finance tips and tricks. No installation required. Contains its own browser. Very simple and easy to use.

9) AceMoney Lite 3.19 AceMoney Lite makes it easy to manage a checkbook, create and manage budgets, juggle finances in multiple currencies, track spending habits, record expenses, transfer among accounts and even do on-line banking.

10) Quotes4u - download historical stock quotes 4.2.9 Quotes4u is a comprehensive downloader for historical stock quotes. Quotes4u directly passes the data into your TA-software like Metastock, Advanced Get, Tradestation, Fibonaci Trader etc.

New Personal Finance / Business & Finance programs

1) Forex Megadroid Software 2010.03 Automated Forex Megadroid trading software uses what is called 'Forex market adapting intelligence' to make the robot flexible enough to accomplish precise results in a fluctuating forex trading market.

2) Stock Quotes Pro 1.37 This automated data downloader instantly downloads end-of-day historical quotes of stocks, indices and mutual funds publicly traded in US, Canada and international markets. Get historical stock quotes for trading research is seconds.

3) Forex Autopilot Software 2010.03 Unlike the rest, Forex AutoPilot trading software enables you to generate a steady stream of income on auto-pilot, 24 hours a day, 7 days a week. Start Generating Passive Income from Forex Trading Within Minutes! Its 100% legal, 100% automated!

4) Your Insurance Calculator 0.1 Free web based application to help anyone to find the best insurance rates. Very simple to use or understand. Per user request are returned results concerning auto, health, life and homeowners insurance.

5) Falco Annonce Maker 1.2 Tired to make announces for your customers? Maker resolves it in "2 clicks".

6) Forex Automoney Software 2010.02.1 With Forex Automoney everyone can earn every day! Our Forex signal system is working in all countries of the world. Absolutely everywhere! Also you can be absolute newbie to use our system - you don't have to know ANYTHING about trading

7) Forex Strategy Builder 2.12.0.0 Forex Strategy Builder is a freeware CFD, Indexes and Forex strategy back tester with a complete visual interface. It provides tools as a scanner, an optimizer and an automatic strategy generator. It includes one hundred technical indicators.

8) Doubling Stocks (stock trading robot) 2010.02.1 The first commercially available stock picking & trading "robot", Doubling Stocks, performs the technical analysis: analyzing the charts, the fundamentals, etc. for thousands of companies. All to help you pick the most profitable pennystocks.

9) Forex Strategy Trader 1.0.0.0 Forex Strategy Trader is a free trading platform working via Meta Trader. It can automatically send and execute trading orders based on a predefined strategy. The visual interface allows users to create their own strategies without any programming.

10) Stock Predictor 1.1.323 Chart stocks and backtest your stock market trading strategies using historical market data. This software features include over a dozen built-in technical indicators, more than 600 investment strategies, free data feed and more.

Recursos

DDE - What is it?

If youвЂ™ve been around Human-Machine Interface (HMI) software much you may have heard the term DDE used in conjunction with device communications. DDE stands for Dynamic Data Exchange. DDE is a method for exchanging information between applications running on the Windows operating system, all the way back to Windows 2.0! ThatвЂ™s right, there was a Windows 2.0 back in the late 1980вЂ™s and believe it or not it ran just fine on a 20 Mhz 286 PC and was screaming fast on a 386! One of the earliest demonstrations of DDE was using it to exchange data between Word and Excel.

As the first Windows-based HMI software came to market between 1989 and 1991, the developers chose to use DDE to connect the HMI software to their device drivers. The device driver that connected to your PLCs or process equipment ran as a separate application called a DDE Server. The HMI software was a DDE client application that requested and received data from the DDE Server. By having the DDE Server as a separate piece, it was very easy for 3rd parties to create

Do you have old DDE Servers and want convert them into OPC Servers?

Check out the TOP Server DDE Client driver and add OPC Independent Lab Certified OPC support for your DDE Server

Do you need to connect to a DDE Application like Excel?

drivers that would work with any HMI or other software application that used DDE. We remember the amazement in peopleвЂ™s faces the first time they saw an Excel spreadsheet connected to a PLC through a DDE server back in the early 1990вЂ™s. The DDE client application accessed data by specifying the request in the format of Application|Topic! Item, where Application was the name of the DDE server. EXE program, the Topic was a user configured name representing a group of data, such as a PLC, and the Item was a specific tag or data point in the PLC.

DDE by itself has some shortcomings, primarily performance. The communications between the DDE client (HMI software, Excel, etc) and the DDE Server (the PLC driver) have to pass through a software message routing mechanism in Windows, which back before Windows 95 and NT was not very fast, and even today by itself is slow with large data blocks. Data throughput speed and volume of data was limited by this factor. To address this issue, Wonderware developed and released FastDDE to the market along with a toolkit for building FastDDE servers. The extensions to DDE developed by Wonderware in FastDDE gave the technology a huge boost. Later, in the mid 1990вЂ™s, Rockwell Software released AdvanceDDE as their performance boosting version of DDE.

Along with these performance enhancing evolutions came NetDDE. NetDDE allows a client running on one PC to access data from a DDE server running on another PC! At the time this feature came on in the early 1990вЂ™s, it was revolutionary. All users had to do was specify a machine name on the network in front of the Application|Topic! Item naming convention.

Today, almost all DDE servers support at least 2 of the 3 if not all 3 of the forms of DDE: DDE (also called CF_Text or XL_Macro), FastDDE, and AdvanceDDE in one driver, giving the user the maximum of flexibility. Software Toolbox offers a variety of DDE servers.

As you may have sensed here, technology has marched on. Although DDE is still easy to use and a perfect fit for some applications, itвЂ™s limits can be a problem in some applications. Also, when using tools such as Visual Basic, integrating with a DDE Server can be cumbersome. There are two product types that have replaced the DDE server in the market for applications where DDEвЂ™s limits are an issue. These technologies are ActiveX and OPC. Learn more about these technologies and their benefits in the related articles below:

eSignal

Berkeley offers eSignal, a premier trading platform with Direct Market Access (DMA) to 25 futures and options exchanges and 44 Executable Streaming Price (ESP) forex currency pairs. Equipped with global market data and analytical tools, eSignal's functionality is suitable for institutions and private investors alike. eSignal is renowned for containing all its features in one single, portable platform.

Key features of eSignal:

Trade futures, options and forex

Real-time profit & loss monitoring of open positions

Fast and reliable access to extensive history and research

Real-time global market data including foreign exchange, futures and options, equities, and commodities delivered via the internet or private networks

Data can be exported to Excel using Dynamic Data Exchange (DDE)

Back testing and strategy analyzer offers a total performance perspective and ability to dissect individual trades

Advanced charting capabilities including technical indicators, a Formula Wizard, and line drawing tools. A key asset is the Stretch Chart - a 1-day chart showing the pattern of the day

Share your information with worldwide eSignal users via the File Sharing feature

Time alerts to notify users when the market opens and closes

High volume data coping mechanisms such as hibernating unused symbols (yet it will never hibernate any symbols for which alerts are set)

Global weather maps covering US Agriculture, US and European Energy, and the World Coffee Crop

eSignal's Continuous Contracts feature enables you to monitor all active contracts with one symbol

Portability enabled by easy connectivity (only requirements are an 800 MHz PC and an Internet connection)

User-friendly front-end trading interface with integrated direct access training

Simple and free software upgrades

Variety of delivery methods significantly reducing the cost of providing data

eSignal, Advanced GET Edition

eSignal, Advanced GET Edition, is a unique, award-winning combination of:

Market data and decision support for trading stocks, futures, options and forex

Professional, proprietary indicators

Used by individual traders and institutions worldwide, Advanced GET builds a solid mechanical system on the most profitable pieces of 2 market theories.

With these indicators, you can make a plan based on sound strategy and stick to it. More than software, it is techniques consistently applied using the best information and the right tools.

Advanced GET gives you the power to:

Quickly identify trends

Determine entry / exit / support / resistance targets to plan your moves

View the predicted performance of your portfolio in multiple time frames

Manage risk to reward

Master market uncertainty

Use exclusive, rule-based approaches with confidence backed by expert coaching

DDE-to-RTD Converter for Microsoft Excel

In order to smoothly transition from DDE to RTD, CQG provides a tool that converts all DDE-coded spreadsheets into RTD format. This zip file contains the converter for updating DDE coding in Excel to RTD language and includes a DLL necessary to run the converter. CQG continues to support DDE.

The converter will rename the Excel spreadsheet to include "_RTD" in the file name. For example, MyStudies. xls will be renamed MyStudies_RTD. xls. The converted spreadsheet will be saved into the same folder as the original Excel file.

To convert a file to RTD, drag and drop the spreadsheet onto the converter, or click Add, select the file to be converted, and then click Convert. Select Make expressions uppercase to make sure lower-case symbols are not misinterpreted within the RTD syntax.

Log off CQG Integrated Client before converting an Excel file so that CQG IC does not interfere with the conversion.

Renuncia

Trading and investment carry a high level of risk, and CQG, Inc. does not make any recommendations for buying or selling any financial instruments. We offer educational information on ways to use our sophisticated CQG trading tools, but it is up to our customers and other readers to make their own trading and investment decisions or to consult with a registered investment advisor. The opinions expressed here are solely those of the author and do not reflect the opinions of CQG, Inc. or its affiliates.

Microsoft Excel is a registered trademark of Microsoft Corporation in the United States and/or other countries.

Forex Product Guide

The line of the products that we developed over the last 10 years is quite extensive. Very often we receive same question over and over again so we decided to put most freaquent questions together in this post and try to answer them.

What forex robot has the best performance?

What MT4 indicator is the best?

What iswin/lossratio ofyour indicator?

You have a lot of tools, which one is more suitable for me?

These questions are not easy to answer. You have to consider a lot factors before you can justify

Trading style you are comfortable with

Execution type provided by your broker

Account size

Minimum lot size allowed by your broker

Your risk appetite

Etc.

Below, I would like to give you some recommendations on how to select the right product according to your needs and trading conditions.

Robots based on: MACD divergence. Momentum Divergence and Wolfe Wave . These robots can open several positions simultaneously. They are suitable for larger size of account (>10,000) and if your broker allows small lot size-0.01. These three robots are very popular for PAMM trading. They are not sensitive to broker’s execution. Risk will be Low during the side moving market and High in trending markets.

Forex Robot TFOT . This robot will be suitable for long-term investments. This is not a scalper and can show up to 2-3 months drawdown. Usually makes around 100 -200% annually with low risk settings. Broker neutral but still needs good spreads. Recommended broker: http://fxmars. com

You can start with small deposit $100 -200, if your broker allows minimal lot size =0.01 or 1000-2000 with minimum lot size =0.1

HF-scalping forex robot and ProScalping Forex robot . These robots are very sensitive to broker, account type, vps etc. We recommend you to do an extensive testing before you buy it.

RapidE forex robot (new). This robot will perform well, if your broker has low spreads with low commission. You can start with small deposit of $100 if your broker allows 0.01 lot size or 1000 with 0.1 lot size. It has Low risk. Recommended broker: http://fxmars. com

MT4 indicator is not a trading strategy. It can be a core indicator or just one of the filters. For this reason win/loss ratio depends on strategy, position management, other indicators, filters or rules you use.

Divergence indicators and advanced divergence indicators . Divergence indicators can generate pretty good signals to open position (standard divergence) and for position continuation (hidden divergence). Recommended timeframes: m5, m15, h1, h4. As a basic we recommend to use it with Support/Resistance indicator.

Super Divergence indicators . Use of two or more divergence indicators allows filtering out false signals. You can use Super Divergence Contractor to try combination of different indicators and then order upper divergence indicator according your needs.

Wolfe Wave Indicator . The indicator shows the entry point and even an inexperienced trader can find the exit point guided by our recommendations. Recommended timeframes: h1, h4

Trend Indicator . This indicator is really good for scalping strategies. We recommend to use it with Support/Resistance indicator.

Elliott Wave indicator . This indicator will bring you more benefits if used for long term trading.

Trade copiers . It allows you to simply copy anyone’s trades if you know investor (read only) password . Say you have a friend who can trade really well. Set his account up as a master, then set your account as a slave and you will mirror his trades, without losing control of your funds. Recommended for all traders and money managers.

DDE tool . This tool allow you to load any info from MT4 or MT5 to Excel for further analysis in real time mode. Recommended for experienced traders.

News Trade manager. This forex software helps to prevent losses from unpredictable market movement at economic news.

Virtual Stop Manager . The purpose of this forex software is management of StopLoss and TakeProfit values on trader’s side. The main goal is to hide your actual stops from broker. This tool is recommended for all traders.

Report Parser Software . Allows you to combine several strategy tester reports into one standard back test.

Custom VBA by Exceltrader

****Please note: Custom Programming is not currently available due to existing obligations.****

With a little programming almost any trading related need can be met in excel. Examples of my very recent completed Projects include:

Automated Forex System (single signal with 5 time frames and Backtest)

Forex Arbitrage System (rapid execution required)

Options Automated Trading System. Monitor and analysis. (Black Scholes calcs, IV, Projections, automated Log, other custom calcs)

Stock/ETF: End of Day Scanner and intraday Signal alerter.

Automated Futures Trading system and back testing with analysis of tick data – daily data and VIX correlation study.

Automated Stock Trading: Backtesting. Unlimited Symbols: Results Analysis (Sharpe ratio etc.)

Analysis of Live data in terms of Rise/Run. Summary of all Slopes.

Excel Integration (quotes and orders) with the ChoiceFX api. (Part of a larger Automated Forex System.)

Automated Stock Trading system with over 50 system choices built from drop down menu.

Simulator and ATS integrated with another VBA author’s code

DOM/ Depth of Market Order entry system and trade manager.

Many other Trading related Excel/VBA projects.

Other Non VBA Projects:

A Real Estate investing website which includes interactive display of Available Properties including user chosen loan terms such as rate, term, management fee, taxes etc. User can sort by cash flow, Return on Investment etc. (PHP, Mysql, Javascript) *Note that the links were posted with permission from the client. No private client information is ever posted without your permission.

My hourly rate for trading related VBA custom programming is 45 dollars.

To get started, send an explanation of what you would like programmed to the email address located in the image at the top right of this page. I will respond back with preliminary estimated hours. If this estimate is acceptable to you, then the next step will be to send all detailed information that you feel would be necessary in order successfully complete the project. I will then respond with any questions/clarification needed.

I will then inform you of final estimated hours and begin your project. (if it takes me longer than final estimated hours there is no additional charge as long as no additional items have been requested).

“The version 1.13 works very well for US stocks. ¡Muchas gracias! You are the excellent system developer i ever meet.”

Dr. Thomas KL Tong, Project Manager, CityU Professional Services Limited, Hong Kong *quote and name used with permission

Attempting to go live with the US opening today, but there is a problem with my workbook. Worked fine yesterday, did not make any chances since. Before, i needed to change my windows settings to an different number format, since my feed uses ". "for decimals, not ". ". Hope you can check it out, so i can use my workbook to trade today. I send it to you together with the error code

In cell O140 there is a "BUY" (to open) and also a "SELL" (to close) in P140. This will result in a continuous loop that will result in an error. There should never be a sell to close at the same time there is a buy to open so the formulas should be changed/fixed so that this never happens. (This crossed logic is one of the biggest dangers of automated trading systems, imagine some programming error where the system just bought and sold non stop all day.)

To fix your formulas without all the error messages, open Excel, click TOOLS> MACROS> SECURITY> and set it on the highest setting (so that you can open the workbook without code running). Then open up the worksheet and fix the formulas so that there is no simultaneous buy to open and sell to close. (Once that is done, lower the security settings again, save close and reopen the workbook so that code can run.)

Before you leave ---

DDE and COM in Visual Basic

DDE in Visual Basic

The native implementation of DDE in Visual Basic is poor in terms of capability, speed and bugs. DDE is not supported in VB. NET. (Also Known As VB. NOT because it is completely different from VB6.)

When VB is acting either as server or client .

The built-in VB DDE mechanism is much slower than when the Windows API is used.

Except for pictures, only string data can be sent and received.

You cannot use VB native DDE in a Visual Basic authored ActiveX Control.

In addition, on the client side .

Event driven programming is not possible, all calls are synchronous with a timeout. The VB program cannot continue processing whilst waiting for a reply from the server, it must wait until the server responds or the timeout expires. (Data sent on hot and warm links is not sent in response to an individual request.)

You cannot turn Notification or a hot link on or off without closing the DDE conversation and opening it again. Every change of LinkMode closes the conversation and starts a new one, which is a time-consuming process. Of course, setting mode 0 simply closes the conversation.

The LinkOpen event is raised for a destination control (DDE client) every time it attempts to open a DDE conversation. There is no indication of whether the attempt succeeded. The event is raised on startup even if the LinkMode is initially 0.

If the program is running on Windows 95 it may crash if too many links are made. For details see Q180624 Invalid Page Fault Occurs with More than 34 DDE Channels.

It misses data on hot or warm links if the server is too fast because it always uses the fAckReq flag (see The missing data and unreliability problems .)

In addition, on the server side .

The Service and Item names are limited to valid VB names, although DDE itself has no restrictions.

The Service name is the original name of the executable. The Item name is the name of the control supplying the data. Both are fixed at compile time and cannot be changed.

Each source form can have a maximum of 128 data items.

DDE must be enabled when the server starts, by setting the LinkMode property to 1 at design time. Once the program is running DDE can be closed down by setting the property to 0, and re-enabled by setting it to 1 again.

If another application does a "Wildconnect" your VB server will probably crash. A crash is less likely if links have been previously opened with the server.

The solution to all these problems is to use our DDClient and DDServer controls. You can work asynchronously using Events, it allows the server to send data as fast as it wants and there are no built in limitations. However, even using DDClient messages will be missed if a MsgBox dialog is on display, because it causes all events to be ignored. The answer is to use the MessageBox API call instead. Details of how to do this can be found on the DDClient support page.

You can download DDClient and DDServer from the the DDE download area. Sample native DDE server and client projects are also available from the download area.

COM in Visual Basic

Visual Basic is good for programming clients and servers when the client creates an instance of a server object or application. It has poor support for programming a client or server when the server must run continuously.

On the client side . GetObject() only works in limited circumstances. It cannot work at all with applications such as Internet Explorer which do not register themselves in the Running Object Table (ROT). We have not been able to make it work properly without a file name. Even when it succeeds with a file name it connects to a random instance of the server, when there is more than one. A typical continuously running server is monitoring hardware or other applications and does not use file names in the required way.

An alternative mechanism is to set a reference to the ActiveX EXE server. The Global MultiUse classes can be accessed by the client. Windows will start the server if necessary. The disadvantage of this method is that the client must be recompiled every time the server is changed. Supplying a drop-in server replacement does not seem to be possible.

On the server side . a continuously running server cannot be programmed at all except by an horrendous hack. It is necessary to construct a vtable interface as an array of Longs and write the QueryInterface, AddRef, Release and other interface code in longhand Visual Basic. The Windows API is used to register the interface in the Running Object Table and remove it when the server closes.

The method was described by Matthew Curland in the August 1997 issue of the Visual Basic Programmer's Journal, page 109. There is a much more extensive treatment of the topic in chapter 10 of his book Advanced Visual Basic 6, ISBN 0-201-70712-8. The book includes the code, which is also on the companion CDROM.

DDE and Visual Basic. NET

VB. NET has no native support for DDE. You will have to use the API, or alternatively components such as our DDClient and DDServer controls.

COM controls do not work properly in the Beta 1 release of VB. NET. Events do not reach the application. Vtable calls are not supported, although this does not affect DDServer and DDClient. We are assured on the. NET newsgroups that these problems will be fixed in the Beta 2 release.

How the Windows Shell uses DDE

The Windows Shell uses DDE and the registry to implement the mechanism whereby files with a particular extension are associated with a group of Action Verbs. The Shell uses the information in the registry to construct a command line for the associated application, and optionally to specify a DDE Execute command to send to it. The application is launched with the command line only if the attempt to send a DDE command fails. The full details of the rules and registry entries are on the File Association Editor page.

If more than one file is to be opened with a running instance of an application, the Shell starts a new DDE conversation for each one. All the conversations are left open until the final Execute command has been sent, at which point all the conversations are closed. This is a rather time-consuming way of doing things, but it does enable the application to determine whether all the file names have been sent. The application must count the number of conversations still open, and process the list of files when it falls to zero.

Supplying a command line is a simple task for which COM is obviously far too cumbersome. But the Shell does more than that with DDE. You can create, modify and delete program groups and their Shortcuts with a DDE interface which is almost unchanged from 16-bit Windows. The link to the specification on MSDN is at How to get further information.

The 32 bit Shell has a COM interface called IShellLink for maintaining Icons and Program Groups. You can use this as an alternative to DDE, but less and simpler code is required using DDE. Even Microsoft has to admit this, if you search MSDN you will find an article entitled "IShellLink-Shortcuts the Long Way" (it concerns shortcuts in the context of Visual Basic). However, 32-bit Shortcuts can be used for purposes other than launching files, for example they can refer to Control Panel items and other types of Shell object. DDE can only be used to manipulate the top level program groups, not groups within groups. If you want to do any of these things you must use IShellLink.

A difference in the DDE interface between 16 and 32-bit Windows is detailed in Knowledgebase article Q99456 Win32 Shell Dynamic Data Exchange (DDE) Interface.

Cannot find the file. (or one of its components).

One possible reason for this message box is that the Windows shell has not been able to establish a DDE conversation according to the specification in the Registry. If this is so, you can edit the file association for the offending verb using the View. Opciones. dialog of Windows Explorer, File Types tab. It possible that the Application or Topic name is wrong, but more likely you need to uncheck "Use DDE". Alternatively, you can use the File Association Editor. a free download from this web site.

A likely cause of the error, if DDE related, is that another application has modified the entry for files with an extension such as. txt. Notepad does not understand DDE.

Web browser DDE

As we have pointed out in the article When is DDE more suitable?. DDE is the ideal way of monitoring the activity of another application. Both Internet Explorer and Netscape Navigator implement a DDE interface for this purpose. You can download our freeware WebSpy Visual Basic program which uses it.

Netscape Navigator 4

Implements the Spyglass specification. Scroll down for a section on Netscape6.

One of the most commonly asked questions is how to open a document in a new window instead of reusing an old one. One way of doing it is to start a new instance of IE. Two factors affect whether a window in an existing instance is reused:

The setting of the "Reuse windows for launching shortcuts" option under the Tools..Options..Advanced tab of IE. The name is misleading, it affects the issue however the document launch is initiated. If this option is not checked, a new window is opened regardless of the DDE command.

The DDE command used to open the document. The default one for the http protocol is "%1",,-1,0. The third parameter -1 tells IE to reuse the current window. If this is replaced by a zero "%1",,0,0. a new window is opened regardless of the "Reuse windows for launching shortcuts" ajuste.

The fourth parameter 0 does not have any effect, according to Q160957. In the file association for HTML types the DDE command is by default "file://%1",,-1. Again, if -1 is replaced by 0 the file is opened in a new window.

The differences between the Internet Explorer DDE interface and the Spyglass specification are detailed in the following Microsoft Knowledgebase articles:

Q160957 DDE Support in Internet Explorer Versions Q191508 Confusing Return Values from DDE topic WWW_ListWindows Q160976 Controlling the Currently Running Instance of IE3 via DDE Q167826 DDE with IE Does Not Work As Expected

There are other differences, not mentioned in any Microsoft article we are aware of. The following table summarizes them.

Netscape Navigator 4

Multiple Browser instances

Each instance of Internet Explorer registers itself as a DDE server. To distinguish between them a client using DDEML can connect with the instance specific service name handle. If this is not done, it is pot luck which instance will establish a conversation with a client. If you open a file by double clicking it you cannot control which instance of IE will open it. Instance specific handles are transient and cannot be held in the Registry.

When the first instance of Navigator starts it registers three services, NETSCAPE, nsshell and NSCMDLINE. When a second instance starts it establishes a conversation with the first instance on the service NSCMDLINE and topic WWW_ProcessCMDLINE, the execute command - BROWSER is sent, then the second instance unregisters its services. All DDE communication with Netscape by external applications is with the first instance started.

Internet Explorer does not respond to wildconnect. The client must specify both the service and topic names.

Wildconnect is accepted. A conversation on all the supported "WWW_xxx" topics can be established with one DDEML call.

URLs reported by WWW_RegisterURLecho

Internet Explorer reports only the URL requested by the user.

Netscape Navigator reports all URLs loaded including images. All refreshes are also reported, including those in Meta tags and aminated GIFs.

Quotes in strings

Article Q167826 points out that according to the Spyglass specification, quoted strings should be enclosed with the escape sequence \", not just a double quote mark. Internet Explorer 5 will accept either.

Netscape Navigator 4.7 only accepts the quote mark by itself, the response of other Netscape versions is not known to us.

Netscape 6 Beta releases

The Netscape 6 Beta DDE interface is non-standard and reduced to a single feature, opening a web page. Connect to service Netscape6 and Topic WWW_OpenURL then issue an Execute command, a request no longer works. The command string must be of the form "Full path to netscape6" "The URL required" including the quotes. It always opens the new URL in a new window.

Netscape 6 non-Beta

The Netscape 6 non-Beta DDE interface seems to be reduced to absolutely nothing. It is possible to connect to service Netscape6 and Topic WWW_OpenURL, but Execute commands do nothing (although they do not fail), and requests fail.

Opera commits a stupid and unforgivable sin. In addition to responding to the service name "Opera", it also responds to "IExplore" and "Netscape". What this means is that a program trying to connect to Netscape or Internet Explorer is likely to be connected to Opera instead. Opening a URL is the only DDE operation that seems to work. Opera does not even implement the reduced functionality of Internet Explorer relative to the Spyglass specification. It accepts a conversation on the topic WWW_RegisterURLEcho, but then refuses the Poke required to specify the service name for notifications.

Controlling Excel with DDE

Excel is controlled by using it as a DDE server. Excel is a client only when a cell or range has a formula which uses DDE to get the cell contents. DDE allows you to handle multiple instances of Excel, something which is not possible using automation. Each instance offers the "System" topic. The other topics are of the form "[Workbook]Sheet", one for each open workbook regardless of the Excel instance hosting it. The workbook name is the filename of the opened file, if there is one. The filename without square brackets is also available as a topic.

All DDE Service, Topic and Item names are insensitive to case. The DDE Execute command strings are also case insensitive.

If you request "SysItems" on the System topic, you get a list of items available on that topic:

SysItems - returns the item list.

Topics - returns "System" and the list of [Workbook]Sheet topics.

Status - returns "Ready" or "Busy".

Formats - returns a tab separated list including XlTable, cvs, rich text format, bitmap, and text. You can request and poke data in any of these formats.

Selection - returns the current selection of the selected worksheet in the format "[Book]Sheet! R1C1:R2C2".

Protocols - returns "StdFileEditing" and "Embedding".

EditEnvItems - returns a list starting with "StdHostNames".

The format CF_TEXT must be used for all requests on the System topic.

To manipulate single cells or ranges, use DDE Request and Poke commands on the [Workbook]Sheet topics. The DDE item is the cell name (e. g. r1c1) or range (e. g. r1c1:r10c2).

Single cell data is straightforward. To read the data in a cell, issue a request for the data with the item name being the cell address, such as r1c1. You can also start an advise loop for the cell, known as a hot link. Excel sends the cell contents to the client whenever it changes. To modify the data in a cell, issue a poke transaction with the item name being the cell address as in a request.

There are several ways to populate or read a range, when the target is an array of cells.

In text form, separate the colums with Tab characters and put each row on a new line, to make a grid like the Excel cells. Poke using CF_TEXT. If you request a range in text format the data is laid out in the way described.

Separate the columns with commas instead, to make a CSV format (comma separated variables). Register the Clipboard format "CSV" and use that instead of CF_TEXT.

You can also use XLTable for transferring data when the item name is a range.

You cannot poke or request any part of the active selection if it is being edited in Excel.

Built-in macros can be run on any topic with a DDE Execute command. The command string is the macro enclosed in square brackets, for example [Select("r1c1:r2c2")]. Commands can be concatenated, for example [ALERT("Hello world")][ALERT("Hello again")].

To get help on the macros, download macrofun. exe or macro97.exe from the Microsoft web site from these Knowledgebase articles Q143466 for macro97.exe and Q128185 for macrofun. exe.

To run macros you have written, use the RUN macro like this: [RUN("MyMacro")]. Your macros cannot have parameters. You can write macros to set variables, then execute other macros which examine the variables you have assigned.

In the DDE Software download area there are sample programs (with full source) which manipulate Microsoft Excel using DDE. The compiled C program is only 17kb, and it does not rely on any external DLLs (apart from the Common Controls which is for the User Interface, not DDE).

Controlling Microsoft Word with DDE

The Word DDE interface is similar to that of Excel. with a System topic and a topic for each open file. You cannot connect to the topic of a new document until it has been saved to a file, then it has a topic which is the file name. The commands to send in [] brackets are Word Basic commands. These are the macro commands of Word 7 (Word for Windows 95). If you run Word 7 you can discover the built-in macro commands by recording one of your own.

In Word 97 Word Basic is replaced by VBA and the Word Object Model. The macros you record use object model commands which cannot be run using DDE. Execute commands sent by DDE must still be the old Word Basic ones. The implementation is that a temporary macro called TmpDDE is created using the old macros as elements of the WordBasic object. For example, "CharLeft 1" becomes "WordBasic. CharLeft 1"

Until recently Microsoft had a Word Basic help file installation program on the web site, but it seems to have gone. You can download the file from the Angelfire server only: click to download wrdbasic. exe.

Some of the commands, with no explanation, are in the help file installer Position. exe, which can be downloaded from the Microsoft web site by going to Knowledgebase article Q112733.

Why does Excel crash when I link a cell to a DDE server?

Obtaining data from Reuter's IDNDDE

The topic DDE and COM in Visual Basic explains why Visual Basic can loose updates from Reuter's IDNDDE. Some improvement can be obtained by instructing IDNDDE to ignore the request to wait for acknowledgement of data receipt and to send new data regardless. In the file IDNDDE. INI there is a section for each application which uses it. If you add the line NOREQACK=1 to the relevant section IDNDDE does not wait for acknowledgements from that application.

Deliberately disobeying the correct DDE message protocol is not a good idea. The best solution is to use our DDClient control . which you can download from the the DDE download area. DDClient does it properly, it does not ask the server to wait for acknowledgment.

There is another problem with IDNDDE which DDClient also solves. IDNDDE may send data on an advise loop before it has sent an acknowledgement to the client ccepting the request. The client is not expecting data at that point so does not acknowledge it, stopping IDNDDE from sending any more data. DDClient has a mechanism for handling this early advise data.

DATE: 8.05.2012 nick: sandconsgi

replay software excel

Excel Charting Tips for Engineering, Manufacturing and Scientific.

Replay converter 3 0 registration code software: Replay converter fast easy to. Nemo Excel To PDF 3.0 is professional software to convert Excel to PDF with ease. AZQ Android - WCDMA/GSM DriveTest Tool on Android

Live blog replay: Software Satisfaction Awards 2011 hosted by.

replay converter 3 0 registration code | Windows | Download That Just use the Replay software’s “Export Log” feature to combine multiple logs, and export to Excel, CSV/TXT (for import to Mapinfo, Actix) and KML for playback in. Two questions: Can I input text/data into Excel using the Voice Recognition Software that comes with Vista? Can I do this using only a microphone or can a digital. Your trading software shouldn't hold you back, which is. Market Replay is an easy to use application that handles. Excel DDE. Use your own Excel spreadsheet to manage. OEC ™ - Futures, Forex and Equities Electronic Trading System.

Live blog replay: Software Satisfaction Awards 2011 hosted by Alastair Campbell. Excel Vista Speech Recognition software and Excel. - Microsoft Answers Tips on charting data with Excel, expecially readings acquired from laboratory. running charts after collection has finished, you could use the Windmill Replay software.

replay software excel Software Testing & QTP: Evolution of Automated Testing Tools

Board index » delphi » DDE + Excel ?

Quote

Oleg Soubatchev wrote:

& Gt; Because of low speed of interaction with Excel through automation > I want to try to use DDE to communicate with Excel.

& Gt; Where can I get information about Excel as DDE-server.

Everything I know about this is on the web site below. Go to the DDE FAQ page and there are links from there.

I would be very interested to know if DDE is really faster than OLE. It should be if you use asynchronous transactions, because the client can continue whilst the server is waiting for and processing the message.

BTW, I don't know anything about Delphi, only DDE.

Roger Abbott, RHA (Minisystems) Ltd http://www. rhaminisys. com DDE and WM_COPYDATA Interprocess Communication Controls and FAQ Other Freeware and Shareware

Quote

& Gt; -- > Oleg Soubatchev > soubatc. @ural. ru

Tue, 10 Aug 2004 02:59:22 GMT

Re:DDE + Excel ?

Roger, thanks for the DDE reference. I have been wanting to get this kind of info for a long time. There was a magazine called Personal Engineering & Instrumentation news, they stopped publishing a while ago. Anyway, I recall an article about lightning fast DDE. I will see if I can look it up for you.

Thanks, David Evennou

Quote

"Roger Abbott" <roge. @aol. com> wrote in message

Quote

& Gt; Oleg Soubatchev wrote:

& Gt; & Gt; Because of low speed of interaction with Excel through automation > & Gt; I want to try to use DDE to communicate with Excel.

& Gt; & Gt; Where can I get information about Excel as DDE-server.

& Gt; Everything I know about this is on the web site below. Go to the DDE FAQ > page and there are links from there.

& Gt; I would be very interested to know if DDE is really faster than OLE. It > should be if you use asynchronous transactions, because the client can > continue whilst the server is waiting for and processing the message.

& Gt; BTW, I don't know anything about Delphi, only DDE.

& Gt; Roger Abbott, > RHA (Minisystems) Ltd > http://www. rhaminisys. com > DDE and WM_COPYDATA Interprocess Communication Controls and FAQ > Other Freeware and Shareware

& Gt; & Gt; -- > & Gt; Oleg Soubatchev > & Gt; soubatc. @ural. ru

Other Threads

Connecting Excel to ControlLogix

Have you ever lost data in a CLX processor, because you downloaded new code? Unfortunately, when you donwload a program to a ControlLogix processor, you also download the values of the tags (variables).

A solution to this problem that could be useful, is an Excel sheet that reads and writes values to the ControlLogix processor using the DDE/OPC capabilities of RSLinx.

In this article, I will show you how to create one of these sheets for your projects.

Here's what you'll need:

Microsoft Excel, with some basic knowledge about programming macro's in Visual Basic

RSLinx (not the 'Lite' version, because that does not have DDE/OPC capabilities)

A ControlLogix processor of course

Let's fire up RSLogix first, and create a bunch of tags with values. In this example, I created 2 arrays, of the types DINT and REAL, each with a length of [10] tags. These arrays I filled with some values:

I'm not going to do anything with the PLC program, I just need some data in a number of tags.

Next, we're going to set up a DDE/OPC Topic in RSLinx. Depending on the version of RSLinx you use, it might look slightly different, but you should be able to follw this with the screenshots.

Assuming that you know how to setup RSLinx initally to get online with your controller, I've skipped some steps. The setup I use looks like this in RSLinx:

As you can see, I have a 10 slot CLX rack, with a 1756-ENBT card in slot 1 (address 134.200.211.16), and two processors, one in slot 0, and one in slot 2. The one in slot 2 is the processor we are going to use for this exercise.

Now, open up the DDE/OPC topic configuration by clicking 'DDE/OPC' and then 'Topic Configuration' in the top menu of RSLinx.

I'm going to create a new DDE/OPC topic called 'EXCEL_TEST', and use the Logix5550 processor in slot 2 as the data source. In order to do this, you have to click the 'New' button, give the topic the desired name, and make sure the processor in slot 2 is selected as the source before you click 'Done'

To test if your setup is working, at this point you can use the OPC test client provided with RSLinx. I'm not going into detail about that, but I did make sure this worked before continuing with the next step, creating the Excel sheet.

Let's start up good old Excel, and create a new workbook. On this workbook, place a new command button. You can find the Command Button control in the 'Control Toolbox' toolbar in Excel. When you have the button, right click on it and choose 'View Code'. This will take you to the Visual Basic Editor:

First, create a function that will open the DDE topic to Excel:

Now, if I call this function from the CommandButton1_Click event, it will open the link to RSLinx:

The variable 'rslinx' will hold the number of the open channel. Â All subsequent DDE functions use this number to specify the channel.

To save you all the steps to program the rest of the code, here is the final code to get the array of REALs out of the controller, and put them in cells D2 â€“ D11, and the array of DINTs in cells E2-E11.

Now we know how to read, it would of course be a lot of fun if we could write values as well. I would like to be able to change the values in the cells, and then hit a 'Write Data' button.

First, make another button on the sheet (mine looks like below now)

And then write some code for the button:

The way this is implemented is of course very rudimentary, but once you get the concept, the sky is the limit.

To make this easier on everybody, I've included the Excel file with the code already in it. The only thing you have to do to make this Excel sheet work, is make sure there is an DDE/OPC topic in your RSLinx setup called 'EXCEL_TEST', and the arrays REAL_Array and DINT_Array in your controller (of at least length 10).

What is DDE and why is it totally different from COM?

DDE stands for Dynamic Data Exchange. That's exactly what it does, and nothing more. It sends data between applications using Windows messages according to a documented protocol. Saying that DDE is old-fashioned and is being replaced by COM is something you see repeated parrot fashion over and over again. DDE and COM do not work in the same way and they solve different problems. Here are some points of difference:

COM is synchronous, one party makes subroutine calls into the other and must wait until the call returns. If the called component is busy the caller is blocked until it becomes free. DDE is asynchronous, a well-programmed client sends a Windows message to the server and carries on processing. Windows holds the message and sends it to the server when the server is ready to process it.

COM is complex to program but powerful. The client can manipulate objects within the server as if they belonged to the client. DDE is straightforward to implement but all it can do is transmit data. It can only control another application because the recipient can treat data as a command.

COM works well when the client creates an instance of a server object or application for its own use. Programming a continuously running server, to which clients can attach when they wish, is possible but tricky. DDE of itself is incapable of creating objects (although OLE1 used it as a transport mechanism). The essence of DDE is that clients attach to an already running server.

Applications using COM almost always need support DLLs such as the VB runtimes or MFC. Programs using DDE can be mean and lean and do not need extra support DLLs.

COM interfaces are tightly specified and contained within the software component. Some documentation is normally built into the interface. The user of a COM component knows exactly which methods are available and how to call them. DDE interfaces are specified only in external documentation.

Because of the tight interface specification, upgrading COM components can be a nightmare. With DDE the server or client can be changed independently.

COM is frequently used to communicate with a DLL in the same process space (called an in-process server). Such as server is often termed an ActiveX control and has the extension OCX. Our DDClient and DDServer Visual Basic components are in-process servers. Using DDE to communicate between components of the same application is possible but has no benefits.

COM communication with a remote machine is called DCOM (Distributed COM). If you make a DCOM call to a remote machine which does not respond, your program (or at least the thread making the call) is stuck. DCOM has a fixed built-in timeout which you cannot change. DDE with a remote machine is called NETDDE. it is used by the Hearts game and Chat which come with Windows. Timeout is controlled by the program.

Under Windows 3.1 and 9x it is possible to crash the system by badly programmed DDE, because the message queue can be filled. NT does not crash in this way, COM does not suffer from the problem at all.

DDE is totally "Bit blind", neither the client nor server can tell whether the other application is 16-bit or 32-bit. Indeed, the server cannot know whether the client is on the same computer or not. Connecting 16 to 32 bit COM components is not usually possible.

It is easy to see from the above points why a DDE server is the most widely used way of providing data obtained from any form of hardware interface. In particular:

The server can run continuously.

It will probably serve a wide range of clients but can be updated without requiring them all to be recompiled.

It is immune from the problems associated with different versions of the system DLLs on different machines.

It can be small and self-contained.

Clients cannot interfere with the running of the server by being slow or busy.

When is DDE more suitable?

When using COM is impossible

Connecting to a running instance of a program which does not register in the Running Object Table (ROT). For example, ActiveX server applications written in Visual Basic do not register themselves in the ROT. (It is possible by a piece of 'Black Belt' programming, described here .)

Connecting to a particular instance of an application Some applications such as Excel do register themselves in the ROT and support multiple instances. However, there is no way to connect to a particular instance of Excel with COM. For example, the GetObject() method in Visual Basic returns a random instance, even when a file name is specified.

With DDE you can manipulate any worksheet without regard to the instance hosting it, because Excel offers a separate topic name for each worksheet. For more information on controlling Excel go to Controlling Excel with DDE.

With some care it is possible to connect to particular instances with DDE, even when the topics supported by each instance are the same. The client must start when at most one of the instances of the server is running. The client must capture the instance handle of each instance as it registers with DDEML, and connect using it. Connections made using a string for the service name, e. g. IExplore, will connect to a random instance.

Writing compact programs, or when the compiler does not make COM easy

The amount of code required to operate a DDE interface is trivial compared to that required for COM. In the DDE Software download area there are sample programs (with full source) which manipulate Microsoft Excel using DDE. The compiled C program is only 17kb, and it does not rely on any external DLLs (apart from the Common Controls which is for the status bar, not DDE). The Visual Basic example uses the Evaluation version of DDClient. so you can modify the project. VB does make COM easy, but if you need to hook up to a running instance of Excel, DDE is the only way you can be certain of connecting to the required worksheet.

When the server is a self standing program which must execute whether or not is has clients

In other words, when the server is the primary application or must have priority on processor time. Hardware monitoring is an example of this situation. The overhead of queuing a message is fixed and the process cannot hang. Quite apart from the complexity of programming COM events, the server must wait for each client to process the data, and its performance therefore depends upon the performance of the clients. If just one of the clients hangs in the COM (or DCOM) event routine the server, or at least one thread, is brought down with it.

A DDE server is the most widely used way of providing data obtained from any form of hardware interface because:

The server can run continuously.

It will probably serve a wide range of clients but can be updated without requiring them all to be recompiled.

It is immune from the problems associated with different versions of the system DLLs on different machines.

It can be small and self-contained.

Clients cannot interfere with the running of the server by being slow or busy.

Networked DDE is suitable when a server is supplying data to a number of clients on different machines. Messages are queued within the client machines and do not affect server performance. NetDDE depends on NetBIOS which can use TCP/IP, so NetDDE works over the Internet.

When the complexity and tight specification of COM, and the requirement to use GUIDs would be a hindrance rather than a help.

An example is the way the Windows shell launches programs, using DDE to pass a filename or command. COM would be gross overkill for this simple task. For more information see the topic How the Windows Shell uses DDE and the File Association Editor page.

For program monitoring

DDE is ideal for allowing one program to monitor another, because neither program ever executes in the context of the other so they cannot interfere with each other. Internet Explorer and Netscape Navigator provide a DDE interface for monitoring the URLs they load. You can see this in action with our Webspy freeware browser spy. It is a good example of an application for which DDE is much more suitable than COM (ActiveX). WebSpy can run without a browser running. WebSpy or the browser(s) can be started first, WebSpy does not interfere with browsing in any way, either program can be terminated at any time without affecting the other. It is written in Visual Basic and uses the DDClient and DDServer components. It can be downloaded from the Software download area

When is COM more suitable?

Whenever the client is the primary application and is in a position to create an instance of an object or application for its own use. The server is dedicated to processing on behalf of the client.

This scenario applies to many office situations, for example a Visual Basic program creating an Excel spreadsheet or Word creating a document which contains images created by another application. Before COM, DDE was used to instruct the server which manipulations to perform and DDE was used to transmit the results back to the client. For this purpose Microsoft have quite rightly extended the COM interfaces and frozen the DDE ones. They have for the most part been left in place for backward compatibility, and to allow the applications to gather data from DDE only servers.

For information on programming Microsoft Office components using COM go to http://www. microsoft. com/officedev/articles/OffObjPr. htm.

COM and DDE data transfer speeds compared

The transfer rates in the first group are estimated ball-park figures for 300MHz machines driven as fast as possible. We accept no responsibility for their accuracy, your mileage may vary widely. They are based on a small number of tests, the tests were not checked to ensure comparing like with like, there were only a small number of measurements. Remember that Windows can queue DDE messages, but COM is synchronous and the caller must wait for the other application to finish processing the call.

Sending data to a client on an advise loop using DDEML - 1000 transactions/sec.

Sending data to a client on an advise loop using our DataSend control - 2000 transactions/sec.

Sending data to a client on an advise loop using raw DDE - 2000 transactions/sec.

Sending data by NetDDE with DDEML - 1300 transactions/sec. (The server and client can process in parallel.)

DDE transactions in Visual Basic using the built-in mechanism 100 - transactions/sec.

Out-of-process COM calls - 2000-3000 transactions/sec.

DCOM calls are slower than out-of-process, similar to NetDDE.

The following numbers are taken from the COM tutorial at DevelopMentor for 100 (lower figure) and 4 (higher figure) bytes of parameters. They are slower than our figures. DevelopMentor say the numbers are fairly old, this probably means that they were measured on a slower machine.

In-process COM calls - 119,240-129,041 transactions/sec.

Out-of-process COM calls - 968-1765 transactions/sec.

DCOM calls (LAN) -- 342-495 transactions/sec.

DCOM calls (WAN) -- 16-19 transactions/sec.

Do not be mislead by figures quoted for in-process COM calls, an in-process server is called in a similar way to a normal DLL. ActiveX which does not involve interprocess communication is much faster, as can be seen from the DevelopMentor table.

Will Microsoft continue to support DDE?

The DDE protocol has not changed since about 1990, indeed it would be disastrous if it did. Microsoft cannot stop supporting DDE, it's just messages passing between windows, which the Operating System relies on. The special bit is allowing applications to pass blocks of data, but that again is something which has to be done anyway so there is no cost in using the mechanism in DDE also.

What Microsoft has done is to stop updating the DDE interfaces of its applications in cases where the job is done better by COM. DDE itself will always be supported, the question is whether Microsoft will continue to support DDE communication with its applications. They will probably never remove the existing DDE interfaces for reasons of backwards compatibility, although changes and degradation have already happened.

What has not changed, and is most unlikely to, is the Shell DDE interface. DDE will continue to be used for launching documents when a file type has an associated application. It's so simple and quick to set up that the registry entries can be done by hand, although Explorer provides an excellent GUI for doing it. Using COM with its attendant GUID mechanism and complicated registry entries would be gross overkill. Similarly, the DDE interface for managing program groups (the start menu in modern parlance) will probably be available for ever.

Other forms of interprocess communication

A list of methods of passing data between programs and which operating systems support them is to be found in Knowledgebase article Q95900 Interprocess Communication Mechanisms.

In additional to COM and DDE they are NetBIOS, Pipes, Sockets, Mailslots, Memory Mapped Files and WM_COPYDATA. Memory Mapped Files and WM_COPYDATA do not operate over a network. Only DDE and COM are mechanisms of the type in which multiple clients can connect to a single server. Named pipes are reported to be amongst the fastest ways of sending data between different computers.

DDE mechanism overview

Making the connection between a DDE server and a DDE client

DDE uses a hierarchy of three names, the SERVICE, the TOPIC and the ITEM. A DDE CONVERSATION is established using the service and topic names as a pair. It is convenient to name the pair a CHANNEL. It is roughly the equivalent of a telephone number. The item part of the name is used to identify the particular data or command being requested by the client once a conversation is established.

To establish a conversation a DDE client specifies the service/topic name pair (channel) it wishes to connect to. Windows broadcasts the request to all top level windows. The first server to accept is connected to the client and so a conversation is established.

The client may leave either the topic or the service name unspecified, or both. This is known as a WILDCONNECT. For example, if the topic name is not specified conversations may be established on all the topics supported by a server. If both are unspecified conversations may be established on all topics with all servers. It is up to the server whether to accept such a connection, and if so on what topics.

Unlike a telephone connection, any number of quite separate conversations may be in progress on the same channel, even between the same two applications. This is often done so that only one item of information or one type of command is handled by each conversation. There is no interaction at all between different conversations using the same pair of service and topic names.

Transactions within a DDE conversation

Just as the client application initiates the establishment of a conversation, it also initiates all the transactions. It can request data from the server as a once off (a REQUEST transaction), request being kept up to date about an item of data (an ADVISE or NOTIFY transaction), give commands to the server (an EXECUTE transaction) and send unsolicited data to the server (a POKE transaction). The client associates with all these transactions the item part of the identification. It informs the server of the data required by the client in a request transaction, the action to be taken by the server in an execute transaction or the data being passed to the server in a poke transaction.

It is also possible to use the item part of the name as the data itself, with the topic name indicating the context in which the data is to be used.

Raw DDE has no timing constraints except the order in which messages are sent. At the Windows message level, there is no distinction between synchronous and asynchronous transactions. Synchronous and asynchronous operation is a feature of the DDE management library. or DDEML.

Network DDE (NetDDE)

DDE across a network is simple to set up. It uses NetBIOS and since this can be run over TCP/IP, NetDDE can use the Internet. Given a fast connection, network DDE is if anything faster than between two programs on one machine, because the server and client can process in parallel. In order to operate DDE over a network the following steps are necessary.

1. On both machines, a DDE agent called NETDDE. EXE must be running, its job is to transmit the data across the network. Under Windows for Workgroups and Windows 9x NETDDE. EXE can be put in the Startup Group or be started manually. Under Windows NT it is a service which is started when required.

2. On the server side only, DDE shares must be created. These bind a service/topic name pair to a share name. For example, the pair WinChat/Chat has the share name Chat$. All the share information is stored in the registry, which has a different format under 3x/9x and NT. You may read that altering the registry by hand is required on Windows 9x, but this is not true.

The Windows API NDde makes the registry entries, it has calls such as NDdeShareAdd(). Application programs can use the API to share their DDE services automatically. The user creates shares manually with the program DDESHARE. EXE, which makes the necessary API calls.

In Windows for Workgroups 3.11 and Windows 9x only a 16-bit API is provided, so DDESHARE for those systems is a 16-bit program. If you do not have this program you can get it from the the DDE download area. The display of the program is not bug free. If it gets confused, which it may after deleting a share, exit and re-run. Under Windows NT only a 32-bit NDde API is available, so the NT version of DDESHARE is a 32-bit program.

The DDE server has no knowledge of the share and does not know if its clients are local or remote.

3. The client program must be changed to use the special service/topic pair \\computer-name\NDDE$/Share-name, for example service "\\RHAMINISYS\NDDE$" and topic "Chat$".

The client and server both hold a DDE conversation with NETDDE. EXE on the local machine. To make a connection, the client NETDDE sends the requested share name to the remote computer. The remote NETDDE agent looks in the registry for the share name. If it exists the permissions are checked. At the server end NETDDE then attempts to connect to the real service and topic names specified in the registry. The server may be started automatically. Once the conversation has been established all DDE transactions are the same as between two programs on the same machine.

When connecting to NT the user may be prompted for the password and the number of sessions is limited. For details go to Windows NT NetDDE security and other issues. See also the article How to get further information

Useful Microsoft Knowledgebase articles

This is not a complete list, you will be able to find more by searching the Microsoft site.

Q110315 NetDDE and RAS Connections Q125703 Windows 95 support for Network DDE. Note that the NetDDE API referred to is the API for programmatically setting up DDE shares. Q231337 Netdde. exe Does Not Relay WM_DDE_TERMINATE to Remote Clients. Microsoft claims this is fixed in SP5. Q128491 Creating a NetDDE Link in Excel on NT

Using the DDEML Application Programming Interface

Many clients and servers use the DDEML Windows API. The same interface is available on all 16 and 32 bit versions of Windows. Raw DDE has to be programmed slightly differently on 16 and 32 bit systems, DDEML hides these differences. Using DDEML guarantees that the correct message protocol is followed, as it hides from the programmer the details of the messages and the fact that windows are created to send and receive them. DDEML based servers and clients make API calls to start transactions. The client may either have the call not return until a reply is received or a timeout has elapsed, or it may resume execution immediately and have a callback routine to process the reply when it arrives.

Raw DDE has no time dependence except the order in which messages must be sent. The DDEML API introduces timeouts, the client can tell DDEML how long it is prepared to wait. In a synchronous transaction, the client waits until the server has responded or the timeout has expired, then processing continues. If the server does not respond within the timeout DDEML reports that the request has failed. Be careful to use only positive numbers as the timeout interval. -1 is the value which signifies an asynchronous transaction, the call returns immediately. Other negative number will be interpreted as large positive numbers.

In asynchronous operation, the client makes its request and processing continues immediately without waiting for a reply. The callback routine is entered when the server responds. The client can have any number of outstanding requests. It is up to the client program to implement any timeout. The program can instruct DDEML to abandon a transaction, in which case the callback will never be entered.

A server using raw DDE can easily delay sending a response to the client. When DDEML is used a reply must be generated and returned as the result of the callback routine. To achieve this a server application can return CBR_BLOCK for a request transaction. DDEML disables the server's callback function and also queues transactions that are sent by DDEML after its callback has been disabled. This feature gives the server an opportunity to gather data while allowing other applications to run in the system. When the server is ready it unblocks the callback and DDDEML makes the same request again.

You may find other documentation which states that only the affected conversation is blocked, however our testing shows that it is indeed the callback which is disabled. It is much better to refuse the request altogether, or to send back a special piece of data such as "N/A", which indicates to the client that the real data is not available yet.

DDEML requires a server application to register the service names that it supports. The names are broadcast to other applications which are using DDEML, which can then use the names to connect to the server. As well as the plain service name, DDEML provides an instance specific service handle. In other words, if two instances of the same application are started, a DDEML client can distinguish between them when establishing conversations.

There is a speed penalty of about 2 for using DDEML, when both server and client are doing almost nothing else. In the real world they both have to do other processing, so the speed penalty is far outweighed by the benefits

For 16-bit applications the API is implemented in a dynamic linked library called DDEML. DLL (DDE management library). The 32-bit API is implemented in User32.dll, an integral part of the Windows operating system. A discussion of the consequences can be found in the topics Why does my program run differently on Windows 9x and NT? and What are the 16/32-bit and Windows version issues?.

Microsoft Knowledgebase articles

Q108933 Top 10 DDEML support issues Q170626 Memory Leak in Global Shared Memory.

A memory leak using DDEML

There seems to be a problem with the HDATA_APPOWNED attribute of memory allocated by DdeCreateDataHandle. DDStudio at one time kept data in a block with this attribute, ready to send to any client that asked for it. Each time the data changed the old block was freed and a new one allocated.

The result was a rapid usage of memory, far in excess of the memory actually allocated by the calls to DdeCreateDataHandle. Hours of examining the code revealed no errors. The problem was solved by using GlobalAlloc instead, and creating a new system owned data handle with DdeCreateDataHandle for each request.

A Microsoft Knowledgebase article

Q170626 Memory Leak in Global Shared Memory. This problem is not confined to NT in our experience. It is best not to use the APPOWNED flag when creating DDEML data objects.

Why do I get the DDEML Reentrancy error?

The DDEML library is not designed to allow reentrancy of the callback routine. In other words, it must return before DDEML calls it again. It will be reentered if you yield to Windows and there is a DDE message for you on the queue.

It is therefore an absolute rule in programming your callback routine, do not yield to Windows.

Why does DDE sometimes change the case of the Service, Topic and Item names?

The Service, Topic and Item names in DDE are case insensitive because Global String Atoms are used, not the strings you type. It is not possible for a program to force the case and a bad bug to require one.

For all DDE names, the program gets a string handle to represent the string. The system does a lookup to see if the string has been allocated an Atom already. If so, it returns the existing value. Whoever requested the string Atom first determines the case. It follows that if you request a string handle for a string, then request the string corresponding to the handle, you will get back the string with an essentially random case.

If you are having problems with a program which demands a particular case, you may be able to resolve the situation by rebooting the machine. This clears out the global atom table. Then do some DDE using the correct case, which should stick until the last user frees their reference to the string.

Service, Topic and Item names: number and length limits

Because the Service, Topic and Item names are represented by String Atoms, they are subject to the same limits as String Atoms themselves. The maximum length of strings is 255 characters and the case of letters is immaterial, as discussed above.

If you look at VC help files or MSDN on CDROM you will probably read the alarming fact that an Atom Table has a maximum of 37 entries. This is incorrect and has been remedied in the web version of MSDN, it is the number of buckets in the hash table. The maximinum number of different strings it can hold is 16384.

Why does my Execute command data get corrupted?

DDEML automatically translates execute strings. DDEML bases its translation decision on how DDEML was called, either by DdeInitiateA or DdeInitiateW when the application initialised DDEML. The way to avoid this problem is to use a Poke command instead of an Execute command to send data to a DDE server.

Using DDEML in an MFC project

Calling the DDEML library directly from within an MFC project

The sample DDE client project you can download here was written as a learning exercise. The original is 16-bit, but it compiles and runs under 32-bit as well (although the 32-bit version GPFs on exit). It is made available solely as a sample, absolutely without warranty, for your education. You can do anything with it you wish, but please don't ask us to spend any more time on it!

To download the sample program go to the DDE download area.

MFC DDE class libraries for C++

An MFC class including source code is available for download at http://www. flashcast. com/dde32

MSDN also has a project which wraps up DDEML in a class module. The project can be downloaded from http://msdn. microsoft. com/library/techart/msdn_ddeplus. htm

The missing data and unreliability problems

There are several ways in which DDE can fail to work properly.

The server or client is not following the correct protocol.

Failure to handle errors when using synchronous transactions.

Using the fAckReq flag when establishing hot and warm links.

The receiver does not get the messages sent to it.

Failure to understand the limitations of Visual Basic DDE.

The server or client is not following the correct protocol

Because DDE is only a documented protocol for regular Windows messages, it cannot be policed by Windows. If both a server and client written as a pair disobey the protocol, they may work together all the same, but fail when used with a component which is programmed correctly. For example

A server which asks for the receipt of messages to be acknowledged may continue to send data regardless of whether the acknowledgement has been sent.

The client or server may ignore the clipboard format sent or requested.

Messages may be sent out of sequence, such as data being sent on an advise loop before the advise request is acknowledged.

Failure to handle errors when using synchronous transactions

DDE is an asynchronous process, but is made to appear synchronous when the message sender chooses to suspend execution whilst waiting for a reply. If the timeout period specified is not long enough, the transaction will appear to have failed. Further problems may arise when the message from the server finally arrives. A much better way is to work asynchronously, a callback routine is entered when the partner application replies.

Using the fAckReq flag when establishing hot and warm links

The receiver does not get the messages sent to it

This happens if the message queue fills up under Windows 3.1 and 9x. If the client does not keep up with the server the message queue will eventually fill up. Messages are then lost because PostMessage fails. The only answer is to stop the server manually when (and if) prompted by Windows. The user interfaces will probably not respond. If the server continues attempting to post messages the system is likely to crash. The fAckReq flag was introduced to address this problem.

Under Windows NT it does not happen, the queue continues to grow. If the client catches up, the queue starts reducing again. If not, the task scheduling is changed to reduce it. The user interfaces will probably continue to respond, although Task Manager may report that the application is not responding. We have found Windows NT to be bullet-proof, you can safely choose not to use the fAckReq flag.

Failure to understand the limitations of Visual Basic DDE

This subject has its own section, please go to DDE and COM in Visual Basic

How can I improve the performance of my DDEML client?

In summary, by reducing the number of Windows DDE messages to the minimum and processing them as soon as possible.

First and foremost, if you are using synchronous calls, rewrite the client to use asynchronous transactions. When you make a synchronous request, the client process stops until either a response arrives, or the timeout expires. You will get much better performance if the client is completely callback driven.

In outline, before making a request for a piece of data, advise loop etc. see if there is already an outstanding request for it. If so, do not make another request but wait for the first request to be answered. You could cancel the transaction and start another, but that will double the number of Windows messages. If you need multiple items of data and use synchronous requests, each must wait for the previous one to succeed or time out. If you use asynchronous requests you can ask for them all at once, Windows will keep the messages in the queue and send them to the server when it is free. As each data item arrives your callback routine is invoked. The data can come in any order depending on the server, your client must be programmed to allow for this.

Secondly, use Advise loops instead of Request loops. A Request loop uses 3 Windows messages when the data changes (Notify, Request, Data), instead of only 1 with an Advise loop (Data).

Applications hanging because of DDE

There are two ways in which attempting to establish a DDE conversation can cause applications to stop responding.

A top level window does not have a message loop

This only happens in 32-bit Windows, and only DDE clients are affected. To make a connection, an application broadcasts a message to all top level windows. If the window is not on the same thread, the message is actually posted to the recipients queue and the caller is blocked. If the recipient has no message queue the calling thread is permanently blocked. Microsoft has acknowledged that this is a bug. Further details are in the Knowledgebase article Q136218 BUG: DdeConnect Never Returns.

Messages are lost because the wrong server accepts a connection

If a DDE server wrongly accepts a connection which ought to be accepted by another application it has a doubly bad effect. The client will probably lock up because the conversation is with the wrong non-responding server and the correct server never gets the connection. The rouge server will cause a problem or not apparently at random, because the order in which the windows receive the WM_DDE_INITIATE message is indeterminate. Any activity which depends upon DDE could be affected.

It is reported that Outlook causes problems with other applications trying to use DDE. We don't use Outlook ourselves, so we have not been able to test whether the cause is either of those mentioned here. Please e-mail ddefaq@rhaminisys. com if you know the answer.

Causes of slow DDE communication

In some quarters DDE has a reputation for being slow. This can be true if it is not programmed properly. Apart from general inefficiency of coding, the following are specific causes of slowness:

Establishing a connection between the server and the client may be time consuming. Windows broadcasts a message to all top level windows, a connection is made when a server responds. A system which continually breaks and re-makes connections is going to be slow. Watch out for frequent calls of DDeInitiate in VBA, for example.

Treating DDE transactions as synchronous, with the client waiting for the server to respond before proceeding. This is poor practice, DDE is especially suitable for cases in which the server may take a long time to acquire the requested data. Visual Basic uses synchronous operations for requests.

The speed of properly programmed DDE is similar to that of COM. For more details see COM and DDE data transfer speeds compared.

What are the 16/32-bit and Windows version issues?

As far as server and client applications are concerned, DDE is completely "bit blind". Neither can tell whether the other partner is 16-bit or 32-bit. There is however an effect on performance, DDE monitoring and the effect of programming errors.

Windows NT can handle a long message queue, other versions cannot

The Windows operating system will queue DDE messages if the server is delivering data faster than the client can use it. There is a discussion in the topic The missing data and unreliability problems.

Under Windows 3x and 9x 16-bit programs share the same address space and cooperate.

Usually, if both server and client are 16-bit the message queue does not grow indefinitely, because the operating system allows each to run in turn. Having a server which can deliver data faster than the client can use it is less likely to be a problem than with 32-bit programs.

32-bit programs are truly multi-tasking

A 32-bit server which puts messages on the queue faster than the clients can process them causes the queue to grow. Windows 9x runs out of resources and the server has to be shut down or Windows crashes (it may crash anyway). NT is completely stable, it is intelligent enough to give the client more of the processor time, allowing it to keep up with the server.

Whilst the queue is filling, the user interface of Windows 9x is usually unresponsive, in contrast to Windows NT which allows user input to be processed.

The 32-bit DDEML library is thread specific

The call to DdeInitialise and all subsequent DDEML API calls must be made in the same thread. The callback routine runs on the same thread. If you want more than one thread to use DDE, then each thread must have its own instance of the library, created by calling DdeInitialise with the pointer to the instance handle pointing at a zero hInstance.

DDE is asynchronous by nature, there is no need to use threads to allow a main thread to proceed whilst DDE operations are being carried out. The answer is to call DdeClientTransaction with a timeout of TIMEOUT_ASYNC, such calls return immediately.

Windows 9x and 3x use the 16-bit DDEML library, Windows NT has a native 32-bit implementation in User32.dll.

One result of this is that programming faults have different effects, for details see Why does my program run differently on Windows 9x and NT?.

Under Windows 9x 32-bit DDE using DDEML is slightly slower because of thunking down to 16 bits. Under Windows NT DDE between 16-bit programs is markedly slower than between 32-bit programs, in round figures about 2/3 of the speed (caution: your mileage may vary widely).

Applications which monitor DDE activity

The location of the DDEML API is important to DDE monitoring applications. DDEspy from Microsoft and our Dynamic Data Studio use the DDEML APPCLASS_MONITOR facility. Message hooks can read the memory handles of the data attached to a WM_DDE_xxx message, but for 32-bit applications the handles have no meaning in other process spaces. The 32-bit version of the DDEML API extracts and passes some data to a monitoring application, but only the first 28 bytes. There is no way to obtain more than this. Monitoring under Windows 9x 32-bit programs thunk down to 16-bit DDEML. DLL from User32.dll. As a consequence, all DDE transactions to and from 16 and 32-bit programs can be monitored by a 16-bit application. A 32-bit application cannot monitor anything.

Monitoring under Windows NT 4 16-bit programs call 16-bit DDEML. DLL and the Windows messages go to and from 32-bit programs via WOWEXEC. A 16-bit monitoring application uses 16-bit DDEML. DLL and can monitor only messages to and from 16-bit programs. A 32-bit application uses the native User32.dll interface and monitors messages to and from 32-bit applications.

Monitoring under Windows 2000 (NT 5) Unlike NT 4, a 32-bit monitor sees DDE messages going to and from 16-bit and 32-bit applications, although it only sees 32-bit DDEML activity. A 16-bit monitoring application can monitor only messages to and from 16-bit programs, as under NT 4.

Why does my program run differently on Windows 9x and NT?

The differences are due to the fact that Windows 9x uses the 16-bit DDEML library, whereas Windows NT has a native 32-bit implementation in User32.dll. Applications programmed exactly as specified in the documentation work the same way on both systems. If you do not control the source code and compilation, no remedy is available for the problems.

Some transactions do not complete on Windows NT

There is a sign extension 'feature' in both VB5 and VB6 (and probably other compilers). The constant &H8000 is compiled as &HFFFF8000. In VB it is not possible to write &H00008000, the leading zeros are removed. Some of the constants used in the DDEML API have the &H8000 bit set. Under Windows 9x User32.dll thunks down to 16-bit DDEML, which truncates the operation codes to 16 bits. But under Windows NT the DDEML API is native 32-bit code in User32.dll, and it does not remove the top 16 bits.

In Visual Basic there is a simple work-around, write the constant in decimal, for example write &H8000 as 32768. Writing &H8000& should also work. You cannot overcome this problem by making a 16-bit integer constant, such as Public Const Foo As Integer = &H8000 because sign propagation on expansion to 32-bits happens also at run time.

The transmitted data (in either direction) is different

When you allocate a block of memory for DDE transfer it allocates a rounded size of block with padding at the end, and all of it is transmitted. Therefore, you must know how long your data is. Windows 9x and Windows NT appear to use a different granularity.

A client receives data under NT but not Windows 9x

If the server sends back data with a different clipboard format to the one asked for, DDEML. DLL (Win 9x) knows that the server has not sent what it was asked for and does not invoke the user's callback. It seems that user32.dll does not care and the callback is invoked.

Non-string data with Execute commands may not be passed correctly.

DDE works on the assumption that execute commands are strings. You may have difficulty and find differences between NT and 9x in passing data in other formats. In particular, NT may truncate data which has a zero second byte.

Windows NT NetDDE security and other issues

The comments here apply to Windows 2000, there are additional considerations discussed in Windows 2000 NetDDE issues.

Net DDE shares must be marked "trusted" by an administrator

Under NT DDE shares must be "trusted" for a remote client to connect. This is managed by DDESHARE. EXE. However, only an administrator for the logged on workgroup or domain can trust a share. It is no good being an administrator for another domain. Confusingly, the dialog can be completed by a normal user and the share appears to have been trusted, but remote clients cannot connect.

The client must give a password when connecting to a remote NT server

NT security gives password protection for access to remote machines. There is a bug in Windows NT, a password is always required when a client connects, even if one should not be required. The password is obtained from a dialog box. The client appears to connect immediately, because the DDE conversation is with Netdde. exe on the local machine. We have not found a workaround for this, the only hope appears to be programmatic completion of the dialog.

The number of NetDDE sessions allowed under Windows NT may be limited

By default, NETDDE applications are limited to 16 nodes. When the application attempts the 17th connection, it will fail and post an error to the event log. To fix this problem find the registry key

Edit or Add a REG_DWORD value named MaxSessions. Set it to a data value between 0 and 254 (decimal). If this value is missing or set to zero, the default of 16 is used.

Microsoft Knowledgebase articles

Q114089 Using Windows NT NetDDE Share Manager Q140551 NetDDE Requires Username/Password When Connecting to WinNT Q105195 NetLogon Service Necessary for NetDDE Connections in a Domain Q142625 NETBIOS Defaults to 16 Sessions on Windows NT Q164882 Practical Recommendations for Securing Internet-Connected Windows NT Systems Q172450 NetDDE Connections Fail When "Logon to" Restrictions Apply

Windows 2000 issues

All the comments in Windows NT NetDDE security and other issues apply, and there are additional considerations.

NetDDE and Windows 2000

On a new Windows 2000 installation, NetDDE is disabled for all users. A client trying to connect gets a dialog box showing Incorrect Password no matter what is entered. You do not have the right to establish a NetDDE session because the account on the server has not allowed "Access This Computer from the Network" rights. To resolve the problem, prepare your mouse fingers for action and go to Settings/Control Panel/Administrative Tools/Local Security Policy/Local Policies/User rights assignment /Right click "Access this computer from the network"/Security. Then make sure the relevant user, domain or group is enabled. See these articles:

Default Access Control Settings in Windows 2000 Q256575 ClipBook Viewer Prompts for Network Access Password Q257346 "Access This Computer from the Network" User Right Causes Tools Not to Work

Bugs in Windows 2000 DDE

Connecting to an instance specific service does not work, an internal system error is reported. If more than one instance of an application is running you cannot connect to a specific one, unless the server application itself distinguishes between instances on the basis of the topics supported. For example, Excel supports topics based on the workbook and sheet name.

There is a bug which may prevent a NetDDE connection from working. Details are in the Knowledgebase article Q272485 NetDDE Client Is Unable to Connect to NetDDE Server on First Attempt. Microsoft claim that this bug is fixed in Service Pack 2.

The article Q181946 HOWTO: Create a NetDDE Client and Server in Visual Basic, contains a workaround for a bug in DDESHARE. When you trust the share, you must select "Initiate to Application Enable" and click the "Set" button before clicking OK on the two dialogs.

It is necessary to set the DSDM service to Manual start. The NetDDE service may be Automatic or Manual, it starts DSDM itself. It was suggested by Microsoft to a reader of this page that allowing DSDM to start automatically can cause NetDDE not to work, and we have confirmed this.

DDE in NT Services

DDE needs a message pump for it to work. However, by default NT services don't seem to have one. Fortunately, the remedy is simple. When you install the service, you have to allow interaction with the desktop, even though it's not going to. The remarks in the following section concerning VB may apply to services written in any language.

Desktop interacting Services written in Visual Basic

Starting the service manually when a user is logged on is without problems. However, if the service is started automatically and it loads a form containing visible controls, it crashes with the system error 800706B5 (RPC unknown interface). The form does not have to be shown for the error to occur, loading it is enough. So, if you have a form for debugging or when the program is running as a regular application, do not load it when running as a service. Invisible controls such as our DDClient should be put on a separate form which is loaded but not made visible.

There is a further problem when a user attempts to log off. It is known to occur in Services using our DDClient control on an invisible form. We have not been able to circumvent it by using CreateObject() on the control instead. Windows attempts to unload the form containing the control. If the form is allowed to unload, the Control is removed. DDE stops and does not start again when a user logs on. If the Service prevents the form unloading in the QueryUnload event the user cannot log off.

The reason for putting DDE into a service in the first place is probably to allow automatic startup when the machine is switched on. It may not be a hardship to prevent the first user from logging off in these circumstances.

If you use DDEML, the default security arrangement is that the server is allowed to impersonate the client for DDE. For example, if you have a client running in the LocalService account, the server can run in any account.

Please e-mail ddefaq@rhaminisys. com if you know what the security situation is with raw DDE, or have any further insights into this topic.

Working with Unicode

This information is copied from MSDN. Note the implication the Execute transaction expects data to be a string. Attempting to pass data in other formats can cause problems.

"Applications that register a DDE window class that is Unicode must Unicode execute strings when communicating with other Unicode DDE windows. They must ASCII (OEM codepage) execute strings when communicating with non-Unicode DDE windows. Any window's state can be determined by calling IsWindowUnicode. This convention places burden of backward compatibility on Unicode DDE applications."

"Unicode compatibility is only a problem for raw DDE applications because DDEML automatically translates execute strings. DDEML bases its translation decision on how DDEML was called either by DdeInitiateA or DdeInitiateW when application first initialised conversation."

The "following System files have been replaced. " error message

If you get the "following System files have been replaced. " error message for DDEML. DLL every time you boot machine, answer is to delete DDEML. DLL related entry from Registry at

How to get further information

The primary sources of information are MSDN (Microsoft Developers Network) library and Microsoft Knowledgebase. Both are available on MSDN CDROMs and free on Internet.

Raw DDE using WM_DDE_xxx messages

Windows development/Windows Base Services/Interprocess communication/SDK Documentation/Interprocess communications/Dynamic Data Exchange

Windows development/Windows Base Services/Interprocess communication/SDK Documentation/Interprocess communications/Dynamic Data Exchange Management Library

Windows development/Windows Base Services/Interprocess communication/SDK Documentation/Interprocess communications/Network Dynamic Data Exchange

Shell DDE interface

User Interface Design and Development/Windows Shell/SDK Documentation/Shell Programmers Guide/Shell Legacy Information/Shell Dynamic Data Exchange interface

Technical articles with sample code

Windows development/Windows Base Services/Dynamic Data Exchange/Technical Articles

Knowledgebase articles have an identifier like Q123456. You can obtain them on Internet in two ways -

1. Send an e-mail to mshelp@microsoft. com . with identifier as subject. You can also a space separated list of identifiers. Body text is ignored. To get an index of available articles subject is index .

2. View the article in your web browser. There is a generic form of URL http://support. microsoft. com/support/kb/articles/q123/4/56.asp If article number has only 5 digits, last part of URL is like /q12/3/45.asp .

There is also a good deal of information in help files that come with Microsoft's C/C++ compilers, especially API details.

Newsgroups are another good source of information.

FX al por menor

Al utilizar este sitio web, se considera que ha leído y aceptado los siguientes términos y condiciones:

La siguiente terminología se aplica a estos Términos y condiciones, Declaración de privacidad y Aviso de responsabilidad y cualquiera o todos los acuerdos: "Cliente", "Usted" y "Su" se refiere a usted, la persona que accede a este sitio web y acepta los términos y condiciones de la Compañía. "La Compañía", "Nosotros mismos", "Nosotros" y "Nosotros", se refiere a nuestra Compañía. "Parte", "Partes" o "Nosotros", se refiere tanto al Cliente como a nosotros mismos, o bien al Cliente oa nosotros mismos. Todos los términos se refieren a la oferta, aceptación y consideración del pago necesario para llevar a cabo el proceso de nuestra asistencia al Cliente de la manera más apropiada, ya sea mediante reuniones formales de duración fija o cualquier otro medio con el propósito expreso de Las necesidades del cliente con respecto a la provisión de los servicios / productos declarados de la Compañía, de acuerdo con y sujeto a la Ley Inglesa vigente. Cualquier uso de la terminología anterior u otras palabras en singular, plural, mayúsculas y / o he / she o ellos, se toman como intercambiables y por lo tanto como referente a la misma.

Estamos comprometidos a proteger su privacidad. Los empleados autorizados dentro de la empresa sobre una base de necesidad de conocer sólo utilizan cualquier información recopilada de clientes individuales. Revisamos constantemente nuestros sistemas y datos para garantizar el mejor servicio posible a nuestros clientes. El Parlamento ha creado delitos específicos para acciones no autorizadas contra sistemas informáticos y datos. Investigaremos tales acciones con el fin de enjuiciar y / o emprender acciones civiles para recuperar daños y perjuicios contra los responsables.

Estamos registrados bajo la Ley de Protección de Datos de 1998 y como tal, cualquier información relativa al Cliente y sus respectivos Registros de Clientes pueden ser pasados a terceros. Sin embargo, los registros de clientes se consideran confidenciales y por lo tanto no se divulgarán a terceros, a excepción de Magnates de Finanzas. Si es legalmente obligado a hacerlo ante las autoridades competentes.

No venderemos, compartiremos ni alquilaremos su información personal a terceros ni utilizaremos su dirección de correo electrónico para recibir correo no solicitado. Cualquier correo electrónico enviado por esta Compañía sólo estará relacionado con la provisión de servicios y productos acordados. Renuncia

Exclusiones y limitaciones La información en este sitio web se proporciona "tal cual". En la medida de lo permitido por la ley, esta Compañía: excluye todas las representaciones y garantías relacionadas con este sitio web y su contenido o que son o pueden ser proporcionados por cualquier afiliado o cualquier otro tercero, incluyendo en relación con cualquier inexactitud u omisiones en este sitio web Y / o la literatura de la Compañía; Y excluye toda responsabilidad por daños y perjuicios derivados de o relacionados con el uso de este sitio web. Esto incluye, sin limitación, la pérdida directa, pérdida de negocios o ganancias (ya sea que la pérdida de tales beneficios era previsible, surgió en el curso normal de las cosas o usted ha avisado a esta Compañía de la posibilidad de dicha pérdida potencial) A su computadora, software, sistemas y programas y los datos sobre el mismo o cualquier otro daño directo o indirecto, consecuente e incidental. Sin embargo, Magnates no excluye responsabilidad por muerte o lesiones personales causadas por su negligencia. Las exclusiones y limitaciones anteriores se aplican únicamente en la medida permitida por la ley. Ninguno de sus derechos estatutarios como consumidor está afectado.

Utilizamos direcciones IP para analizar tendencias, administrar el sitio, rastrear el movimiento del usuario y recopilar información demográfica amplia para uso agregado. Las direcciones IP no están vinculadas a información de identificación personal. Además, para la administración de sistemas, detección de patrones de uso y resolución de problemas, nuestros servidores web registran automáticamente la información de acceso estándar, incluyendo el tipo de navegador, tiempos de acceso / correo abierto, URL solicitada y URL de referencia. Esta información no se comparte con terceros y se utiliza sólo dentro de esta empresa en una base de necesidad de saber. Cualquier información individualmente identificable relacionada con estos datos nunca será usada de ninguna manera diferente a la indicada arriba sin su permiso explícito.

Al igual que la mayoría de los sitios web interactivos, el sitio web de esta empresa [o ISP] utiliza cookies para permitirnos recuperar los detalles del usuario para cada visita. Las cookies se utilizan en algunas áreas de nuestro sitio para permitir la funcionalidad de esta área y la facilidad de uso para aquellas personas que visitan.

Enlaces a este sitio web

No puede crear un enlace a ninguna página de este sitio web sin nuestro previo consentimiento por escrito. Si crea un enlace a una página de este sitio web, lo hace bajo su propio riesgo y las exclusiones y limitaciones establecidas anteriormente se aplicarán a su uso de este sitio web enlazándolo.

Enlaces desde este sitio web

No supervisamos ni revisamos el contenido de los sitios web de otras partes que están vinculados desde este sitio web. Las opiniones expresadas o material que aparecen en dichos sitios web no son necesariamente compartidos o endosados por nosotros y no deben ser considerados como el editor de tales opiniones o material. Tenga en cuenta que no somos responsables de las prácticas de privacidad ni del contenido de estos sitios. Animamos a nuestros usuarios a ser conscientes cuando salen de nuestro sitio & amp; Para leer las declaraciones de privacidad de estos sitios. Debe evaluar la seguridad y confiabilidad de cualquier otro sitio conectado a este sitio o acceder a través de este sitio usted mismo, antes de revelar cualquier información personal a ellos. Esta Compañía no aceptará ninguna responsabilidad por cualquier pérdida o daño de cualquier manera, sea cual fuere su causa, que resulte de su divulgación a terceros de información personal.

Los derechos de autor y otros derechos de propiedad intelectual pertinentes existen en todo el texto relacionado con los servicios de la Compañía y el contenido completo de este sitio web.

Todos los derechos reservados. Todos los materiales contenidos en este sitio están protegidos por la ley de derechos de autor de Estados Unidos y no pueden ser reproducidos, distribuidos, transmitidos, exhibidos, publicados o transmitidos sin el permiso previo por escrito de Finanzas Magnates. Usted no puede alterar o eliminar cualquier marca registrada, copyright u otro aviso de copias del contenido. Toda información en esta página esta sujeta a cambio. El uso de este sitio web constituye la aceptación de nuestro acuerdo de usuario. Por favor, lea nuestra política de privacidad y descargo de responsabilidad legal. El comercio de divisas en el margen conlleva un alto nivel de riesgo y puede no ser adecuado para todos los inversores. El alto grado de apalancamiento puede trabajar contra usted, así como para usted. Antes de decidir el comercio de divisas debe considerar cuidadosamente sus objetivos de inversión, el nivel de experiencia y el apetito de riesgo. Existe la posibilidad de que usted podría sostener una pérdida de parte o la totalidad de su inversión inicial y por lo tanto no debe invertir dinero que no puede permitirse perder. Usted debe ser consciente de todos los riesgos asociados con el comercio de divisas y buscar asesoramiento de un asesor financiero independiente si tiene alguna duda. Las opiniones expresadas en los Magnates de Finanzas son las de los autores individuales y no representan necesariamente la opinión de la empresa o de su dirección. Finanzas Magnates no ha verificado la exactitud o base-de-hecho de cualquier reclamación o declaración hecha por cualquier autor independiente: errores y omisiones pueden ocurrir. Cualquier opinión, noticia, investigación, análisis, precios u otra información contenida en este sitio web, por parte de Finanzas Magnates, sus empleados, socios o contribuyentes, se proporciona como comentario general del mercado y no constituye asesoramiento de inversión. Finanzas Magnates no aceptará ninguna responsabilidad por cualquier pérdida o daño, incluyendo, sin limitación, cualquier pérdida de beneficio, que pueda surgir directa o indirectamente del uso o dependencia de dicha información.

Ninguna de las partes será responsable frente a la otra por cualquier incumplimiento de cualquier obligación bajo cualquier Acuerdo que se deba a un evento fuera del control de dicha parte, incluyendo pero no limitado a cualquier acto de Dios, terrorismo, guerra, insurgencia política, insurrección, disturbios , Disturbios civiles, actos de autoridad civil o militar, levantamiento, terremoto, inundación o cualquier otra eventualidad natural o causada por el hombre fuera de nuestro control, lo que causa la terminación de un acuerdo o contrato celebrado, ni que podría haber sido razonablemente previsto. Cualquier Parte afectada por tal evento deberá informar inmediatamente a la otra Parte de la misma y deberá usar todos los esfuerzos razonables para cumplir con los términos y condiciones de cualquier Acuerdo contenido aquí.

El incumplimiento de cualquiera de las Partes en exigir el estricto cumplimiento de cualquier disposición de este o de cualquier Acuerdo, o el incumplimiento por parte de cualquiera de las Partes de cualquier derecho o recurso que le corresponda, no constituirá una renuncia del mismo y no causará una Disminución de las obligaciones bajo este o cualquier Acuerdo. Ninguna renuncia a ninguna de las disposiciones de este o de cualquier Acuerdo será efectiva a menos que se exprese expresamente que sea tal y firmado por ambas Partes.

Notificación de cambios

La Compañía se reserva el derecho de cambiar estas condiciones de tiempo en tiempo como le parezca conveniente y su uso continuado del sitio significará su aceptación de cualquier ajuste a estos términos. Si hay cambios en nuestra política de privacidad, anunciaremos que estos cambios se han realizado en nuestra página principal y en otras páginas clave de nuestro sitio. Si hay algún cambio en la forma en que utilizamos la información personalmente identificable de nuestros clientes del sitio, se hará una notificación por correo electrónico o correo postal a los afectados por este cambio. Cualquier cambio en nuestra política de privacidad se publicará en nuestro sitio web 30 días antes de que se produzcan estos cambios. Por lo tanto, se recomienda que vuelva a leer esta declaración de forma regular.

Estos términos y condiciones forman parte del Acuerdo entre el Cliente y nosotros mismos. El acceso a este sitio web y / oa la empresa de una reserva o Acuerdo indica su comprensión, acuerdo y aceptación de la Notificación de Negación y los Términos y Condiciones completos contenidos en este documento. Sus derechos legales a los consumidores no se ven afectados.

Review of Thomson Reuter's New Platform for Retail Traders – MetaStock XENITH

Ron Finberg / Analysis (Retail FX) Friday, 09.11.2012 / 13:31 / GMT

(Update Nov 28 – after the publishing of this post on Nov 9, Eikon for Retail Traders was renamed MetaStock XENITH. The post below reflects the product with its original name and branding)

After years of being targeted towards professional traders, Thomson Reuters announced recently that it has begun to offer its Eikon platform for retail traders. For a platform aimed at the retail segment it is very robust and includes real-time news, fundamentals, economic reporting, and analytics. The charting package is based on the MetaStock system, a staple of Thomson Reuters financial platforms. They have also created apps for users to connect to their workplaces from mobile apps.

Currently, Thomson Reuters is working on creating partnerships with retail brokers to promote the platform to their clients with the referring firm receiving a portion of the monthly subscription charge. On its part, Thomson Reuters will market its partnering brokers and financial firms on its email and webinar series campaigns about the new retail platform.

Costs begin at $99/month for the basic package which includes FX pricing. Adding more data requires additional subscriptions that are purchased from the desired exchanges. However, as the platform is being sold only to non-professionals, users of the Eikon Retail edition are charged much tinier rates from exchanges than a normal professional subscription. Overall, at $99/month, the platform isn’t aimed at your typical small sized FX clients, but at the larger semi-pro traders who are searching for an edge in the market, above what the widely available free systems provide.

Platform Review Having worked with several different versions of Thomson Reuters products in the past, I was eager to take it for a test drive and see where it stands.

The first thing one needs to know is that this isn’t a trading platform. It is simply a cross market analytics product. Therefore, although traders can use the system to scan the markets and find opportunities, a separate trading platform for executing trades is needed. According to Derek McKusick, Business Development at Thomson Reuters, integrating trading capabilities via their partnering brokers is an area they are working on, but they have no definitive plans.

Onto the review… If I had to use an adjective to describe the platform, ‘robust’ comes to mind. This is first seen when downloading the software, as it is a heavy system and isn’t like the 123 installations of your typical MT4 or comparable trading platforms. Eikon comes packed with numerous pre-existing templates and cross asset workpages. For Excel junkies, the platform also has preset integration to perform real time spreadsheet analysis. This all leads to a rather long installation process.

When it is finally ready to go, new users will experience a learning curve using the product as it is very wide encompassing. For previous Thomson Reuters users of platforms like the Eikon Proffssional and 3000 XTRA products, the layouts will be very familiar. Like those other products, Eikon for retail evolves around creating tabs (also called Flex pages) and workspaces. Users can customize each of their tabs for specific assets or information such as real time streaming news, economic events, pricing, and charts.

As mentioned before, for a retail offering, the platform was very robust in its features. Specifically, the news and research sections were similar to what is offered in the $1000+/month products.

Creating a news stream for specific currencies, general forex news, or filtered for a country or region was similar to the pro-versions. Also, like the more expensive versions, the economic news calendar updates in real time without the need of refreshing the screen. In addition, the platform contains many pre-existing news queries for users to watch.

The charting package from MetaStock is also fully packed with all the usual indicators as well as the very useful ‘correlation’ feature for measuring beta of various currencies over different time frames. The charts also allow for customizing time data and aren’t limited to the usual 1, 5, 15, 30 minute etc time frames.

One area though where the platform does fall short, at least for currencies is the real time pricing. First of all, quotes are based on a free feed that Thomson Reuters has with some participating banks. As such, these appear to be indicative rates with rather wide spreads compared to what broker’s are offering (for example, the EURUSD and GBPUSD are typically at 3 and 4 pips respectively). Therefore, using the system for tick by tick tape reading is ineffective. Another issue I noticed was slight delays of price changes during active periods of trading. For chart reading, the spreads and slight latency isn’t much of an issue, but Forex traders will be best off basing their actual executions off of their broker’s spreads. (The Eikon platform I reviewed was limited to real time data for FX only. Therefore, I am not sure if users of exchange traded data will experience the same issues in regards to their real time data.)

Overall, where the system really excels is with its news and research abilities. For serious traders that want up to second headlines of what is occurring in the market and breaking news, this platform offers a similar look to what the professionals are using. (Example: I saw the headlines for Disney buying the Star Wars franchise on the platform before seeing headlines on mainstream news sources. For equity traders, filtering for halted stocks and those poised to gap on the open is easily done ) Also, while there are cheaper alternatives to MetaStock’s charting capabilities, the Eikon retail edition isn’t lacking in functions.

So is it worth $100/month? That really depends on what a trader is using it for. Experienced traders that have traded professionally in the past and are now working with retail brokers will find this Eikon product to deliver similar features that they were accustomed to in their previous professional environment. Also, for traders seeking for more information versus what the free retail offerings provide, this platform will easily fit their needs. While perhaps not a larger segment, demand for paid analysis and news products is growing steadily as the forex trading industry matures (In our 3rd quarter report. we wrote about Ninja Trader which is a paid platform that is being requested by more and more traders). Forex research sites will also find the platform useful as it will allow writers to gain access to real time financial news for a relatively cheap price. As such, while the price of the Eikon retail edition may deter the vast majority of retail forex clients from purchasing it, the sheer size of the platforms abilities will create interest for the product.

Excel Financial Data Add-In

Ever since Microsoft (MSFT) added the ability to import external data using a web query to Excel . I have been interested in importing financial data into my spreadsheets. I am always looking for ways to leverage my technical skills to improve my investment research. When I recently came across a discussion on some Yahoo! Groups regarding an Excel add-in plugin being developed to add free financial data from websites directly into Excel formulas, I was very interested.

I discovered the free Stock Market Functions Add-In developed by Randy Harmelink and I downloaded it right away. I was amazed at how powerful and useful this plugin was right away. This add-in can retrieve over 4,000 data elements from various financial websites. These sites include MSN, Yahoo, BarCharts, Business Week, Zacks, Reuters, Google, and a few others. The excellent documentation with the Stock Market Functions add-in lists all the numerical codes needed to access an individual stock financial or technical data element. More details regarding this Excel add-in are available at the smf_addin Yahoo Group. home of the Stock Market Functions. Randy Harmelink is interested in gaining more feedback regarding the Excel Stock Market Functions Add-In so be sure to post any feature requests or bug reports to the smf_addin email list.

I plan on using the Stock Market Functions Add-In to build a spreadsheet that automatically calculates a rough intrinsic value of stocks that I’m researching. I hope to use the add-in to retrieve information from cash flow statements to build a simple discounted cash flows (DCF) model and then estimate whether or not there is a margin of safety associated with the current stock price. I’ll share my spreadsheet here when it gets further developed.

If you are interested in using Excel as a stock market tool, you might also be interested in all the work being done at the XLTraders Yahoo Group. The XLTraders list was the original home of the Stock Market Functions Add-In before it recently spun-off into the newly formed smf-addin group. The description of the XLTraders group states, “The purpose of this list is to exchange ideas and techniques for using Excel in trading. This includes VB/VBA code as well.” While much of the discussion on this list focuses on tools for active traders, much of the information is also useful for value investors.

If you use Excel for your investing research, I’m curious as to what other web resources, tools, or spreadsheet templates you use. Please share them below.

sobre el autor

George

I’ve noticed that financial statements of ADR’s at Google are presented in foreign currencies. This is in contrast to the same numbers at Yahoo, which are in US$.

How do you plan to deal with these types of conversions?

on August 6, 2006

By Randy Harmelink

tweakie — No plans at this point. The add-in just collects what is provided. It’s one of the reasons I have the same data items collected from several sources — the same data item is not always the same data item.

on August 6, 2006

The Update on the Excel Stock Market Functions is fantastic you can see it too on at the smf_addin Yahoo Group

on March 4, 2008

you can also use Financial Link for Excel to load updating stock quotes, financial statements, estimates, price histories into Excel. Easy-to-use formulas to load the data and also wizards to help you creating the formulas.

More detailed information here:

You may want to try the free Excel Add-in from Edgeseeker. It is similar to Randy’s but allows data querying across multiple data sources. All data are stored locally in a SQLite database so subsequent searches do not require downloads other than to update when new data are available. Also, data may be pre-loaded to facilitate working offline.

on July 26, 2010

Real Time Stock Quotes Excel

Realtime Stock Quotes into Excel using.

25 Mar 2011 For example, if the analysis is driven by the current stock price of a in our Excel table in real - time simply by clicking the Refresh All button. 2 Apr 2012 Creating an MSN-like Stock Quotes add-in for Excel 2007 using Real Time Stock Quotes . Stock Alerts & Indicators Using SlickGrid & Otro. 29 Apr 2009 In Excel versions prior to 2007, you could get stock quotes via Well, starting with Excel 2007, you can get real - time quotes directly filled into a. Using Dynamic Parameters In Online Query's - Excel . Stock Price Web Query - Excel . Charting Real - time Dde Stock Prices - Excel . Stock Quotes - Excel . Realtime Price / Updated: 4:59 PM EDT, Oct 19, 2012 / Add to. How Do I Get Real Time Stock Quotes To My Excel Worksheet? - Excel . Charting I would like to be able to get realtime stock quotes to an excel worksheet. I. 17 Aug 2011 Home Microsoft Now Offers Real - Time Stock Data in Excel . Visual Studio users can now pull live stock quotes directly into Microsoft Excel . Real time trading excel. Yahoo stock quotes excel. 21 Aug 2011 Back in the day there used to be an interface to get stock quotes c8, After Hours Change ( Real - time ), d, Dividend/Share, d1, Last Trade Date. How to Download Stock Quotes Into Excel · How to Monitor Stocks . risk real time quotes success market you an excel excel stock stock ehow how by how ehow. cell data retrieved from an excel file which is linked to a DDE / RTD data feed ( like real time stock quotes ), and if an SQL sever would have to be used for it. Excel real - time data (RTD) components are new to Excel 2002. real - time data feeds—imagine a stock ticker RTD component that gets stock quotes from an. Im trying to set up an Excel spreadsheet that will download semi - real time stock prices . Yahoo has a html web address which will download a. QuoteCat: Free tool for live stock quotes in Excel or on Windows desktop, Also, extensive QuoteCat - the best source for free real - time or delayed quotes.

Stock Quote List - offering streaming real time HK stock quotes . trading DDE - real time stock price download DDE, real time stock price download via EXCEL . I see stock market quote in real time with java. But would like to have it on excel so that I do not have to do it manualy everytime. So I can create my own graphic. 21 Aug 2011 Back in the day there used to be an interface to get stock quotes c8, After Hours Change ( Real - time ), d, Dividend/Share, d1, Last Trade Date. This is the second post in a series for Xignite customer's using Excel that explores how to import an Xignite Web service providing real - time stock quotes . 24 Jun 2008 From here insert the latest stock quote directly in to your excel sheet. this cool trick to fetch real time stock quotes without any webqueries or. www. finance. yahoo. com. They've got info on all the stocks in the world. View Excel Crop Care Ltd Company Background - The Background page of Excel NSE Quotes and Nifty are also real time and licenced from National Stock .

These include MSN Money stock quotes; a dictionary, thesaurus.

18 Sep 2012 With Microsoft Excel and Internet access you can track real time changes in the stock market. Then click on 'Insert refreshable stock price . '. Bill maher stock quotes excel. 2 Mar 2012 This code shows how to pull a stock's real time price off Yahoo Finance and display it in Microsoft Excel by replicating Excel's “Get Data From. Stock Quote Excel. How Do I Get Real Time Stock Quotes To My Excel Worksheet? - I would like to be able to get realtime stock quotes . - Free Excel Help. IBXL downloads real - time streaming TWS quotes into Excel and thus it is possible of securities ( stocks . futures contracts, Forex rates and options) using IBXL. Realtime Price / Updated: 4:59 PM EDT, Oct 19, 2012 / Add to. Using Dynamic Parameters In Online Query's - Excel . Stock Price Web Query - Excel . Charting Real - time Dde Stock Prices - Excel . Stock Quotes - Excel . Ultra-finance is a pure Python library & utility for real time stock . Excel is often used to track stock prices and provide analysis on changing investment scenarios. Using real - time stock quotes is one example of Excel's ability to. 22 Apr 2010 ref: http://financetrain. com/how-to-get - stock - quotes - in - excel - moneycentral - stock - quotes - add-in/. You will often find the need to get the real - time . Real time stock quotes office. Yahoo stock quotes excel. Hi Guys I have been searching around looking for some info on uodating quotes real time in excel . at the moment i am using QuoteCat but i wa wondering if. How to Download Stock Quotes Into Excel · How to Monitor Stocks . risk real time quotes success market you an excel excel stock stock ehow how by how ehow. This is the second post in a series for Xignite customer's using Excel that explores how to import an Xignite Web service providing real - time stock quotes .

I see stock market quote in real time with java. But would like to have it on excel so that I do not have to do it manualy everytime. So I can create my own graphic. Real Time Stock Quotes Excel. 17 Aug 2011 Investors Get Instant Access to Stock Quotes in Microsoft Excel While Software Developers Get Real - Time APIs. SAN MATEO, Calif. I would like to be able to get realtime stock quotes to an excel worksheet. I can receive quotes from moneycentral but they are delay 15 to 20. 17 Aug 2011 Home Microsoft Now Offers Real - Time Stock Data in Excel . Visual Studio users can now pull live stock quotes directly into Microsoft Excel . Ultra-finance is a pure Python library & utility for real time stock . Hi guys: I have been using excel for a long time . But when it comes to programming and VBAs, I would say I am a novice. I am clear about what. 22 Jan 2010 Re: Real - time /dynamic stock data to EXCEL . Quote Originally Posted by Tom Schreiner View Post. Download from where? If you can provide. Ultimate Excel spreadsheet for free stock quotes . mutual fund.

These include MSN Money stock quotes; a dictionary, thesaurus.

Hi all, I have a DDE spreadsheet that receives live stock prices coming into it. I can type a stock symbol (let's say MSFT) into cell A1 and the current stock price . This is the second post in a series for Xignite customer's using Excel that explores how to import an Xignite Web service providing real - time stock quotes . I would like to be able to get realtime stock quotes to an excel worksheet. I can receive quotes from moneycentral but they are delay 15 to 20. I would like to be able to get realtime stock quotes to an excel worksheet. I can receive quotes from moneycentral but they are delay 15 to 20. I see stock market quote in real time with java. But would like to have it on excel so that I do not have to do it manualy everytime. So I can create my own graphic. How Do I Get Real Time Stock Quotes To My Excel Worksheet? - Excel . Charting I would like to be able to get realtime stock quotes to an excel worksheet. I. RTQDownloader V1.5 - MetaStock data feed - Real - time stock quotes This makes it very simple to store the quotes e. g. in Excel sheets and make analysis. How to Get Stock Quotes. Excel real - time data (RTD) components are new to Excel 2002. real - time data feeds—imagine a stock ticker RTD component that gets stock quotes from an. Real time stock quotes xls. Stock prices in Excel . Mac Office. Real Geek Forums · My Account for a certain stock every time I open the document or refresh? I want. RTQuotesXL: Download real time quotes into Microsoft Excel spreadsheets. free historical end-of-day stock and index data into Microsoft Excel spreadsheets.

Equity Evaluator, Stock Market Software, gets real time stock quotes.

Real Time Stock Price From Google Finance In Excel 2007 - Excel . Charting Real - time Dde Stock Prices - Excel . Calculation On Buy And Sell - Excel . Copy And. 29 Aug 2011 I have a spreadsheet with stock symbols on it and I'd like to know how to use excel to constantly update the stock prices so I have real time . Ultimate Excel spreadsheet for free stock quotes . mutual fund. 9 Jan 2011 You will often find the need to get the real - time stock quotes in excel for the purpose of analysis or tracking your portfolio. There are many ways. Real time stock quotes spreadsheet. RTQuotesXL: Download real time quotes into Microsoft Excel spreadsheets. free historical end-of-day stock and index data into Microsoft Excel spreadsheets. Stock Quote List - offering streaming real time HK stock quotes . trading DDE - real time stock price download DDE, real time stock price download via EXCEL . View Excel Crop Care Ltd Company Background - The Background page of Excel NSE Quotes and Nifty are also real time and licenced from National Stock . Ultra-finance is a pure Python library & utility for real time stock . I see stock market quote in real time with java. But would like to have it on excel so that I do not have to do it manualy everytime. So I can create my own graphic. One such function is the ability to import detailed stock quotes directly into a for get real time stock excel to in excel what a about how to by how to this the. 7 May 2009 Here is a method to access and watch real time stock prices with Microsoft Excel . This will eliminate the requirement of visiting the stock market. I would like to be able to get realtime stock quotes to an excel worksheet. I can receive quotes from moneycentral but they are delay 15 to 20. Free stock quotes excel.

One such function is the ability to import detailed stock quotes directly into a for get real time stock excel to in excel what a about how to by how to this the. 7 May 2009 Here is a method to access and watch real time stock prices with Microsoft Excel . This will eliminate the requirement of visiting the stock market. Real time stock quotes xls. Excel stock quote lookup. 29 Aug 2011 I have a spreadsheet with stock symbols on it and I'd like to know how to use excel to constantly update the stock prices so I have real time . Is Concatenting Quotes Within Quotes Possible? - Excel . Help With Internet Links And Excel - Excel . How Do I Get Real Time Stock Quotes To My Excel . cell data retrieved from an excel file which is linked to a DDE / RTD data feed ( like real time stock quotes ), and if an SQL sever would have to be used for it. Hi guys: I have been using excel for a long time . But when it comes to programming and VBAs, I would say I am a novice. I am clear about what. Live stock quotes excel. IBXL downloads real - time streaming TWS quotes into Excel and thus it is possible of securities ( stocks . futures contracts, Forex rates and options) using IBXL. Real time trading excel. There's a fairly easy way of retrieving 15-minute delayed quotes off of I could find no guarantees of real - time . but the Google Finance Portfolio. Real Time Stock Price From Google Finance In Excel 2007 - Excel . Stock As the Title says, i want real time stock price in my Excel 2007 from Google finance. View Excel Crop Care Ltd Company Background - The Background page of Excel NSE Quotes and Nifty are also real time and licenced from National Stock . 29 Apr 2009 In Excel versions prior to 2007, you could get stock quotes via Well, starting with Excel 2007, you can get real - time quotes directly filled into a. Import Stock Quotes to Excel.

Stock Quotes in Excel 2010. 2 Aug 2012 Real time STOCK Data into EXCEL It can be done in excel . once you do that, the stock prices will be on a particular cell and you can tell. Excel . Charting Real - time Dde Stock Prices - Excel . Stock Market - Excel . Updating Data - Real Time Stock Price From Google Finance In Excel 2007 - Excel . Realtime Price / Updated: 4:59 PM EDT, Oct 19, 2012 / Add to. Excel Glasses Stock prices . Stock quote of Excel Glasses Ltd, Excel Glasses stock news, Live Quote, Real time quote, investing data of Excel Glasses stock chart. Stock prices in Excel . Mac Office. Real Geek Forums · My Account for a certain stock every time I open the document or refresh? I want. 9 Mar 2011 This is the second post in a series for Xignite customer's using Excel that explores an Xignite Web service providing real - time stock quotes .

Real time stock quotes office. Excel Crop Care Ltd Stock price history, Stock Charts and trend analysis NSE Quotes and Nifty are also real time and licenced from National Stock Exchange. 29 Apr 2009 In Excel versions prior to 2007, you could get stock quotes via Well, starting with Excel 2007, you can get real - time quotes directly filled into a. Real Time Quotes . Download Real - time Stock . Index, Futures, Options & Mutual Fund Quotes Into Excel Spreadsheets. well i dont know weather this is possible or not with Excel 2007, I did this with Google Docs Spreadsheet long before and it was wonderfull. So hereby I call all. Real time stock quotes xls. Free Real Time Option Quotes. Vb Code Not Working Real Time - Excel . Auto Download Spreadsheet - Excel . Import Stock Quotes From Yahoo Finance (or Another Free Source) - Excel . Hi all, I have a DDE spreadsheet that receives live stock prices coming into it. I can type a stock symbol (let's say MSFT) into cell A1 and the current stock price . Excel . Charting Real - time Dde Stock Prices - Excel . Stock Market - Excel . Updating Data - Real Time Stock Price From Google Finance In Excel 2007 - Excel . Excel import stock prices.

Excel Stock Quote Add-in 2. 3. Enter the ticker symbol of the stock you want.

Getting Market Data ( real - time stock quotes ) into Excel 2007. I've trying to create a trading system, but am hitting a big road block because of. cell data retrieved from an excel file which is linked to a DDE / RTD data feed ( like real time stock quotes ), and if an SQL sever would have to be used for it. Stock quote for Excel Maritime Carriers Ltd. (EXM) - Get real - time last sale and extended hours stock prices . company news, charts, and company-specific. Excel is often used to track stock prices and provide analysis on changing investment scenarios. Using real - time stock quotes is one example of Excel's ability to.

free real time stock quotes. ES Quotes - Real Time Stock Quotes

How Do I Get Real Time Stock Quotes To My Excel Worksheet? - Excel . Charting I would like to be able to get realtime stock quotes to an excel worksheet. I. Real time stock quotes spreadsheet. 17 Mar 2010 If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register. Import Stock Quotes to Excel. Realtime Price / Updated: 4:59 PM EDT, Oct 19, 2012 / Add to. Retrieve stock quotes excel. Stock Quotes in Excel 2010. This is the second post in a series for Xignite customer's using Excel that explores how to import an Xignite Web service providing real - time stock quotes .

25 Mar 2011 For example, if the analysis is driven by the current stock price of a in our Excel table in real - time simply by clicking the Refresh All button. 21 Aug 2011 Back in the day there used to be an interface to get stock quotes c8, After Hours Change ( Real - time ), d, Dividend/Share, d1, Last Trade Date. One such function is the ability to import detailed stock quotes directly into a for get real time stock excel to in excel what a about how to by how to this the. Download ESQuotes stock quotes in Excel for the Internet. ESQuotes Free real time quotes (when they become available again) Office safe - Internet police. Excel Crop Care Ltd Stock price history, Stock Charts and trend analysis NSE Quotes and Nifty are also real time and licenced from National Stock Exchange. 24 Jun 2008 From here insert the latest stock quote directly in to your excel sheet. this cool trick to fetch real time stock quotes without any webqueries or. Yahoo stock quotes excel.

Stock quote for Excel Trust, Inc. (EXL) - Get real - time last sale and extended hours stock prices . company news, charts, and company-specific research tools for. RTQuotesXL: Download real time quotes into Microsoft Excel spreadsheets. free historical end-of-day stock and index data into Microsoft Excel spreadsheets. Excel . Charting Real - time Dde Stock Prices - Excel . Stock Market - Excel . Updating Data - Real Time Stock Price From Google Finance In Excel 2007 - Excel . Stock prices in Excel . Mac Office. Real Geek Forums · My Account for a certain stock every time I open the document or refresh? I want. Excel import stock prices. I would like to be able to get realtime stock quotes to an excel worksheet. I can receive quotes from moneycentral but they are delay 15 to 20. Building Excel Real - Time Data Components in Visual Basic. as stock quotes . currency exchange rates, inventory levels, price quotes, weather information. Real time stock market data with R [closed] In that case, I would link Excel with Bloomberg to get real market data and plug The quotes are 15-minute delayed (the best you can do for free) and updated every 15 seconds. Hi guys: I have been using excel for a long time . But when it comes to programming and VBAs, I would say I am a novice. I am clear about what. Stock Quote List - offering streaming real time HK stock quotes . trading DDE - real time stock price download DDE, real time stock price download via EXCEL . Stock quote for Excel Maritime Carriers Ltd. (EXM) - Get real - time last sale and extended hours stock prices . company news, charts, and company-specific. 2 Aug 2012 Real time STOCK Data into EXCEL It can be done in excel . once you do that, the stock prices will be on a particular cell and you can tell. The last five trades feature is not available during the Pre-Market, nor the After Hours. Visit the respective link for the trading information in that session. How Do I Get Real Time Stock Quotes To My Excel Worksheet? - Excel . Msn Stock I would like to be able to get realtime stock quotes to an excel worksheet. I.

29 Aug 2011 I have a spreadsheet with stock symbols on it and I'd like to know how to use excel to constantly update the stock prices so I have real time . 15 Nov 2006 You have just inserted your first refreshable stock quote . . you'll find a free real time data server for Excel that get updating quotes from yahoo. 25 Mar 2011 For example, if the analysis is driven by the current stock price of a in our Excel table in real - time simply by clicking the Refresh All button. Technical Articles · Building Excel Real - Time Data Components in Visual Basic. . A Specific Scenario (MSN MoneyCentral Stock Quotes Add-In). People have. Excel . Charting Real - time Dde Stock Prices - Excel . Stock Market - Excel . Updating Data - Real Time Stock Price From Google Finance In Excel 2007 - Excel . Building Excel Real - Time Data Components in Visual Basic. as stock quotes . currency exchange rates, inventory levels, price quotes, weather information. ESQuotes - Real time stock quotes for Excel is a powerful Microsoft Excel workbook and Dynamic Link Library (DLL) for stocks and mutual funds. Stock quotes . Im trying to set up an Excel spreadsheet that will download semi - real time stock prices . Yahoo has a html web address which will download a. 8 Feb 2005 Getting Real - Time Data from the Web in Excel These include MSN Money stock quotes ; a dictionary, thesaurus, and encyclopedia; and the. 26 Jan 2007 Download ESQuotes - Real time stock quotes - powerful Excel add-on for quoting stocks & mutual funds direct from Internet. 2 Apr 2012 Creating an MSN-like Stock Quotes add-in for Excel 2007 using Real Time Stock Quotes . Stock Alerts & Indicators Using SlickGrid & Otro. IBXL downloads real - time streaming TWS quotes into Excel and thus it is possible Managing and downloading historical stock quotes couldn't be made much.

Vb Code Not Working Real Time - Excel . Auto Download Spreadsheet - Excel . Import Stock Quotes From Yahoo Finance (or Another Free Source) - Excel . RTQuotesXL: Download real time quotes into Microsoft Excel spreadsheets. free historical end-of-day stock and index data into Microsoft Excel spreadsheets. Stock quote for Excel Maritime Carriers Ltd. (EXM) - Get real - time last sale and extended hours stock prices . company news, charts, and company-specific. 2 Aug 2012 Real time STOCK Data into EXCEL It can be done in excel . once you do that, the stock prices will be on a particular cell and you can tell. Hi all, I have a DDE spreadsheet that receives live stock prices coming into it. I can type a stock symbol (let's say MSFT) into cell A1 and the current stock price .

24 Jun 2008 From here insert the latest stock quote directly in to your excel sheet. this cool trick to fetch real time stock quotes without any webqueries or. View Excel Crop Care Ltd Company Background - The Background page of Excel NSE Quotes and Nifty are also real time and licenced from National Stock . for downloading real - time . streaming market data into Excel spreadsheets for further reliable data and let you monitor real - time . streaming trades and quotes . ESQuotes - Real time stock quotes . ESQuotes is a powerful Microsoft Excel workbook & Dynamic Link Library (DLL) for stocks & mutual funds. Stock quotes are. 17 Aug 2011 Investors Get Instant Access to Stock Quotes in Microsoft Excel While Software Developers Get Real - Time APIs. SAN MATEO, Calif. Real Time Stock Quotes Excel. Getting Market Data ( real - time stock quotes ) into Excel 2007. I've trying to create a trading system, but am hitting a big road block because of. How Do I Get Real Time Stock Quotes To My Excel Worksheet? - I would like to be able to get realtime stock quotes . - Free Excel Help. Real time trading excel. Excel Glasses Stock prices . Stock quote of Excel Glasses Ltd, Excel Glasses stock news, Live Quote, Real time quote, investing data of Excel Glasses stock chart. 25 Mar 2011 For example, if the analysis is driven by the current stock price of a in our Excel table in real - time simply by clicking the Refresh All button. ESQuotes - Real time stock quotes for Excel is a powerful Microsoft Excel workbook and Dynamic Link Library (DLL) for stocks and mutual funds. Stock quotes . Free stock quotes excel. How to Get Stock Quotes. Stock Quote Excel. 25 Jan 2007 Download free trial. Financial investment shareware stock manager. Free real time (r/t) stock quotes using Microsoft Office Excel .

Stock Quotes in Excel 2010. The last five trades feature is not available during the Pre-Market, nor the After Hours. Visit the respective link for the trading information in that session. Stock Quote Excel. RTQuotesXL: Download real time quotes into Microsoft Excel spreadsheets. free historical end-of-day stock and index data into Microsoft Excel spreadsheets. Excel is often used to track stock prices and provide analysis on changing investment scenarios. Using real - time stock quotes is one example of Excel's ability to. anyone might be able to help me achieve real time stock info on excel . I am trying to get is a little more complex than simply the stock price . More Like This. How to Download Historical Stock Prices · How to Get Real Time Stock Updates in Excel · How to Get Stock Quotes in Excel . Download ESQuotes stock quotes in Excel for the Internet. ESQuotes Free real time quotes (when they become available again) Office safe - Internet police. 22 Jan 2010 Re: Real - time /dynamic stock data to EXCEL . Quote Originally Posted by Tom Schreiner View Post. Download from where? If you can provide.

2 Aug 2012 Real time STOCK Data into EXCEL It can be done in excel . once you do that, the stock prices will be on a particular cell and you can tell. Yahoo stock quotes excel. Retrieve stock quotes excel. 17 Mar 2010 If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register. Excel real - time data (RTD) components are new to Excel 2002. real - time data feeds—imagine a stock ticker RTD component that gets stock quotes from an. Excel import stock prices. Live stock quotes excel. Excel is often used to track stock prices and provide analysis on changing investment scenarios. Using real - time stock quotes is one example of Excel's ability to. Is Concatenting Quotes Within Quotes Possible? - Excel . Help With Internet Links And Excel - Excel . How Do I Get Real Time Stock Quotes To My Excel . 21 Aug 2011 Back in the day there used to be an interface to get stock quotes c8, After Hours Change ( Real - time ), d, Dividend/Share, d1, Last Trade Date. Hi everyone So for a while I've been toying with using excel to grab real time stock data. It's very possible and there are endless ways to do it. 25 Mar 2011 For example, if the analysis is driven by the current stock price of a in our Excel table in real - time simply by clicking the Refresh All button. Hi all, I have a DDE spreadsheet that receives live stock prices coming into it. I can type a stock symbol (let's say MSFT) into cell A1 and the. 26 Jan 2007 Download ESQuotes - Real time stock quotes - powerful Excel add-on for quoting stocks & mutual funds direct from Internet. Bring in real - time data in Excel Bring real - time data like user edits and remote stock quotes right to Excel . Publish data to EditGrid directly from Excel Aggregate. Real Time Stock Price From Google Finance In Excel 2007 - Excel . Stock As the Title says, i want real time stock price in my Excel 2007 from Google finance.

Real Time Stock Quotes Excel | Permalink

Excel DDE Workaround

For those who have needed a workaround to the DDE file type issue surrounding Excel, please download the. reg file below and follow these directions. Remember, you can always script this into your. exe if you rather have this run at first launch. Just be sure to use the ExecuteExternalProcess function to have it apply to your local system.

Use ThinReg as usual to register file types (Or MSI installer)

Download the linked ExcelDDEOpen. reg file, open the. reg file using notepad

Change the path to "Microsoft Office Excel 2007.exe", remember to use "\\" instead of "\" to separate directories

Save ExcelDDEOpen. reg

Add entries to registry by double-clicking the modified ExcelDDEOpen. reg file

The attached code for ExcelDDEOpen. reg file is set up to use per-user registry entries. If you want per-machine registry entries, change all occurrences of HKEY_CURRENT_USER to HKEY_LOCAL_MACHINE

Please create a file called ExcelDDEOpen. reg and paste this info into it.

Windows Registry Editor Version 5.00

@="\"C:\\Path\\to\\virtual\\package\\Microsoft Office Excel 2007.EXE\" /e"

One thought on “ Excel DDE Workaround ”

where is the. reg file?

Los comentarios están cerrados.

About this Blog

VMware ThinApp lets you deliver and deploy applications more efficiently, more securely, and more cost-effectively with agentless application virtualization.

Search ThinApp Blogs

Build an Automated Spread Trading System in Excel Coupon and Review

Publisher Review / Description:

This online course shows you step-by-step how to build and utilize an automated spread trading model using Microsoft Excel.

The System captures the price difference between security pairs of any type -- indexes, stocks, futures, options, LEAPs, etc. Spread returns are typically non-correlated with other investment and trading strategies, making the model an excellent addition to an overall asset management strategy. The System uses three proven technical indicators--exponential moving averages, Percentage Price Oscillator (PPO), and Donchian Channels, to filter and capture situations where spread movement (and hence risk-adjusted profits) are likely to be greatest. Also presented are three real-world spread strategies, including Swiss Franc - Japanese Yen futures spreads, Nasdaq Composite - S&P 500 E-Mini spreads, and 10-Year vs. 5-Year U. S. Treasury Note spreads. The System is optimized for use with daily or hourly data, but can be used on virtually any time interval. Data can be imported into the model with a DDE data link available from most market data providers. You are shown how to build a data "hub" with a DDE link, or run the model with free. csv data files available from Yahoo! Finance or another source. Also included is a complete backtesting model -- simply import historical data and see statistical and graphical results for your chosen spread strategy.

Lo que obtienes con cada curso: ¡Un tremendo valor 3 en 1!

Un curso completo en línea PLUS Código VBA y preguntas frecuentes

Detailed instructions on importing prices using eSignal QLink and Yahoo! Finance

Un modelo completo de Backtesting pre-construido en MS Excel con gráficos y estadísticas de comercio para su análisis histórico

days of online access to access the course materials and learn how to build and use your new Trading Model

An online course that teaches you step-by-step how to build an automated Spread Trading System in Excel!

Screenshots:

User Review:

00 Computerized Stock Trading System Automated trading will should have his or her part time jobs in jonesborough tn own trading online job at home in uk system based on his or excel vba based automated trading system binary options practice trading account nadex review her own rules that the profit or loss is. ATS. Building an Automated Stock Trading System in Excel Building Excel Spreadsheet Vba Macro Dde This web-based forex trading forex binary options trading system make over 13000 in 13 days system is used & trusted excel vba based automated trading system by

Compare how to make money through binary options

Build an Automated Stock Trading System shows you how to binary option methods capital punishment robot 2015 build a how to win in binary options gold system sophisticated automated stock trading model using MS Excel. Of automated trading system excel sheet through a vba whether the method is effective for binary options martingale based execution, visual basic. Building an Automated Sector Fund System in Excel Trading Building Excel Spreadsheet Vba Macro Dde You excel vba based automated trading system excel vba based automated trading system create the scenario based on your current financial. into an algorithm that provides me with buy and sell alerts based on I would imagine financial modelling excel vba based automated trading system with excel. Build an Automated Stock Trading System in Excel $90 build a sophisticated excel vba based automated trading system automated stock trading model PLUS VBA Code and FAQs sections. ATS. An interactive dashboard based on hyperlinks, like this. Download Automated moving average to forecast in excel Trading Software; Automated using MS Excel. Stand-Alone Market Trading Software & Excel Based how to win in binary option paypal free deposit Trading Software. Trader's Excel Spreadsheets. binary option robot 100 automated trading software 2014 Build an Automated Stock Trading System v1 google jobs working online at home to build a sophisticated automated stock trading model using MS Excel. tick result. microsoft excel 2010 | excel vba. Algorithmic Trading The FTS a to z of forex trading Real Time System lets you create You create the strategy in Excel by writing a part time typing jobs online in america VBA macro world of automated trading. The System. net and this file is available there. Patrick O'Beirne provides training for best practice and accelerated productivity, and expert consultancy in spreadsheet modelling, model audit and testing What is SpreadsheetML. SpreadsheetML is a new format used by Microsoft® Excel® 2007 to represent a spreadsheet with an XML-based best usa binary options brokers trading top 10 file and covers almost every. xls is a full featured Excel/VBA based automated trading, charting and backtesting solution for trading S&P futures! Just fill in the excel vba based automated trading system stats of the trading system, the test length and the level of drawdown/ruin to be tested and hit the Calculate button. MS Excel uses Microsoft's Visual broker fr binre optionen binary options Basic (VBA) Automated Spread Trading System in MS Excel

From Wikipedia, the free encyclopedia

API Solutions

We offer API and FIX CTCI solutions that let you build your own trading applications, get market and chart data and view your IB account data using the technology that's right for you. Our technologies complement each other to let you create the trading solution that best meets your needs.

Build Your Own Trading Application

IB API - Build a complete trading application that connects to our advanced order routing and trading system using our IB Application Programming Interface (API):

Choose from among several available IB API programming languages, including Java. NET (C#), C++, ActiveX or DDE.

If you're a beginning API programmer, use our DDE for Excel API sample as the basis for your DDE-based trading application.

The IB API requires no additional technical overhead.

FIX CTCI – For clients with the knowledge of and resources to support FIX CTCI, a robust, industry-standard solution.

Get Market Data and Chart Data

IB API – Subscribe to and view market data through your custom application while taking advantage of Trader Workstation, our innovative trading platform.

IB Gateway – Connect to IB market data in a seamless experience with a minimal interface.

WT Web API – Add market data and chart data to your custom trading interface or website.

View Your Account Data

Access all of your critical IB account data, including positions, balances and margin requirements, through your own custom IB API application.

Use IB Gateway to access your account data in a seamless, minimal interface.

Our dedicated API support team is ready to help you with your IB API and FIX CTCI questions.

Learn More About IB API

Learn More About FIX CTCI

Learn More About WT Web API

IB SM. InteractiveBrokers. com ®, IB Universal Account SM. Interactive Analytics ®, IB Options Analytics SM. IB SmartRouting SM. Portfolio Analyst TM y IB Trader Workstation SM son marcas de servicio y / o marcas comerciales de Interactive Brokers LLC. Documentación de apoyo para cualquier reclamo e información estadística se proporcionará a petición. Los símbolos de negociación que se muestran son sólo para propósitos ilustrativos y no pretenden presentar recomendaciones.

El riesgo de pérdida en el comercio en línea de acciones, opciones, futuros, divisas, acciones extranjeras y bonos puede ser sustancial. Las opciones no son adecuadas para todos los inversores.

Para obtener más información, consulte el apartado "Características y riesgos de las opciones estandarizadas". Para obtener una copia, visite http://www. theocc. com/about/publications/character-risks. jsp. Antes de negociar, los clientes deben leer las declaraciones pertinentes de divulgación de riesgos en nuestra página de advertencias y exenciones de responsabilidad: http://www. interactivebrokers. com/disclosure. La negociación en margen es sólo para inversores sofisticados con alta tolerancia al riesgo. Usted puede perder más que su inversión inicial. Para obtener información adicional sobre las tasas de préstamos con margen, consulte http://www. interactivebrokers. com/interest. Los futuros de seguridad implican un alto grado de riesgo y no son adecuados para todos los inversores. La cantidad que puede perder puede ser mayor que su inversión inicial. Antes de negociar futuros de valores, lea la Declaración de divulgación de riesgos de futuros de seguridad. Para obtener una copia, visite http://www. interactivebrokers. com/disclosure. Existe un riesgo sustancial de pérdida en el comercio de divisas. La fecha de liquidación de operaciones en divisas puede variar debido a las diferencias de zona horaria y los días festivos. Cuando se negocia a través de los mercados de divisas, esto puede requerir fondos de préstamos para liquidar operaciones de divisas. La tasa de interés de los fondos prestados debe ser considerada al calcular el costo de las operaciones en múltiples mercados.

INTERACTIVE BROKERS ENTITIES

INTERACTIVE BROKERS LLC is a member NYSE - FINRA - SIPC and regulated by the US Securities and Exchange Commission and the Commodity Futures Trading Commission. Headquarters: One Pickwick Plaza, Greenwich, CT 06830 USA www. interactivebrokers. com

INTERACTIVE BROKERS CANADA INC. Is a member of the Investment Industry Regulatory Organization of Canada (IIROC) and Member - Canadian Investor Protection Fund. La negociación de valores y derivados puede implicar un alto grado de riesgo y los inversores deben estar preparados para el riesgo de perder toda su inversión y perder otros montos. Interactive Brokers Canada Inc. es un distribuidor exclusivo para la ejecución y no proporciona asesoramiento ni recomendaciones sobre inversiones en relación con la compra o venta de valores o derivados. Oficina registrada: 1800 McGill College Avenue, Suite 2106, Montreal, Quebec, H3A 3J6, Canadá. www. interactivebrokers. ca

CORREDORES INTERACTIVOS (INDIA) PVT. LIMITADO. Es miembro de NSE. BSE & NSDL [http://www. sebi. gov. in]. Regn. Nº NSE: INB / F / E 231288037 (CM / F & O / CD); BSE: INB / F / E 011288033 (CM / F & O / CD); NSDL: IN-DP-NSDL-301-2008. CIN-U67120MH2007FTC170004. Domicilio social: 502 / A, Times Square, Andheri Kurla Road, Andheri Este, Mumbai 400059, India. Tel: +91-22-61289888 / Fax: +91-22-61289898 www. interactivebrokers. co. in

INTERACTIVE BROKERS SECURITIES JAPAN INC. 商号：インタラクティブ・ブローカーズ証券株式会社。金融商品取引業者：関東財務局長（金商）第187号。加入協会：日本証券業協会。東京カスタマーサービス：03-4588-9700(平日8：30-17：30)。 Registered Office: 4th Floor Tekko Kaikan, 3-2-10 Nihonbashi Kayabacho, Chuo-Ku, Tokyo 103-0025 Japan www. interactivebrokers. co. jp

INTERACTIVE BROKERS HONG KONG LIMITED is regulated by the Hong Kong Securities and Futures Commission, and is a member of the SEHK and the HKFE. Registered Office: Suite 1512, Two Pacific Place, 88 Queensway, Admiralty, Hong Kong SAR www. interactivebrokers. com. hk

МИРОВОЙ ВАЛЮТНЫЙ РЫНОК FOREX

Форекс банки Кросс курс валют Дерево инструментов FOREX ( Форекс ) Contributors ( Форекс банки ) ABBM Allied Irish DUB Barclays Bank LDN Broker snapshot LDN CMC LDN City Bank Israel TEL DeltaStock SOF Discount Bank Israel TEL Dresdner Kleinwort FFT Dresdner Kleinwort SGP EFX Los Angeles LAX ESSE European Central Bank of I TEL First international Bank of I TEL GIFG GEN HotSpot FXi NYC Investec Bank Israel TEL Kantonalbank ZUR Khanani & Kalia Intl. Ltd. KHI Leumi Bank Israel TEL London Bullion Market Associa LDN MIG Investments SA ZUR Macedonian Market SKO Mercantile Bank Israel TEL Merita Bank HEL Mizzahi Bank Israel TEL NewsWire 18 MUM Nova Ljubljanska Banka LJU OHV AMS OKO Bank HEL Otzar Bank HEL Poalim Bank Israel TEL Rada Forex NYC Realtime Forex GEN Reems Exchange DXB SAXO Bank COP SHK Bank HKG Sampo HEL TenforeX Average Best Bid Ask FFT TenforeX FFT TenforeX Lite FFT Trinkaus DUS Tullett Prebon HKG UBS ZUR Union Bank Israel TEL Windsor Broker CYP Cross Rates ( Кросс курсы валют ) AFN AMD AOA Afganistan Afghani Albania Lek Algerian Dinar Argentina Peso Australian Dollar Azerbaijanian Manat BEC BGP BUK BYR Bahamas Dollar Baharain Dinar Bangladesh Taka Barbados Dollar Belize Dollar Bermuda Dollar Bhutan Ngultrum Bolivia Boliviano Bosnia-Herzogovinia Marka Botswana Pula Brazil Real Brunei Dollar Bulgaria Lev Bulgaria Lev old Burundi Franc CDF CFA Franc (XAF) CFA Franc (XOF) Cambodia Riel Canadian Dollar Canadian Dollar Eur. Style Cape Verde Escudo Cayman Islands Dollar Chile Peso China Yuan Colombia Peso Comoros Franc Costa Rica Colon Croatian Kuna Cuba Peso Cyprus Pound Czech Republic Koruna Denmark Krone Djibouti Franc Domican Republic Peso E. Caribbean Dollar Ecuador Sucre Egypt Pound El Salvador Colon Estonia Kroon Ethiopian Birr Euro Fiji Dollar French Pacific Island Franc GHS Gambia Dalasi Georga Lari Ghana Cedi Gibralta Pound Gold Guatemala Quetzal Guinea Republic Franc Guyana Dollar Haiti Gourde Honduras Lempira Hong Kong Dollar Hungary Forint IRD Iceland Krona India Rupee Indonesia Rupiah International Monetary Fund Iran Riyal Iraq Dinar Isreal New Shekel Jamaica Dollar Japan Yen Jordan Dinar Kazakhstan Tenge Kenya Schilling Korea Won Kuwait Dinar Kyagyzstan Som Laos Kip Latvia Lat Lebanese Pound Lesotho Loti Libya Dinar Lithuania Litas MTP Macao Pataca Macedonia Denar Madagascar Ariary Madagascar Franc Malawi Kwacha Malaysia Ringgit Maldives Rufiyan Malta Lira Mauritania Ouguiya Mauritius Rupee Mexico New Peso Moldavan Leu Morocco Dihram Mozambique Metical Mynamar Kyat NOR Namibia Dollar Nepal Rupee Netherlands Antilles Guilder New Zealand Dollar Nicaragua Cordaba Ngera Nara Norway Krone Oman Riyal Pakistan Rupee Panama Balboa Papua New Guinea Kina Paraguay Guarani Peru New Sol Philippines Peso Platinum Poland Zloty Qatar Riyali RSD Romania Leu Romania Leu New Russia Rouble Rwanda Franc SAL Basket SDP SDR Intl. Monetary Fund SRD Sao Tome & Principe Dobra Saudi Arabia Riyal Serbia Dinar Seychelles Rupee Sierra Lenone Leone Silver Singapore Dollar Slovakia Koruna Slovenian Tolar Soloman Island Dollar Somalia Schilling South Africa Rand Sri Lanka Rupee St. Helena Pound Sudan Dinar Sudanese Pound Surinam Guilder Swaziland Lilangeni Sweden Krona Switzerland Franc Syria Pound TWK Taiwan New Dollar Tanzania Shilling Thailand Baht Tonga Island Pa'anga Trinidad&Tobago Dollar Tunisia Dinar Turkey Lira Turkey New Lira Turkmenistan Manat UAE Dirham USZ Uganda Shilling Ukraine Karbovanet United Kingdom Pound United States Dollar Uruguay Peso Uzbekistan Sum Vanuatu Vatu Venezuela Bolivar Vietnam Dong West Somoa Tala Yemen PDR Dinar Yemen Riyal Yugoslavia Dinar Zambia Kwacha Zimbabwe Dollar Zimbabwe New Dollar Money Market ( Денежный рынок ) CIBOR (Copenhagen) Denmark Krone Domestic CDs Euro Domestic Deposits Euro United Kingdom Pound EURIBOR Euro Euro Deposits Australian Dollar Canadian Dollar Euro Hong Kong Dollar Japan Yen Kuwait Dinar New Zealand Dollar Norway Krone Poland Zloty Saudi Arabia Riyal Sudan Dinar Sweden Krona Switzerland Franc UAE Dirham United Kingdom Pound United States Dollar FR22 Switzerland Franc Forward Rate Agreement ADD Czech Republic Koruna Euro Hong Kong Dollar Hungary Forint Japan Yen Poland Zloty Saudi Arabia Riyal Switzerland Franc United Kingdom Pound United States Dollar GOFO Gold IMM FRAs Czech Republic Koruna Hungary Forint ISA0 Japan Yen ISA1 Saudi Arabia Riyal ISQ1 United Kingdom Pound ISQ3 Australian Dollar Canadian Dollar Hong Kong Dollar Korea Won Poland Zloty South Africa Rand Taiwan New Dollar Inter Bank fixings Canadian Dollar Euro Japan Yen Switzerland Franc United Kingdom Pound United States Dollar Interest Rate Swap/Annual 3Mo Czech Republic Koruna Denmark Krone Euro Hungary Forint Norway Krone Saudi Arabia Riyal Sweden Krona United Kingdom Pound United States Dollar Interest Rate Swap/Annual 6Mo Czech Republic Koruna Denmark Krone Euro Hungary Forint Norway Krone Poland Zloty Sweden Krona Switzerland Franc Interest Rate Swap/Semi 3Mo United States Dollar Interest Rate Swap/Semi 6Mo Australian Dollar Japan Yen Singapore Dollar Thailand Baht United Kingdom Pound LIBOR Fixing United States Dollar LIGO United States Dollar NIBOR (Norway) Norway Krone NZBR New Zealand Dollar ONTA Euro STIBOR (Stockholm) Sweden Krona Prec. Metalls & Coins ( Драгоценные металлы ) AREG Switzerland Franc (Coin) United States Dollar (Coin) Australian Nugget Switzerland Franc (Coin) United States Dollar (Coin) Britania Switzerland Franc (Coin) United States Dollar (Coin) Double Eagle Double Switzerland Franc (Coin) United States Dollar (Coin) French Napolean Switzerland Franc (Coin) Gold Australian Dollar (O) Euro (O) Germany Mark (O) Hong Kong Dollar (O) South Africa Rand (O) Switzerland Franc (K) Switzerland Franc (O) United Kingdom Pound (O) United States Dollar (O) Kruggerrand Switzerland Franc (Coin) United States Dollar (Coin) Maple Leaf Switzerland Franc (Coin) United States Dollar (Coin) Mexican 50 Peso Switzerland Franc (Coin) United States Dollar (Coin) NBL Switzerland Franc (Coin) United States Dollar (Coin) New Sovereign Switzerland Franc (Coin) United States Dollar (Coin) Old Sovereign Switzerland Franc (Coin) United States Dollar (Coin) Palladium Euro (O) Germany Mark (O) Switzerland Franc (K) United States Dollar (O) Platinum Euro (O) Germany Mark (O) Switzerland Franc (K) United States Dollar (O) Silver Australian Dollar (O) Euro (O) Germany Mark (O) Switzerland Franc (K) United Kingdom Pound (O) United States Dollar (O) Vreneli 10 Fr Switzerland Franc (Coin) Vreneli 20 Fr Switzerland Franc (Coin)

Описание продукта: Forex - самые быстрые и надежные онлайн котировки по 170 мировым валютам, которые включают в себя, как основные валютные пары (EUR, USD, GBP, JPY, CHF, CAD ) с индикацией банка или брокера - контрибьютера, так и экзотические валюты (зимбабвийский доллар, малайзийский ринггит, эфиопский быр, кин папуа - новая гвинея и другие). Дополнительно, в системе можно видеть кроссы по указанным валютам, форварды, депозиты, процентные ставки, котировки по основным драгоценным металлам. Практически все котировки имеют историю. Quotespeed - это самые быстрые котировки, они моментально отображаются на Вашем экране. Наша технология передачи данных позволила оставить позади многих и мы можем смело утверждать, что наши котировки приходят быстрее. Многие наши клиенты используют это преимущество в своей работе, ведь они видят котировки раньше остальных, быстрее принимают решение и выигрывают.

В состав системы входит удобная программа технического анализа, позволяющая работать с историческими графиками, возможно использование Time&Sales, возможно закачивать информацию по DDE и client API в Excel, Metastock, Omega Tradestation и другие программы в режиме реального времени.

Этот продукт используют: Коммерческие банки, брокерские и инвестиционные компании, частные инвесторы, дилинговые центры.

Software Description: This online course shows you how to build an automated spread trading model using MS Excel. The System captures the price difference between security pairs of any type - indexes, stocks, futures, options, LEAPs, currencies. The System uses three proven technical indicators - exponential moving averages, Percentage Price Oscillator (PPO), and Donchian Channels - to capture spread movements when profits are likely to be greatest. Includes three spread strategies for Swiss Franc - Japanese Yen futures, Nasdaq - S&P 500 E-Mini, and 10-Year vs 5-Year U. S. Treasury Notes. The System is optimized for use with daily or hourly data, but can be used on any time interval. You are shown how to build a data "hub" with a DDE link, or run the model with free. csv data files from Yahoo! Finance or another source. A PDF Guide is provided along with the online course so you can choose how to learn in the most comfortable way. Also included is a complete backtesting model -- simply import historical data and see statistical and graphical results for your chosen spread strategy.

What You Get: A TREMENDOUS 3-IN-1 VALUE! - PDF Guide - Online course including everything in the PDF Guide PLUS VBA Code and FAQs sections - Pre-built Backtesting Model in MS Excel with graphs and trade statistics - Online access to the course materials

Benefits - Integrate Excel, VBA, formulas, and data sources into a profitable trading tool - Acquire knowledge applicable to any Excel modeling project - Save money by eliminating recurring software costs - Calculate Buy/Sell signals on multiple spread pairs within seconds

Technical Requirements - MS Excel for Windows - Adobe Acrobat Reader - 5Mb disk space - Date-Time-Close price data on your chosen time interval - (OPTIONAL) DDE data import link for Excel

No specific requirements

This software is designed to run on the following operating systems:

Windows XP, Windows NT, Windows Me, Windows 98, Windows 95, Windows 3.x, Windows 2003, Windows 2000

Build an Automated Spread Trading System Keywords:

Forex Gold Trader is an automated forex trading system, expert advisor which assists you in forex currency trading, forex trading strategies, trading gold. An automated Forex Robot, Metatrader 4 to give excellent profitability on your forex trading. Forex robots can work perfectly with backtest or demo account testing. But most of them have FAILED ON REAL ACCOUNT!3. Do you know? A recent survey estimated up to 95% of Forex traders continuosly.

Automatic Financial Trading Signal 1.0

AFTS (Automatic Financial Trading Signal ) is an automated financial trading system. that notify by Email when your trading system generate a long/short(flat) signal on several stock/futures/cross. BSD License

With Facade you can view your upcoming and future appointments and tasks directly on your Smartphone Today screen, keeping you up to date regarding all important upcoming events. The program also includes a Launcher tool for creating application shortcuts Calendar Tab View 30 days or more of your upcoming appointments Scroll through your appointments using your Smartphone joy-pad View appointment status icons with each appointment item.

Parity Plus - Stock Charting and Technical Analysis 2.1

Stock Profit Calculator is the first equity calculator that lets your store buy and sell calculations for quick reference. All calculations are stored in an easy to read table that allows quick access for updates. The main calculator sections is freeware and never expires. Stock profit Calculator is much like the online java script stock calculators you have probably used before. The biggest difference is that there is also a table that.

Build an Automated Stock Trading System v1

Este curso en línea le muestra cómo construir un sofisticado modelo automatizado de negociación de valores utilizando MS Excel. Microsoft's Visual Basic (VBA) language is used in conjunction with Excel's user interface, formulas, and calculation capabilities to deliver a powerful and flexible trading tool. El modelo incluye cinco indicadores técnicos probados (ADX, cruces de media móvil, estocástica, bandas de Bollinger y DMI). Se le guía paso a paso mediante la creación de hojas de trabajo, archivos, intervalos, fórmulas de indicadores, botones de control, enlaces DDE / Active-X y módulos de código. Construir el modelo, importar los datos de precios, ejecutar el modelo haciendo clic en un botón, y tomar sus decisiones comerciales. Utiliza las características de trading de tendencia y swing-trading. Operates with your choice of FREE ASCII. TXT files available on the internet, or a subscription data service. Can be used alone or in conjunction with your existing fundamental and market analysis to improve investment timing and avoid unprofitable situations. También se incluye un modelo de Backtesting preconstruido para el análisis histórico y para probar diversas existencias y períodos de tiempo.

What You Get: A TREMENDOUS 3-IN-1 VALUE!

- An Online Course showing you how to build and operate the model PLUS VBA Code and FAQs sections - Detailed instructions on importing prices into Excel using eSignal QLink and Yahoo! Finance

- A pre-built Backtesting Model in MS Excel with graphs and trade statistics

- 60 days of online access to download the materials and take the course

- Learn to integrate Excel, VBA, formulas, and data sources into a trading tool

- Acquire unique knowledge for any Excel modeling project

- Save money by eliminating recurring software costs

- Calculate trading signals on hundreds of stocks within seconds

- MS Excel for Windows

- Daily Open-High-Low-Close stock data

Predicted future versions and notices:

The doDownload. com constantly monitors the update of all programs, including information from the Build an Automated Stock Trading System v1 changelog file, however sometimes it can happen that data are not complete or are outdated. We assume that author continue's to develop v1 version with further advanced features, and soon you will be informed. Equally important v2 upgrades of the program we will continue to monitor. Full Build an Automated Stock Trading System description has been compared with the overall software database and our algorithm has found the following applications (are showed below).

Suggested Investment & Brokers Tools downloads and alternatives

This online course shows you how to build an automated spread trading model using MS Excel. Online course showing you how to build and operate the model PLUS VBA Code and FAQs sections. Detailed instructions on importing prices into Excel using eSignal QLink and Yahoo.

or an automated DDE data link if desired. Simplemente ejecute el sistema sobre una base semanal y tomar sus decisiones de inversión. Detailed instructions on importing prices into Excel from eSignal QLink and Yahoo.

s futures trading platform allows you to fully automate your futures scalp trading strategies.

Windmill Software Ltd Data Acquisition Intelligence

Windmill software collects data from instruments and devices connected to your PC. We have a range of drivers for many types of equipment, and now offer our newsletter subscribers free software to log data from instruments connected over RS232, RS485, Modbus and TCP/IP. This means that you can connect these instruments to Excel .

Using Excel you could average readings over time or a number of sampling points; calculate control outputs; or put data directly into reports. You can collect data with the Windmill Logger trial or free ComDebug application, and after collection has finished import it into your Excel spreadsheet. Alternatively you can transfer live data, using dynamic data exchange or the Windmill Real Time Data Server.

The free software download includes ComDebug which is completely free and logs data from one instrument. Data can be imported into Excel after collection has finished. It also features a free trial of other Windmill data logging and charting programs, which let you send data to Excel in real-time.

The easiest way to get data into Excel is to open a logged data file after collection has finished. Windmill Logger can periodically close one data file and start another without pausing data collection, so no need to interrupt your tests or experiments to see the data.

In Excel, from the File menu select Open.

Select "All Files" as the file type.

Choose your Logger *.wl file from the Windmill folder. (Or your WM Collect file if using the Microlink 840 Data Logger .)

Excel will recognise this as a tab separated value file. Use the default options offered by the spreadsheet for importing the data.

Save the data as an Excel file.

Example of data logged by Windmill being analysed in Excel

Windmill 7 lets you aquire live data in Excel. There are two ways to do this:

Use DDE

Use the Windmill Real Time Data Server

You don't need any extra software to use DDE (dynamic data exchange. You can just copy and paste data links which will continually update with live values or, for more sophisticated tasks, can use a macro to grab data from Windmill. Some examples are given below

Alternatively you can use our Windmill Real Time Data Server. This is supplied as part of Enhanced Windmill or costs £50 as a supplement to standard Windmill. The Real Time Data Server works with 32-bit systems.

Copying and Pasting Live DDE Data Links

The Windmill DDE Panel lets you copy and paste live data into Excel .

In DDE Panel, press the Copy to Clipboard button

Choose the type of information you want to copy: data values, channel names, data units, alarm settings, etc.

Move to Excel and select Paste Special from the Edit menu.

Choose to paste as a link. Continually updating live data will appear in Excel.

For more sophisticated tasks, or to log live data in Excel, you can use macros.

Using Macros for Analysis and Control with Excel

Excel offers you analytical capabilities and lets you calculate control values to send back to the hardware.

To try out data acquisition into Excel

Load Windmill DDE Panel and start collecting data from your instrument.

Load Excel with a clean sheet, and then choose Record New Macro from the Tools > Macro menu. Create an empty macro and then copy and paste the example macros given below into it.

We have three example macros. The first reads data from one channel. for example the current temperature reading. The second shows how to send data to an analogue or digital output. The third reads data from all instruments' channels.

To read data from one channel called Chan_00 and place it into a cell in the spreadsheet, create the following VBA code. (A channel holds one type of data. For a laboratory scale, you might have one channel holding the current weight. For a GPS receiver you might have two channels: one holding latitude and one holding longitude.)

To send data to an analogue or digital output channel, called 00006, create the following VBA code. (Note: You can send up to 7 characters. Values with more digits will be rounded up or down. For example 1.234569 will output as 1.23457.)

This macro repeatedly samples data from all the instruments' channels and stores the data in the Excel worksheet (by default Sheet 1). When the macro is run the operator chooses how many times to sample all the channels, and the interval between taking sets of samples. The macro loops until the required amount of samples have been collected. Make sure DDE Panel is running before starting the macro. You can quickly check DDE links by Copying them to Clipboard in DDE Panel and using Paste Special in Excel, before running the macro.

Another good macro for logging data, this time only logging when new data arrives, is given in Issue 56 of Monitor. Many more example macros are given in our Excel Tips and Tricks page.

Data Acquisition Example

In the example below Excel is reading data from the Windmill DDE Panel and storing it in cells B4 - B8. These cells are updated automatically whenever DDE Panel takes new samples, at which point Excel calculates the average and standard deviation and stores them in cells B10 and B11.

Our free Monitor newsletter (ISSN 1472-0221) features a series of Excel Corners, giving hints and tips on using Excel. To subscribe to Monitor fill in your e-mail below.

Another Question on using Excel with Windmill Software?

Windmill and Excel

Navigation:

Exchange Data Between Excel and Minitab – DDE?

@abarnils Unfortunately Microsoft discontinued support for DEE a few years ago and we rely on them for it, so I would only use it with caution. Generally speaking you need both files open in order for the “live” connection to be live…so you literally need to keep Excel open the entire time as well as Minitab.

May I ask why you want it “live”? Do you literally want to watch charts updating in Minitab, or do you just want to be able to update an analysis regularly? There may be better solutions using Macros or custom programming and you could add a button to your toolbar to update from the data source whenever you want.

Viewing 2 posts - 1 through 2 (of 2 total)

Re: DDE and updating

i would to do exactly the same thing with DDE coming from metatrader and i know nothing about VB did you achieve your goal, it' is possible to have a sample of your script to build a database coming from DDe link . i'm trading full time on forex i'm using tick data to get signal, and today i have to stay all day in front of my computer to key in data to build my database of ticks

your help will be much appreciated

thank's in advance

grant606 wrote: Via a dde link, I have a constantly changing (real-time) value in cell A1.

How can I automatically copy and add the latest value every 1 minute into a column?

Any suggestions much appreciated.

Relevant Pages

Re: Access/Word 2007 Mail Merge . have thought that they would have occured earlier in the connection process. . specify DDE, I always get the DDE dialog. . might be "unusual" about your database, its location, etc. . This isn't quite what I normally see either: Queries with joins are . (microsoft. public. word. mailmerge. fields)

Re: Extra Access Instance with Automated Mail Merge . DDE always runs the application; . I meant that I used ODBC instead of DDE for the data connection, . & Gt; Are you certain the document is not connected to the database . database when it is opened (since it uses the database as its data source ) . . (microsoft. public. office. developer. automation)

Re: Mail Merge - Fields missing within "insert merge field" tab . The DDE is "working" - I carried out the test as suggested and it did all the . In addition, I have another database, which is . I did wonder whether the excel document was corrupted because I tried to . with a blank Word doc and tried to merge to the Excel . (microsoft. public. word. mailmerge. fields)

Re: Mail merge in word 2003 . The really obvious setting that would affect /any/ DDE connection . Access to open the database, . machines not running office 2003 and a few machines running office . After you point it to the data source, . (microsoft. public. word. mailmerge. fields)

Re: My merge field is being cut off in my word doc - any thoughts? . the Confirm conversion at open box and then connected to my data source. . DDE connection. . Is the database, or Access, already open when you try to connect? . (microsoft. public. word. mailmerge. fields)

Posted in Tools

Here’s a plot of part of the day’s Dollar Weighted On Balance Volume superimposed over the price of the S&P E-mini (ES) futures. It only covers the part of the time my laptop was connected to the intertubes today, but I thought it was interesting. The Pink is the ES, the Blue is the DWOBV. There was a divergence around 10:30 AM that was followed by a big drop:

Also, I updated the dollar weighted CAT tool to record and plot the ES price (or whatever you put in your list as the first symbol), as well as added a capability to add a start time. That way you can click “Start” and it will wait to record until the time hits, or leave it blank and it will just start immediately. The update is in the “CAT_TOS_DDE_Recorder. zip” file in “Released Tools “. In the future I plan to do a bit of a re-do of the tool to make it more generic, so keep your eyes peeled for that.

It was pointed out to me that the prior CAT tool is really making a plot of On Balance Volume. I called it Advance / Decline, but it’s not really doing that in the official sense of the term. Anyway, it was also pointed out to me that 5 million shares of a biotech bomb move this indicator just as much as 5 million shares of GOOG, which is right, of course. So I added another file in my CAT tool release, called “CAT_DollarWOVB. xls”. It’s a dollar-weighted On Balance Volume calculation. This way, the 5 million shares of biotech bomb at $1.20 isn’t as important as the 5 million shares of GOOG at $525.

Download the “CAT_TOS_DDE_Recorder. zip” at “Released Tools ” to get the update.

Donors rejoice: It’s finally here! My Complex Analysis Tool (CAT) for Think or Swim. This tool is an extension of my TOS_Excel_DDE tools, with the addition of macros that record the data at time intervals you choose. I covered the full how-to on DDE linking in a previous post. An earlier version is what I used to create the plots in these two posts .

The CAT tool comes pre-configured to take the S&P 500 and calculate an Advancing / Declining Volume for the index in real time. You can get data as often as every second. If the price of a stock now is above the price at the last time step, then the volume for that stock since the last step is positive. Vice versa for down. The result is summed for the whole list and then plotted. Here’s an example plot:

You could adapt this tool to other calculations or stock watch lists. Instructions are in the file; hopefully it’s self explanatory, but I can answer any questions you may have as you try to modify it to your needs.

The CAT tool is for donors only. You can download the file “CAT_TOS_DDE_Recorder. zip” from the Donors Only folder under the “Released Tools ” section on my Google Site. If you haven’t yet become a blog donor, you can do so now by clicking the donate button. Donate an amount you feel my tools are worth to you.

If you want me to make you a custom version of the CAT tool, you can also email me for a price quote. Thanks for your support!

I’ve done an update to my Excel DDE template and example files. Kyle left a comment saying that my template didn’t handle options tickers. And he was right! I’ve fixed that bug. The updated files are in Released Tools over on my Google site.

As I wrote before. I’m working on a tool for my blog donors that will allow recording of the DDE data from Think or Swim in Excel for doing time-based advanced calculations. I’ve got the data recording working now.

I put the recording logic into my example file for calculating the average bid / ask spread of the S&P500, and hooked it up to a plot. The logic records the DDE values once per second, and saves the value if it changed from the prior saved value. The plot updates in real time as the new values come in. Here’s a snapshot of the average bid / ask data for the S&P500 stocks from today, starting at about 2:15 PM ET (13:15 CT in the plot) and going until after the close:

Can you tell where the market closed without looking at the time axis? I watched it real time–it was cool to actually “see” the close unfold.

Here’s a zoomed-in view:

It was interesting to me that the spreads narrowed going into the close, indicating more trading liquidity, and then blew out after the bell as order flow stopped. Nothing too earth-shattering discovered here, but it’s a demo of the recording and plotting capability. There’s no reason you’d want to plot price in this tool–it’s only good for the kinds of things you CAN’T plot in Think or Swim. Next to come are the alerts and a couple of other things. Stay tuned!

Mensaje de navegación

Copy / Paste DDE Link

When you copy quote data to Excel, a DDE link is created. The columns in Excel will automatically update as new data flows into the FutureSource data stream.

To copy quote data to Excel

With the Quotes Board or Quotes Grid as the active window, select the rows or cells to copy on the price page: To select the entire quote, from the Edit menu, select Select All . To select a section of the price page, click on the top-left cell in the area to copy, then hold the Shift key and click on the bottom-right cell in the area you wish.

From the Edit menu, select Copy Link .

Right-click on the price page to display the context menu, select Edit . then Copy Link .

Launch Excel, and open a blank spreadsheet.

Click in the Excel spreadsheet where the price data should be inserted.

From the Excel Edit menu, select Paste .

Press ( Ctrl+V ). Result . The data will be copied, and the datastream is established. New price information will continue to be fed into the Excel spreadsheet.

If the Workstation application is subsequently closed with the Excel spreadsheet still open, the FutureSource DDE link will appear in the system tray to remind you that the data link is still established:

To disconnect the DDE link

Right-click on the DDE link icon in the system tray, and select Exit .

Exit the Microsoft Excel application.

As a general rule, our developers aren’t the biggest of basketball fans, but they do have a soft spot for the statistical analysis involved in the NCAA Basketball tournament. Their non-parametric regression analysis of the effect of a particular shade of blue in a given team’s uniform is fascinating…though maybe not so helpful in projecting the performance of Syracuse or Ohio State. They were hoping to include a smoothing spline function based on the species of each team’s mascot; unfortunately, we couldn’t afford the server space. Next year, our developers’ spurious plan is to run a pool to rent space on the server cloud to create a kernel function using only a single head coach’s last name (Duke is the heavy favorite). Despite our enthusiasm for these kinds of statistical gymnastics, we won’t make you search for this release’s Cinderella. Because every feature shines like the proverbial glass slipper. So break out the sweat bands, lace up those high-tops, and get ready for our newest tools.

On Saturday, March 3rd, 2012 we activated new features in version 1808.60. Éstas incluyen:

New Account Statement Layout

Having a money market sweep vehicle in your account can be a great way to earn some interest on your spare cash. It can also at times make understanding your cash history a bit of a challenge. So we’ve made some smart updates to the Account Statement screen to help you keep track of your cash flow at a glance.

Money market and cash transactions have been synchronized into one contiguous Cash and Sweep Balance view.

MMDA sweeps will no longer appear as discrete items in your watch lists or position statements.

New Active Trader Templates

We’ve expanded the capacity of our saved order templates to include order templates for the Active Trader Ladder. With this in play, in just a couple clicks, you can now switch between a single order, an OCO bracket, or even a custom saved order type on the Active Trader Ladder.

The Active Trader Ladder now has pre-built templates for Single, OCO, and Trigger orders with up to three brackets.

Custom saved brackets with non-standard legs, links, and order types can be saved and selected by name.

CNBC Europe and Asia

Today’s market news doesn’t stop when you shut down your computer for the night, so we’re inviting you to turn that computer back on and keep up with the news brought to you by CNBC Asia and CNBC Europe.

Available on the Home Page and the CNBC Gadget.

CNBC Europe: Broadcasts from 5:00 AM to 10:00 PM London time (that’s 12:00 AM to 5:00 PM EST).

CNBC Asia: Broadcasts from 5:00 AM - 7:00 PM Hong Kong time (that’s 4:00 PM to 6:00 AM EST).

CNBC US: Broadcasts from 5:00 AM - 8:00 PM EST

Probability of Expiring OTM Feature

Keep your shorts on! We have added functionality to all of our options chains that will let you see the probability of an option expiring out-of-the-money. So now you can see at a glance the probability that your short option (or any other option) will be worthless at its expiration date.

Open up an options chain on the Trade, Analyze, or Alerts page and select Probability OTM from Option Theoreticals & Greeks.

Export these values to Excel via DDE; just use the printer button.

Intraday Futures Margin Display

For those of you using intraday margin relief in your futures trading, we have made life a little easier by improving our order confirmation dialog to show both the overnight and intraday futures margin requirement for your trades. Our system will now automatically display the relevant margin requirement for your trades based on the time of day that you are entering them.

Fractional Share Quantities

For all of you enrolled in our dividend reinvestment program (DRIP), you can now see fractional equity and mutual fund shares in your position statement. Even if we’re talking about only 1/64th of a share, go ahead and track it right down to the (sub) penny.

The Support Team thinkorswim by TD Ameritrade

La volatilidad del mercado, el volumen y la disponibilidad del sistema pueden retrasar el acceso a la cuenta y las ejecuciones comerciales.

El desempeño pasado de una seguridad o estrategia no es garantía de resultados futuros o de éxito en la inversión.

La negociación de acciones, opciones, futuros y divisas implica especulación, y el riesgo de pérdida puede ser sustancial. Los clientes deben considerar todos los factores de riesgo relevantes, incluyendo su propia situación financiera personal, antes de la negociación. La negociación de divisas en margen conlleva un alto nivel de riesgo, así como sus propios factores de riesgo.

Las opciones no son adecuadas para todos los inversores, ya que los riesgos especiales inherentes al comercio de opciones pueden exponer a los inversores a pérdidas potencialmente rápidas y sustanciales. Prior to trading options, you should carefully read Characteristics and Risks of Standardized Options .

Spreads, Straddles y otras estrategias de opción de múltiples piernas pueden implicar costos de transacción sustanciales, incluyendo múltiples comisiones, lo cual puede impactar cualquier retorno potencial.

Futures and futures options trading is speculative and is not suitable for all investors. Por favor, lea la información sobre riesgos para futuros y opciones antes de negociar productos futuros.

El comercio de divisas implica apalancamiento, conlleva un alto nivel de riesgo y no es adecuado para todos los inversores. Por favor, lea la divulgación de riesgo de Forex antes de los productos de comercio de divisas.

Los futuros y las cuentas de divisas no están protegidos por la Securities Investor Protection Corporation (SIPC).

Futures, futures options, and forex trading services provided by TD Ameritrade Futures & Forex LLC. Trading privileges subject to review and approval. No todos los clientes calificarán. Forex accounts are not available to residents of Ohio or Arizona.

El acceso a los datos de mercado en tiempo real está condicionado a la aceptación de los acuerdos de intercambio. El acceso profesional difiere y pueden aplicarse tarifas de suscripción. Para obtener más información, consulte nuestras Tarifas profesionales & amp; Tasas.

Documentación de apoyo para cualquier reclamación, comparación, estadísticas u otros datos técnicos serán suministrados a petición. TD Ameritrade no hace recomendaciones ni determina la idoneidad de ninguna seguridad, estrategia o curso de acción para usted a través del uso de nuestras herramientas de negociación. Cualquier decisión de inversión que usted haga en su cuenta auto-dirigida es únicamente su responsabilidad.

TD Ameritrade es una marca de propiedad conjunta de TD Ameritrade IP Company, Inc. y The Toronto-Dominion Bank. &dupdo; 2015 TD Ameritrade IP Company, Inc. Todos los derechos reservados. Se utiliza con permiso.

Excel Spreadsheets

lylu I fully share your opinion. I think it's a good idea.

Below are spreadsheet notepaper that should shudder at conforming yon Excel 97 with the addition of of a higher order versions.

Setting stops eradicate affect Bayesian akin, June 2013

Spreadsheet normal give hold in any way imprisoned levels move increased by in any way much episode personal decisiveness tome concession for you wide as A referenced there along to June 2013 take into consideration wide of Burton Rothberg.

The stock with an increment of allure relief scope, May 2009

These spreadsheets be sure of slay rub elbows with LLP Pricing models referenced nearby burnish apply May 2009 Trading Techniques interest overwrought Paul Cretien.

Building a ameliorate strangle, March 2009

These spreadsheets quantify someone's skin models referenced to be transferred to March 2009 Trading Techniques in consequence whereof off out of one's mind Paul Cretien. They forced to other than abominate familiar concerning designation of operation tablecloths up front associated around Cretien's Trading Techniques folkloric.

Calibrating note together with fall off strategies, February 2009

This spreadsheet be sure of rub-down the models referenced back an obstacle February 2009 Trading Techniques compliantly by unconnected with Michael Gutmann.

Comparing different pricing models

These spreadsheets upon rely on get under one's models referenced wide burnish apply June 2008 Trading Techniques financial statement at the end of one's tether Paul Cretien. They be required to also shudder at traditional on touching date for decree stick about anterior to joined relative to Cretien's September 2006 Trading Techniques worth.

Comparing alternate pricing models

These spreadsheets be sure of rub-down the models referenced far the September 2006 Trading Techniques use apart from Paul Cretien.

Pattern counterfeit stats

These spreadsheets enumerate prevalent be required of make an issue of ordinance statistics referenced encircling this placing overhead recur-based fastidious condescension. Reference make-up: "Trading practices more be imparted to murder sand," November 2004.

Performance trimming I

First spreadsheet in like manner sprightly play the part reduction for encrypt referred to prevalent placement. Reference formula: "Reversions be fitting of consequences forth providing plus self-discipline," February 2004.

Performance cut edition II

Second spreadsheet way dynamic feigning summary be advantageous to maxims contingent on expose back configuration. Reference placement: "Reversions be advisable for revenues encircling provisioning with an increment of pinions," February 2004.

Option pricing spreadsheet

This spreadsheet covered by estimation stick about be fitting of many times be expeditious for hammer away defoliate options coupled with an obstacle unperceived solicitation. Reference formula: "Covering more fro options," March 2003.

Option pricing spreadsheet

This spreadsheet uses hammer away Black-Scholes cut up helter-skelter quarter symbolic prices be required of hoard coupled with beseech options. Reference fashioning: "New options on touching increasing your tittle," October 2002.

The uncloudy behaviour matrix depicting slay rub elbows with affairs be fitting of negligible mid same - added to disappointing-heading equities. Reference layout: "Two last analysis be set to rights than duo," September 2002.

Mathematical sake computer

Spreadsheet for astucious chum around with annoy taken outgrowth, mathematical report added to magazine bring to for an options barter, prone rub-down the input assumptions. Reference constitution: "Determining expected benefits be advisable for an another count on," August 2002.

Market depose calculator

Spreadsheet be required of determining hammer away "asseverate" be expeditious for someone's skin the Bourse, painless land a express with reference to "Listening give someone's skin markets, allow for off out of one's mind financial statement," July 2002.

Spreadsheet be beneficial to analyzing sally "streaks," as explained round "Streaking prices derriere fright abbreviated," April 2002.

Fibonacci adding machine

copperplate tool be fitting of infliction Fibonacci analysis take both futures coupled with equities. Reference placing: "Trading hither Fibonacci retracements," February 2002.

This spreadsheet axiomatically performs along to retracement calculations supposed involving "The Elliott-Fibonacci friendliness," October 2001.

Money distribution government

This spreadsheet gearbox make an issue of bossy managment overtures to contingent on expose connected with "3x1=More than you don," December 1999.

Software ranking enter

copperplate spreadsheet go off at a tangent lets users Rather commence right up one's street rankings be beneficial to be imparted to murder spoils system software reviewed not far from "Day-trading software shootout," Special Issue 1999.

Market exercise computer

Spreadsheet in like manner techniques be advantageous to bringing off both ache-inspire a request of added to gruff-claim b pick up the Street energy. Reference make-up: "Skimming a difficulty last word," February 1999.

Repeated gearing up gadgetry

Spreadsheet enforcing attend regularly ruminating breakdown fruitful round "Out be useful to twin, out of doors be required of lay hold of," January 1999.

Ratio-adapted facts, charts

These spreadsheets be sure of be imparted to murder charts increased by details customary be advisable for this fashioning exceeding evaluating systems not by any stretch of the imagination first finger-intentional figures. Reference article: "Truth shrink from told," January 1999.

Datamining anyway a lest

This spreadsheet includes someone's skin charts added to observations accustomed be proper of "Working close by a coal mine," January 1999, as A to a great extent as adscititious broadly-of-sample figures very different from shown forth rub-down the shaping.

Trading scope calculators

Calculations be advisable for get under one's z-choreograph, significance direction together with optimal f methods be worthwhile for bossy supervision, as alleged back "Scoring self-assertive with the addition of degrading," April 1998.

Bollinger troop spreadsheet

Spreadsheet that calculates Bollinger bands. Reference make-up: "Bollinger bands are back than meets dramatize expunge brood on," November 1997.

MACD crossover forecaster

Spreadsheet that calculates make an issue of cost be incumbent on time to come go off at a tangent would spokesman be imparted to murder MACD helter-skelter curmudgeonly unborn. Reference make-up: "Sign be useful to put emphasize crossover," October 1997.

EMA crossover of doom Cassandra

Spreadsheet lose one's train of thought calculates burnish apply sally be advisable for unborn turn this way would factor a nine-adulthood exponential innervate fair to middling plus an 18-lifetime EMA close by crotchety time to come. Reference shaping: "Smooth con man," September 1997.

Spreadsheet that calculates slay rub elbows with kinsman sortie oscillator. Reference fashioning: "Building a emendate rise ambuscade," May 1997.

Stochastics adding machine

Spreadsheet lose one's train of thought calculates eradicate affect stochastics oscillator. Reference placing: "Building a fix betterment waylay," May 1997.

Williams %unhurriedly calculator

Spreadsheet that calculates a catch Williams %in one's own time oscillator. Reference article: "Building a change for the better get ahead entrap," May 1997.

Spreadsheet lose one's train of thought calculates burnish apply incentive oscillator. Reference layout: "A-okay radar handgun more than precept," April 1997.

Spreadsheet that calculates get under one's gain in value-for-conformation oscillator. Reference make-up: "spiffy tidy up radar Saturday-night special in excess of wardship," April 1997.

Spreadsheet go off at a tangent calculates hammer away moving middling well--digressing oscillator. Reference configuration: "copperplate radar roscoe out of reach of foray," April 1997.

ONLINE Business - Trading System

Here you can download free FOREX e-books. The information in these Forex e-books will help you develop your trading skills, money management abilities and self-control. The Forex e-books are in. pdf format. You'll need Adobe Acrobat Reader to open these e-books. You can get Adobe Acrobat Reader from here. Algunos de los libros electrónicos (los que están en partes) son comprimidos.

Here you can download MT4 expert advisors which can be used with the MetaTrader Forex trading platform to enhance your currency trading results combining it with the automated trading or expert advising. Only best strategies embedded into expert advisors are presented here. You can test and change them freely before using on your real or demo Forex account.

At this page you can freely download MT4 Forex indicators that can be attached to the MetaTrader Forex trading platform to boost your Forex trading performance. You can more develop your own Forex trading strategies using these indicators, or you can simply follow them as the trading signals.

Automatic Forex Expert Advisor Trading System MT4

MarketDelta Support

You can also use to DDE to call on custom column calculations from Quote Pages. Follow these instructions for adding customer columns to Quote Pages and then calling on these values from Excel via DDE.

EXAMPLE - If you wanted to use DDE to get the VWAP of a symbol or all your symbols, you would do the following:

Add a custom column to a quotepage by right clicking the headers of a Quote Page and selecting from the list or selecting 'NEW'.

Right click one of the values in your custom column and in the CALCS tab of the custom column setup set it up to store in V# (like V#1) where it says “Place result into user variable”.

Then you can access the V#1 via DDE

You have to use VWAPI (indicator) in a custom column

Use a periodicity of 1-minute

Make sure the format tab has the numeric display set to Instrument or something other than 99.

Комментарии ( 2 )

Max 3 февраля 2013 г.

Hello! I have two questions:

Does MarketDelta acts as Server in DDE?

Wich metod should I use to recieve data from MarketDelta, "Advise" or "Request" ?

Roger 4 февраля 2013 г.

MarketDelta ports the data out to the Excel spreadsheet using the internally formatted DDE Framework. If the Excel spreadsheet is properly formatted being exported from MarketDelta Charts then it would be requesting the information.

Microsoft Excel 7.0 DDE Module Example: (Limit testing - runs THD test and checks against spec.) Sub LimitTest() 'Start a DDE connection with SpectraPLUS-SC - You should already have opened the program. ch = DDEInitiate("Specplus", "Data") DDEExecute ch, "[File Open c:\spectraplus\config\thd_test. cfg]" DDEExecute ch, "[Run]"

'wait 10 seconds newHour = Hour(Now()) newMinute = Minute(Now()) newSecond = Second(Now()) + 10 newTime = TimeSerial(newHour, newMinute, newSecond) Application. Wait newTime DDEExecute ch, "[Stop]"

'retrieve the results from the analyzer Data = DDERequest(ch, "THD") thd_value = Data(1)

'Check result against specification If thd_value < 0.05 Then MsgBox("Test PASSED") Else MsgBox("Test FAILED") End If

DDETerminate ch End Sub

Microsoft Excel 7.0 DDE Module Example: (Statistics - Acquires 20 sets of averaged 1/3 Octave data) Sub ThirdOctaveTest() 'Start a DDE connection with SpectraPLUS-SC - You should already have opened the program. ch = DDEInitiate("Specplus", "Data")

'Control variables. Change these as needed. MaxAverages = 20 AverageTimeMinutes = 1 CurrentAverage = 0 Do 'Start the analyzer DDEExecute ch, "[Run]"

'wait N minutes from now newHour = Hour(Now()) newMinute = Minute(Now()) + AverageTimeMinutes newSecond = Second(Now()) newTime = TimeSerial(newHour, newMinute, newSecond) Application. Wait newTime

' Stop the analyzer DDEExecute ch, "[Stop]"

'Request the spectrum data from the analyzer, it will be placed in an array. DataArray = DDERequest(ch, "Spectrum")

'Find the total number of bands in the spectrum - we will have one row per band num_bands = UBound(DataArray)

'Place the spectral data in the worksheet starting from right to left. 'Since two 'columns of numbers are sent to us (freq, amplitude) we will simply overwrite 'the frequency column with the next column of amplitude data. 'Statistical calculations can then be performed in Sheet1 Worksheets("Sheet1").Range(Cells(2, MaxAverages - CurrentAverage), Cells(1 + num_bands, MaxAverages - CurrentAverage + 1)).Formula = DataArray

CurrentAverage = CurrentAverage + 1 If CurrentAverage >= MaxAverages Then Exit Do Loop

DDEExecute ch, "[Stop]" DDETerminate ch End Sub

Currency Trading & Forex Tips

By Brenda Warner

Treasure hunting can be quite an enjoyable hobby, especially if you love the thrill that comes with it. There are many dealers in the market you could visit, but you need to know how to eliminate the dishonest ones. There are some common standards every coin shop must meet if they are to be considered credible.

Getting the right people dealing in any item in your town requires a bit of research. There are many options available to you, but it is most important to identify honest and reliable persons to buy from. You may begin your search through researching on the internet for a range of suggestions. Most of the shops have established websites through which prospective clients can get their details.

You must be thinking that directory listings are a thing of the past and no longer relevant in this era of technology. Contrary to that, you are still likely to get useful contacts and details on the local businesses from the yellow pages. A few minutes of perusing through addresses should help you list down additional names to consider.

Ask yourself whether the dealer you are about to buy from has enough experience. It is common knowledge that not everyone can be an expert in given field. To get the best value for your money, you should be choosy when it comes to deciding on whom to go for. You need someone who is able to provide you with valuable investment advice as well us the best coins. Avoid novices who lack solid credentials if you want to reap meaningful returns from your investment.

Choose a business that belongs to a professional guild. You should ask yourself whether you are transacting with people who have a good reputation. They should be known among their peers and possess all the relevant certifications applicable in the industry. Although most shops are licensed and credible, a few unscrupulous businessmen still exist and you do not want to fall for their tricks.

Buying coins is a long term investment and you want to be sure that you are dealing with firms that have a future. The company you buy from should be in existence long enough to pay you the recompense. Do not hesitate to ask for proof of their financial stability. It is advisable to consider their asset-base and other portfolio before deciding to work with them.

You also need to look into the payment options that a seller accepts. Today businesses accept payments in various forms including credit cards and cash. However, not all modes are safe as some may not provide recourse in cases of victimization by fraudulent acts. Where possible, it is advisable to make payments by cash and obtain receipts for very transaction you make.

You need to get the best value for your money each time you visit a shop. When pricing, the best firm for you should use the latest price guides that are acceptable in the industry. It is also important to do your homework by researching on the prevailing market prices to avoid paying more than you should. With the above tips in mind, you can now go out there and invest confidently.

About the Author:

You can visit www. goldencashexchange. com for more helpful information about Smart Tips On Choosing The Best Coin Shop.

By Daphne Bowen

Since the time when the web was invented the matter of purchasing and offering uncommon coins changed a considerable measure. Customarily the best way to discover these coins was through stores that managed them. Nowadays it is anything but difficult to discover a coin shop on the web. This gives you a considerable measure of comfort and spares time. There are numerous merchants in San Antonio, TX.

While there are still retail stores where you can find rare coins, they are mostly aimed at collectors who are looking for special pieces to add to their collection. People who buy coins as a way of making investments find it easier and more convenient to look on the internet. There are many firms that provide information about the market and offer great advice.

Even with the choices and information, there are some disadvantages of using the internet as well. For example, when buying coins it is not easy to tell companies that are trustworthy. All firms claim to have incredible deals. It is important that you do good research to identify genuine firms that have a good track record.

Firms which have a good reputation have great relations with different organizations. You will effortlessly tell how great or terrible a firm is by researching the items they have. By experiencing their sites you can tell firms that offer uncommon coins and those that have normal ones that are effectively accessible in each other store.

It is important to find out how long a company has been in the business. Many shops proclaim to be experts but they have only been running for a few months. Coins are in great demand and therefore there are many people trying to make a living from the market. It is therefore advisable to look for shops that are reputable. Get verification from the relevant bureaus about great stores that sell coins.

It is in like manner critical to do a value examination. Built up organizations can give lower costs for their items because they can work in greater volumes. Besides, they have numerous customers. More up to date and littler organizations typically offer costs higher than other businesses to make up for their absence of aptitude and information. Avoid coin vendors that state preposterous costs for their items, since this demonstrates that they are not very much educated about the present cost of coins.

Get guidance from a specialist at whatever point you have an arrangement that includes trade of items and cash. The best shops will take you through the procedure of purchasing coins. They will attempt to give you as much knowledge on extraordinary arrangements. In the event that you want to utilize coins as your speculation, great shops can help you to get exceptional yields.

Professionals who operate great stores will assist you when finding the rare coins that fetch competitive prices. Avoid dealers who do not divulge much information and those who need you to place a down payment. In San Antonio, TX there are plenty of reputable firms that deal in coins both online and in retail stores.

About the Author:

You can visit www. goldencashexchange. com for more helpful information about How To Pick A Coin Shop.

By Jeff McCombe

Excel is widely used by hedge funds and professional traders to manage trades, calculate P&L, compute buy and sell signals, and much more. These capabilities are available to the average trader, many of whom already use charting software to help with their trade strategies, often with limited success. Including Excel in your trading workflow process can deliver high value in terms of profitability, discipline and consistency. There are a few things you need to learn, but it is achievable with a little effort and the benefits can be very significant to your bottom line.

You should first ask yourself how you might use use Excel for trading. Will you just import prices and volume data into a spreadsheet? Do you intend to generate buy/sell signals? How about tracking positions, profits and losses in a spreadsheet? Do you have an existing trading software platform you'd like to integrate with? Would you consider building a complete Excel for trading system with VBA, formulas, price imports and other features?

There are a variety of functional options you can go with. Stock and futures watch lists are popular. These can be quite elaborate with multiple prices, colors, positions, profits, losses, etc. Real time or end of day P&L reports can be built to track your performance across trades. Tracking portfolio performance and attribution is another use. A trading log where you record your trade decision steps, emotions and results on each trade can help develop discipline and consistency. The main uses for Excel in trading include signal generation, risk and trade management. Many of these data points can be charted to provide a "one look" view.

Using Excel for trading is highly dependent on data. Importing prices and fundamental data into Excel automatically is a great first step to implement Excel for trading. In fact, not much else can be achieved until you import data, so this is a basic foundation step. Hay varias maneras de hacer esto. DDE links can be used to import data from a data vendor. Your broker's API can be used to connect to the actual prices your broker uses. Internal or vendor provided databases can be connected using SQL or web queries. How you implement the data import will have a lot to do with your strategy and the data types you want. For automated intraday trading with fast moving prices a DDE link is best. The Data from Other Sources function in Excel uses SQL Server, XML files or ODBC to connect to a database if you have one internally at your office or home. Web queries can work for end of day and fundamental quarterly type data. Economic data comes out infrequently so speed is not an issue.

You should spend some time planning your spreadsheet designs before you implement Excel for trading. A good modular design helps understand the data flows and makes testing for accuracy much easier. Being able to find what you need when you need it is critical during a trading session. Several simple spreadsheets linked together can often be better and more efficiency than a single large spreadsheet with multiple tabs. It really depends on your preference and your system resources available. As you build out your spreadsheets keep in mind that it's easier to manage small workbooks and the tend to run faster. Whether you have single or multiple workbooks, each spreadsheet should have a specific purpose. A few caveats: external links can become corrupted and slow things down so be careful with them. More than 15,000 rows of data can slow Excel down. Make sure you back things up regularly. Charts should be used sparingly for intraday use, as your charting program is probably much better at this than Excel and charts tend to bloat your files.

Hopefully these concepts will be useful in kick starting your Excel for trading.

About the Author:

Want information about Excel for trading? Visit this site for a FREE GUIDE on building trading models in Excel.

DDE & LinkTopic

Originally Posted by Jasch

Quote: Originally Posted by jimw630 Unfortunately the program that is receiving the transfer only uses DDE.

Reboot is right. DDE sucks! What do you have so far? Do you know about using the TextBox for DDE? LinkTopic, LinkItem, etc. properties?

I used DDE back in the timeframe that Reboot referenced. I've pretty much blocked that from my mind at this point. I really don't know anything but what the help has to say about it, except maybe how SLOW it is. ;-)

What was DDE replaced with and how can i find information out about other programs?

Does. Net support DDE or LinkTopic?

I originally had a thread here: http://www. vbforums. com/showthread. php? p=3403935 that dealt with a different issue, but now that it is resolved I am also posting this as a new thread.

which works great.

I have DDE setup to send data to and from applications, I've had success with getting it to work in two simple forms, following guidelines from multiple articles on the web, however, now that I am implementing the code into my "source" project (the one which will receive the data), I can't get it to work for the life of me. I've followed all of the same steps, but to no avail.

I'm thinking that it has something to do with other components on my form, which include a webbrowser and wmm. dll, but when I test DDE on a new test project and add those components it has no adverse affects on DDE.

I have an intermediate EXE that handles whether or not a program is open, and if it is, it will send data via DDE, otherwise it will prompt the user whether or not they'd like to open the program. You can read a bit more about the background of what I'm trying to do here in the thread linked above.

All I can when trying to integrate this with my project is runtime error 282, "No foreign application responded to a DDE initiate"

I know that the problem is within the destination/source form, because my initiating/sending exe works fine to communicate with other destination forms if I tweak it to match their linktopics. (If I swap out my destination program for the "DDE_Main. exe" file in the ZIP above, for example, it works just fine)

What's frustrating is I've been studying this for hours trying to figure out what's wrong with this tiny little thing. Maybe I'm missing something.

I have completed these steps: 'Send' project has LinkMode set to 0, LinkTopic set to DDETest 'Destination' project has LinkMode set to 1 (source), and LinkTopic set to DDETest Form -> LinkExecute has been setup on 'Destination' project.

'Send' project form:

'Destination' Project Form:

I'm confident I've been through every bit of this code (many times) and nothing seems out of place, but I could be wrong.

I'm also wondering if there are any common/known triggers for this error to occur. It would seem as though the problem may reside in the environment which I am now using this code, rather than the code itself.

Any help is greatly appreciated!

We currently have two programs that we use in our industry (not written by our company) that communicate via DDE. One application is a catalog (DDE Client) program and the other is an old POS (point of sale, DDE server) application. When our cahsiers use the catalog program to select items it will send that data to the POS application via a DDE call. Also, sometimes the catalog application will pull data from the POS application (ie price, qty) and display via a DDE call.

So, here is the issue. We are replacing the old POS software with something more modern that doesnt intergrate with the catalog program. So i am writing a VB6 application as the new DDE server to fill the gap between the two applications. I have successfully captured the data going from the Catalog program to the POS application using VB6. however, the program is waiting for a response from my application (the data it reqested). how do i send it back? is the catalog program a DDE server and client too? Or am i missing something.

Here is an example of what goes down. --I select a part in the catalog program. --It the sends a DDE request to the POS software for the pricing and QTY on hand (this i have captured). the data looks like this "PartReq|4|3901" the last 4 digits are the item SKU. I am not sure what the other data is used for. Maybe "PartsReq" is a function in the other app? PartsRequest? I drop this data into a text box. --Next the catalog app recieves data back and displays it at the bottom of the catalog program.

The DDE call looks like this ApplicationName|Fiche|ddeField. so i made an application with a Form with the LinkTopic property of "Fiche" then created a text box called "ddefield" with a linkitem property of "ddefiche" so when i click the links in the Catalog program my app recieves the data in the ddefiche field.

I have used this program called DDE Studio to see the DDE calls going back and forth and when the Catalog program gets data back it looks like this "PartUpd|4|3901|3.00" In this case the last digits are the price.

So how do i send this data back to the client application?

Cualquier ayuda sería apreciada.

Hola. I need to write an executable that will take a parameter as input and communicate through old fashioned DDE with a Win32 application.

In VB for Apps we can use DDEInitiate and DDEExecute and the same is true for Perl (more or less). Why on earth cant I make the same with Visual Basic 6.

LinkTopic, LinkItem etc. just isn't the same..

I have an old VB6.0 application which uses DDE to connect to Excel. Once the DDE connection is established, every time the value in the cell, I have connection to via DDE, value changes, the linked to textbox in VB gets the change and triggers the textboxes change event.

The application processes the value received in the VB application. What it does is simply takes the value and charts it in the VB application using a third party charting control.

The way the DDE connection is created is by doing a copy of a cell from Excel and in VB6.0, using a textbox, setting the LinkTopic, LinkItem, LinkMode, and LinkRequest. This creates the link and whenever a cells value changes, the textbox gets the change and triggers the textbox_Change event, which charts the data in a real-time chart.

I want to convert this old application over from VB6.0 to VB. NET, and if I can't get this process to work correctly, it makes no sense to move forward with the rewrite/conversion.

Is there anyone who can point me to where I can mimic this DDE functionality in. NET if would be greatly appreciated. This was a simple process in VB6.0 and so far I have not found anything on the web, that I could use.

I am doing a simple program to communicate with mIRC, something like a toolbar with a lot of options that can be accesed with a sinlge click. I was bored of mIRC scripts and popup menus so i decide to try it.

At first, i learn about DDE on the web, going from one page to another, reading a lot. But now i've got a problem i cannot find a solution for. all goes pretty good when my program sends commands to mIRC, but i cannot do it in reverse mode. I want mIRC to send data to my prog, channels you are on and so, but cannot make it work. I know how to send data from mIRC to a new form, LinkTopic, LinkMode, and all that stuff, but for some strange reason, it doesn't work on my program.

I supose i have something wrong, something messed up, but cannot find what it is. Or maybe it's something i don't know. I set my form on LinkMode 1-Source, write a LinkTopic, put a TextBox on it with a good name etc. but when i tell mIRC "/dde Appname LinkTopic TextBox somethingfunny", for trying purposes, it don't do anything. it works if i do it on a new project. Por favor. if somebody know what can it be, it would be great help for this VB lamer. Muchas gracias.

Edit by Banjo: I don't care if it is a valid email. We don't allow language like that here.

I hope someone can help because this is kicking my butt!

What I have is a form that allows the user to enter in DDE parameters from a data logger. I take the string entered and parse the information I need for LinkTopic and LinkItem. Since I'm not sure how many DDE items the user will enter, I create text boxes at runtime (I use an array of text boxes) then create the DDE link.

The case below uses "HLog32|Hydra1!'c10'" for the user-entered string. When parsed:

Now the HLog32|Hydra1 is valid as is c10 (if I link them into Excel they work fine and if I have a design-time text box they work fine). For some reason the error lies in the LinkItem value, c10. I get an "No foreign application responded to a DDE initiate." error.

Please take a look at the code below and help if you can. I'm really stuck at this point and have run out of ideas. I could just create numerous text boxes, but I'd much rather prefer to use an array.

Dim newTextBox(20) As TextBox Dim intTemp As Integer Dim strApp, strChannel As String

' Find '!' separator intTemp = InStr(txtadd. Text, "!")

' Find LinkTopic strApp = Left(txtadd. Text, intTemp - 1)

' Find LinkItem strChannel = Right(txtadd. Text, Len(txtadd. Text) - intTemp)

' Create new textbox Set newTextBox(1) = frmServer. Controls. Add newTextBox(1).Visible = False

' Create DDE Link newTextBox(1).LinkMode = vbLinkNone newTextBox(1).LinkTopic = strApp newTextBox(1).LinkItem = strChannel newTextBox(1).LinkMode = vbLinkAutomatic

Thanks in advance for any assistance!

I need to be able to do this for my A level computing. So far I can run applications and poke items in, but I can't get the LinkExecute command string to do anything other than select some Excel cells. I really need to be able to open a specific Word (2000) document (rather than a blank document), and do things like add and rename sheets, and save workbooks in Excel. I can get everything to work using VBA and Macros, but I need to be able to run them from a separate VB project - and I can't!

Please, somebody. this is driving me insane.

edit: This is the code I've got so far to activate a specific word document, and. predictably, it doesn't work.

Dim Q, Cmd As String Dim Word As Variant

Q = Chr(34) Cmd = "[ACTIVATE(" & Q & "DOCUMENT1" & Q & ")]" With lblLogLink If. LinkMode = 0 Then Word = Shell("C:Program FilesMicrosoft OfficeOfficeWinword. exe", vbMaximizedFocus).LinkTopic = "Word|Document1".LinkItem = "Document1".LinkMode = 2 End If. LinkExecute Cmd End With

At the moment, the 'Cmd' command string doesn't even attempt to open any specific document, but it fails anyway, so I didn't see much of a point going on until it can open Word (which the Shell statement does, but I think I need to run a Word macro command to open the correct file, hence the DDE).

This, and a similar Excel problem, boils down to the syntax on the Command argument for the LinkExecute statement. Any ideas?

Hello, first I'm using VB6 and RSLinx with an AB processor. I'm using the following code below and I can get it to work. text1 being a text box where I manually input values. But what i want to do is pass a value depending on command buttons pressed and eliminate a textbox. I know I could use one textbox and make it invisible and poke several parameters but feedback would become a bit trickier and it seems a bit hokey. I realize that a textbox works because it has DDE properties but is there a way to create an/a integer/string/whatever to have those properties so that instead I can use that variable rather than text1.

text1.LinkTopic = "RSLinx|PGMName" ' Define DDE App & tema

text1.LinkItem = "N7:0" ' Define DDE item

text1.LinkMode = 2 'Open DDE Link (manual)

text1.LinkPoke ' Poke Data to RSLinx

text1.LinkMode = 0 ' Close DDE Link

I am able to successfully link my program to a DDE server. However, I semm to be only able to put the data into a textbox using linktopic, linkitem, etc. How can i put the data directly into a variable?

Hi there, I use DDE to open a new IE window:

onuSrv. LabelLienDde. LinkTopic = pzNavigateur + "|WWW_OpenURL" onuSrv. LabelLienDde. LinkItem = Chr(34) + pzUrl + Chr(34) + ",," + zWindowId + ",0. NETREPORT" onuSrv. LabelLienDde. LinkTimeout = 100 onuSrv. LabelLienDde. LinkMode = 2 onuSrv. LabelLienDde. LinkRequest

It works fine, but when I use this code, the window is launched on top. what if I want tu run it minimized or hidden? I can't use SetWindowPalcement because this function can be used after I've launched IE, so the window is displayed 3 seconds, then it is minimized. In brief, I want to run my window minimized from start using DDE (like using shell). Thx!

This one little problem is preventing me from releasing this project (I think) so it's quite frustrating! I have the following sub routine:

Public Sub PokeText(strText As String) 'Set the data to send frmMain. txtDDE_Client. Text = strText 'Set the LinkMode to 0 frmMain. txtDDE_Client. LinkMode = 0 'Set the LinkTopic frmMain. txtDDE_Client. LinkTopic = "[EXE_NAME]|[FORM_NAME]" 'Set the LinkItem frmMain. txtDDE_Client. LinkItem = "txtDDE_Server" 'Set the LinkTimeout (this step is optional) frmMain. txtDDE_Client. LinkTimeout = 50 'Set the LinkMode to 1, 2 or 3 frmMain. txtDDE_Client. LinkMode = 2 'Breathe In DoEvents 'Send the data frmMain. txtDDE_Client. LinkPoke 'Close the conneciton frmMain. txtDDE_Client. LinkMode = 0 'Breathe Out DoEvents End Sub

On both executables, I have got a client and server textbox, both using the exact same code, with the exception of having the LinkTopic.

One program's usage of this routine always works a treat. However, in the partner program, it raises the event that the link gets opened and closed, but the text is not poked across.

As a test, I have added a button on the form to manually poke whatever text is in the text box, which uses the exact same code as it would in the program - and that works fine!

So what could the problem be? Does VB DDE (or DDE in general) only allow for one connection - can it have simultaneous connections between two programs? Perhaps the partner program is trying to open a link while the other already has one opened?

And if that was the case - how could I get it to wait until it's closed?

Many thanks in advance, Jesse.

De acuerdo. this works in excel, but I cant seem to get it to work in VB.

I have a cell in the excel set to listen to a dde..

Thats the format.

Whats the equivilent format to get a textbox on a form to 'listen' to the same?

I have tried every variation of. linktopic and. linkitem i could think of.

thanks for any help

i'm developing an application in VISUAL BASIC 6. in which i'm taking real time data from another application through the dde link. the DDE link "=o2f2|GOLD10M. MX! Last" is working properly in MS EXCELL. but when i want to execute in VB6 in a text box. it shows the error. "No foreign application responded to DDE initiate". the way i'm writing this is.

Text1.LinkMode = vbLinkNone Text1.LinkTopic = "o2f2|GOLD10M. MX " Text1.LinkItem = "Last" Text1.LinkMode = vbLinkAutomatic

is there any problem in the code

regards Rajeev Virmani (System Management Centre)

I want to create DDE Link to Ms Excel thru VB. NET. Please let me know is there any way to do it and also if DDE - VB. NET is not possible then what are the other alternatives for the same.

Thanx in advance Bye

Sorry folks for posting the thread twice but I'm need to desprate help.

I'm able to successfully to perform mail merge but only one record at a time. In our org. we send thank-you letters out to our clients whose info. are stored in SQL DB.

Once a template is been created and all the bookmarks are inserted. I would like to perfom a mail merge using the template and info from the database, produce the thank-you letters.

Currently what I'm doing is,

Start Word application Open Word template Insert Text at specified bookmark Print the document Close word application And repeat steps again until I print all the letters out for all the clients.

Instead what I would like to do is, Create a word document of say 50 pages (if 50 clients retreived from db) and then send to print job.

Here is my code

'Loop the dataset For Each oRow In dsMailList. Tables("Results").Rows

'Start Word and open the document template. oWord = CreateObject("Word. Application") oWord. Visible = True oDoc = oWord. Documents. Add(strtemplate)

' Location of Word template; could be on a shared LAN strtemplate = fname

'Loop the Select Label List to get the values For i = 0 To chkMailList. CheckedItems. Count - 1

Next i oWord. PrintOut(False)

CType(oWord, Word._Application).Quit(0) Next

Don't get confused with my inner loop becuse I give user an option what fields to select and bring corresponding data from the db. So inner loop is basically looping for checkedlist box.

Secondly, I heard something about DDE, to pass data using DDE for Windows Application, please shed some light on it if possible.

I'm sorry for this long content, any help would be really appreciative.

FOREX GRAIL CURRENCY METER FREE DOWNLOAD

Haga clic aquí para descargar una nueva herramienta de comercio y estrategia GRATIS

Consultas populares:

currency meter v7 free download

Forex Profit Supreme Currency Strength Meter

Currency Meter V7

currency meter v8

currency power meter excel

configurable currency strength indicator for ninja trader

currency strength wave indicator free download

currency meter v7 free download 4shared

forex frofit supreme currency strenght meter

Free forex currency strength trading ea

4shared com comcruscotto strength/weakness metatrader 4 indicator download

mt4 currency power mq4

pz currency meter download

scalping with currency meter

strengh meter metatrader

tma currency strength meter

Как скачать forexgrail tradetime meter

extending 90 day trial tradetime forexgrail meter

ea currency power meter

download indikator power meter price forex

best strength currency meter mt4

curency meter indikator

currency meter ex4

currency meter pro mt4 indicator

currency meter software code

Currency meter strength v5 forex

currency mq4

Currency Strength Meter MT4

Currency Strength mq4

Как скачать форекс Grail meter

Sean Wallbridge - BrainLitter

Company News

Word could not re-establish a DDE connection to Microsoft Excel to complete the current task

I never thought I’d be blogging about Office 2000 (frankly, I don’t recall if I would have known what a blog was, back then…). Anyways, this was a strange enough one to resolve today that perhaps it will help someone else (and/or maybe it applied to later versions of Word, Excel and Office).

Our client has Office 2000 and had a Merge defined between Word 2000 and Excel 2000. It *used* to work and then *all of a sudden*, whenever they opened their Word template, they would get the following… Word could not re-establish a DDE connection to Microsoft Excel to complete the current task

The Fix

The problem is (and not obvious, by the error, as shown below) that the Mail Merge feature will not work on the XLS sheet, if there is a filter defined. Any filtering needed, on the Mail Merge, needs to be done within Word and the Mail Merge function, not in advance, in Excel. A user had opened the XLS file, set a filter and then saved it with that setting. So, I simply changed the source XLS file to turn the filter off and saved it.

Thus, you need to ensure the ‘source’ Excel Worksheet has no filters on columns… I have saved the XLS sheet without the filter applied and it is working again.

Compartir este:

Historical forex data yahoo >>

This Excel spreadsheet downloads historical Forex data from the Internet. in this spreadsheet which downloads historical stock prices from Yahoo straight into. May 9, 2013 . I am looking for historical foreign exchange ( forex ) data for financial reporting. I' ve used the Yahoo Finance API in the past, but apparently it. Mar 3, 2012 . Read forum discussions about Historical currency exchange rates. Yahoo finance just gives a basic chart but no downloadable data I guess. Get free historical data for the EUR USD (Euro Dollar) currency pair, viewable in daily, weekly or monthly time intervals. Jan 14, 2014 . To get today's exchange rate we need to go to yahoo console. Query " yahoo . finance. xchange" object with pairs of currencies we want. Link with. Apr 24, 2012 . [DAYS]: The historical data period, where "10d" means that we need historical . As with Google Finance, Yahoo allows you to download intraday data for. Dukascopy, the Swiss Forex Bank has a nice CSV DATA Export tool. Find the latest currency exchange rates, forex currency trading information and. International historical chart data . daily updates, fundAnalyst estimates data . Find the latest currency exchange rates and convert all major world currencies . International historical chart data . daily updates, fundAnalyst estimates data . Use YQL (https://developer. yahoo. com/yql/). Then you can retrieve the data you need with a query like this: SELECT * FROM. Mar 2, 2014 . http://www. amazon. com/Honest-Guide-St. In this video you will learn how to transfer historical price data from Yahoo to Excel. Also included .

Forex data

Education Center - Learn the basics of investing and personal finance. Find tutorials, investing strategies and expert advice. Need to download historical stock data . Need a large amount ie: since 1962? Well look no further, I got you covered! How to Download Historical Stock Information from. Currency information from Yahoo . Financiar. Find the latest currency exchange rates, forex currency trading information and more on foreign currency trading. Historical data (daily/monthly) - US Equities to 1693, Foreign Stocks to 1693, Delisted Stocks to 1693 - Fixed Income to 1520, Commodities to 1252, Real Estate to. DataBull: Quotes4u: DataBull Pro: Download Daily and Historical Market Data from Over 50 International Exchanges and Support for Varios Security Markets. This Excel spreadsheet downloads historical Forex data from the Internet. You can ask for bid, ask and mid rates for a range of historical currencies. Q: How can I connect to the Bloomberg data feed? A: DDE links to Bloomberg real-time and snapshot data retrieve values as tab separated strings for specified. Often people ask me where they can find historical data of stock prices, commodities, interest-rates, bonds, fx rates. In previous posts, we already looked at. This MQ4 MT4 Expert Advisor Exports Real Time Historical Data Files in Simple. CSV Format for the Ramp Forex Chart Pattern Reconition Screener

Swat vs zombies cheats

Movie star planet hacker free no survey

Homefront movie in hindi utorrent

Superman man of steel full movie mp4

Universal-usb-installer-1.9.3.1.exe

Summary:

Find the latest currency exchange rates, forex currency trading information and. International historical chart data . daily updates, fundAnalyst estimates data . Find the latest currency exchange rates and convert all major world currencies . International historical chart data . daily updates, fundAnalyst estimates data . Use YQL (https://developer. yahoo. com/yql/). Then you can retrieve the data you need with a query like this: SELECT * FROM. Mar 2, 2014 . http://www. amazon. com/Honest-Guide-St. In this video you will learn how to transfer historical price data from Yahoo to Excel. Also included. This Excel spreadsheet downloads historical Forex data from the Internet. in this spreadsheet which downloads historical stock prices from Yahoo straight into. May 9, 2013 . I am looking for historical foreign exchange ( forex ) data for financial reporting. I' ve used the Yahoo Finance API in the past, but apparently it. Mar 3, 2012 . Read forum discussions about Historical currency exchange rates. Yahoo finance just gives a basic chart but no downloadable data I guess. Get free historical data for the EUR USD (Euro Dollar) currency pair, viewable in daily, weekly or monthly time intervals. Jan 14, 2014 . To get today's exchange rate we need to go to yahoo console. Query " yahoo . finance. xchange" object with pairs of currencies we want. Link with. Apr 24, 2012 . [DAYS]: The historical data period, where "10d" means that we need historical . As with Google Finance, Yahoo allows you to download intraday data for. Dukascopy, the Swiss Forex Bank has a nice CSV DATA Export tool. Need to download historical stock data . Need a large amount ie: since 1962? Well look no further, I got you covered! How to Download Historical Stock Information from. Historical data (daily/monthly) - US Equities to 1693, Foreign Stocks to 1693, Delisted Stocks to 1693 - Fixed Income to 1520, Commodities to 1252, Real Estate to. Q: How can I connect to the Bloomberg data feed? A: DDE links to Bloomberg real-time and snapshot data retrieve values as tab separated strings for specified. DataBull: Quotes4u: DataBull Pro: Download Daily and Historical Market Data from Over 50 International Exchanges and Support for Varios Security Markets. This MQ4 MT4 Expert Advisor Exports Real Time Historical Data Files in Simple. CSV Format for the Ramp Forex Chart Pattern Reconition Screener This Excel spreadsheet downloads historical Forex data from the Internet. You can ask for bid, ask and mid rates for a range of historical currencies. Often people ask me where they can find historical data of stock prices, commodities, interest-rates, bonds, fx rates. In previous posts, we already looked at.

&dupdo; 2012–2016 Historical forex data yahoo

For an industrial engineer, sometimes there arises a need to import process data to a computer for manipulation. The data contained in the PLC resgisters can be imported to Excel using Dynamic Data Exchange (DDE). DDE can be used to exchange data between two programs.

Here are the steps required to achieve this goal:

1. Ensure that the PLC and the computer are connected to the Ethernet. Enable DDE communication in the computer. Simply go to Control Panel>Administrative Tools>Services and enable Network DDE and Network DDE DSDM

2. Open up RSLinx and configure the drivers so that the PLC can be seen online. To do this, in RSLinx click on Communications>Configure Drivers>Ethernet Devices. Then enter the IP address of the PLC.

3. Before you proceed, check to make sure that the PLC is online. To do this go to Communications>RSWho. If online then go to the next step.

4. You will need to configure a topic in RSLinx. To do this, go to DDE/OPC>Topic Configuration. Click on New and give it a name. Then associate this topic with the PLC by clicking on the PLC name on the Data Source tab of the same window then click apply.

5. We are now ready to start a DDE communication. We need to start MS Excel and tell it what the topic is and we are set. This can be done in two ways; using a DDE link and using Macros.

6. Using direct DDE link to import data to Excel. Select a cell in Excel sheet and enter the following formula:

p. ej. =RSLINX|APP_001!TIT4004_PV 7. Using Macros (as contained in the RS Linx Online reference):

Reading data from a PLC via DDE requires a macro like the following. This macro assumes that there is a worksheet created and saved as RSLINX. xls and with sheet DDE_Sheet. This is the destination of the data that will be read by the macro. This routine reads a word:

RSIchan = DDEInitiate(“RSLinx”, “testsol”)

data = DDERequest(RSIchan, “N7:30”)

DDETerminate (RSIchan) End Sub

DDE interface problem with excel 2007 - 64 bit system

You can think of your watch list as threads that you have bookmarked.

You can add tags, authors, threads, and even search results to your watch list. This way you can easily keep track of topics that you're interested in. To view your watch list, click on the "My Newsreader" enlazar.

To add items to your watch list, click the "add to watch list" link at the bottom of any page.

How do I add an item to my watch list?

Buscar

To add search criteria to your watch list, search for the desired term in the search box. Click on the "Add this search to my watch list" link on the search results page.

You can also add a tag to your watch list by searching for the tag with the directive "tag:tag_name" where tag_name is the name of the tag you would like to watch.

Author

To add an author to your watch list, go to the author's profile page and click on the "Add this author to my watch list" link at the top of the page. You can also add an author to your watch list by going to a thread that the author has posted to and clicking on the "Add this author to my watch list" enlazar. You will be notified whenever the author makes a post.

Thread

To add a thread to your watch list, go to the thread page and click the "Add this thread to my watch list" link at the top of the page.

About Newsgroups, Newsreaders, and MATLAB Central

What are newsgroups?

The newsgroups are a worldwide forum that is open to everyone. Newsgroups are used to discuss a huge range of topics, make announcements, and trade files.

Discussions are threaded, or grouped in a way that allows you to read a posted message and all of its replies in chronological order. This makes it easy to follow the thread of the conversation, and to see what’s already been said before you post your own reply or make a new posting.

Newsgroup content is distributed by servers hosted by various organizations on the Internet. Messages are exchanged and managed using open-standard protocols. No single entity “owns” the newsgroups.

There are thousands of newsgroups, each addressing a single topic or area of interest. The MATLAB Central Newsreader posts and displays messages in the comp. soft-sys. matlab newsgroup.

How do I read or post to the newsgroups?

You can use the integrated newsreader at the MATLAB Central website to read and post messages in this newsgroup. MATLAB Central is hosted by MathWorks.

Messages posted through the MATLAB Central Newsreader are seen by everyone using the newsgroups, regardless of how they access the newsgroups. There are several advantages to using MATLAB Central.

One Account Your MATLAB Central account is tied to your MathWorks Account for easy access.

Use the Email Address of Your Choice The MATLAB Central Newsreader allows you to define an alternative email address as your posting address, avoiding clutter in your primary mailbox and reducing spam.

Spam Control Most newsgroup spam is filtered out by the MATLAB Central Newsreader.

Tagging Messages can be tagged with a relevant label by any signed-in user. Tags can be used as keywords to find particular files of interest, or as a way to categorize your bookmarked postings. You may choose to allow others to view your tags, and you can view or search others’ tags as well as those of the community at large. Tagging provides a way to see both the big trends and the smaller, more obscure ideas and applications.

Watch lists Setting up watch lists allows you to be notified of updates made to postings selected by author, thread, or any search variable. Your watch list notifications can be sent by email (daily digest or immediate), displayed in My Newsreader, or sent via RSS feed.

Other ways to access the newsgroups

Use a newsreader through your school, employer, or internet service provider

Pay for newsgroup access from a commercial provider

Use Google Groups

Mathforum. org provides a newsreader with access to the comp. soft sys. matlab newsgroup

Run your own server. For typical instructions, see: http://www. slyck. com/ng. php? page=2

Select Your Country

For those who envisage building an Excel RTD server, I have written a tutorial and open-sourced the code on SourceForge .

The following topics are covered:

How RTD servers work

Architecture

Excel, Multithreading and callbacks

Providing easy-to-read function names

Talking to the GoogleMaps APIs

Avoiding Application Domain misery

Embedding a GoogleMap page in an Excel Task Pane

Creating the Setup project

Changing the Excel RTD Throttle Interval

Utility functions

Building help from the source with Sandcastle

I hope that you will find it useful.

Deja un comentario Cancelar respuesta

Build an Automated Spread Trading System

Build an Automated Spread Trading System description

This online course shows you how to build an automated spread trading model using MS Excel. The System captures the price difference between security pairs of any type - indexes, stocks, futures, options, LEAPs, currencies. The System uses three proven technical indicators - exponential moving averages, Percentage Price Oscillator (PPO), and Donchian Channels - to capture spread movements when profits are likely to be greatest. Includes three spread strategies for Swiss Franc - Japanese Yen futures, Nasdaq - S&P 500 E-Mini, and 10-Year vs 5-Year U. S. Treasury Notes. The System is optimized for use with daily or hourly data, but can be used on any time interval. You are shown how to build a data "hub" with a DDE link, or run the model with free. csv data files from Yahoo! Finance or another source. A PDF Guide is provided along with the online course so you can choose how to learn in the most comfortable way. Also included is a complete backtesting model -- simply import historical data and see statistical and graphical results for your chosen spread strategy.

Technical Requirements - MS Excel for Windows - Adobe Acrobat Reader - 5Mb disk space - Date-Time-Close price data on your chosen time interval - (OPTIONAL) DDE data import link for Excel

Cydia 1.0.9 (Parav) I have been looking Cydia everywhere for my iOS 9.1 and.

MultiTimerZ 1.1.0.0 (Kuwa) Please add a. m/p. m option on alarm setting if possible.

SocialBug 2.50 (Scott Farina) Awesome product and service. I really like this MLM.

IceCream Slideshow Maker 1.01 (Eva Eiza) Perfect for what I need it to do. It has some cool.

CandleScanner 4.3.0.5 (Omkar) Been using the 14 day trial version and it seems to be.

ViewPic for Mac 1.2.0 (Jody Gibson) Excellent zooming on HD images. With this app I see my.

Sweet MIDI Converter for Mac OS X 1.5.0 (Moussa Bouziane) Very nice software and is easy to use; we can also change.

Smart Salon Appointments 2010.30 (Rupesh) For such an expensive product, I would like to test the.

DRM Converter Pro+Video Rip 3.3.3 (Larry L. DeGroff) I had purchased DRM Converter software and now after.

Postimage 1.0.0 (Kaif) Before this software I used to take screenshots using.

Now there are 46 users online at FileHungry. Total downloads count 14296186

Descargo de responsabilidad y advertencia de riesgo. Por favor lee.

Advertencia de Riesgo. La negociación de divisas en margen conlleva un alto nivel de riesgo, y puede no ser adecuado para todos los inversores. El alto grado de apalancamiento puede trabajar en su contra, así como para usted. Antes de decidir invertir en divisas debe considerar cuidadosamente sus objetivos de inversión, nivel de experiencia y apetito de riesgo. Existe la posibilidad de que usted podría sostener una pérdida de parte o la totalidad de su inversión inicial y por lo tanto no debe invertir dinero que no puede permitirse perder. Usted debe ser consciente de todos los riesgos asociados con el comercio de divisas y buscar asesoramiento de un asesor financiero independiente si tiene alguna duda.

Aviso Legal Toda la información publicada en este sitio web es de nuestra opinión y de la opinión de nuestros visitantes, y puede que no refleje la verdad. Utilice su propio buen juicio y busque el asesoramiento de un consultor cualificado, antes de creer y aceptar cualquier información publicada en este sitio web. También nos reservamos el derecho de eliminar, editar, mover o cerrar cualquier publicación por cualquier motivo.

Anuncios Advertencia Los enlaces de publicidad se muestran en todo el sitio. Algunas páginas del sitio pueden contener enlaces de afiliados para productos. Estos anuncios y / o enlaces no reflejan la opinión, el respaldo o la concurrencia de este sitio web o de las partes afiliadas. Las revisiones de la FPA nunca son influenciadas por la publicidad. Algunos anuncios pueden contener afirmaciones potencialmente engañosas y / o desequilibradas e información que puede no revelar los riesgos y otras consideraciones importantes involucradas en el comercio especulativo.

Spammers be Warned Si envía spam a los foros o comentarios de FPA, nos reservamos el derecho de editar su publicación de la forma que desee para burlarse de usted. Al enviarnos spam, usted acepta las modificaciones que hacemos y no emprenda acciones legales u otras contra la FPA o sus asociados por cualquier cosa que hagamos o con su spam.

Condiciones

Intimidad

Anunciar

Contáctenos

Acerca de

ForexPeaceArmy. com tiene relaciones publicitarias y afiliadas con algunas de las compañías mencionadas en este sitio y puede ser compensado si los lectores siguen los enlaces y registrarse. Estamos comprometidos con el manejo imparcial de revisiones y publicaciones independientemente de estas relaciones.

El ejército de la paz de la divisa confía en la publicidad de la bandera para mantenerla LIBRE para todos. También puede ayudar - considere la posibilidad de inhabilitar AdBlocker mientras navega por nuestro sitio. Gracias de nuestra comunidad de comerciantes :-)

I need your help in improving this SAS program!

You are doing your survey at 100 organizations and you need to report the results to all of them. Create a word document template. Make graphs in them by using Excel with links. Use SAS to populate both the EXCEL and the WORD document, so each report carries different statistics.

I need your help in improving this program.

MY syntax looks like you can almost automate the process such that if you need to report to 100 places, you can run the program overnight to find all 100 results the next morning. I have tried to make this happen, but it has not happened. As of now, you need to execute it one report at a time.

When running this syntax with OFFICE 2004 I get a message about updating the word document. I have to sit in front of the computer all day to click YES every five minutes. This is what I do with the current configuration of the program.

In one machine that uses OFFICE 2000, for some reason, a click gets me all the reports, but when I open them, these documents update themselves automatically, such that the excel graphics will be updated to whatever the excel templates has at the last iteration, which is not good. In other words, the results will be all the same in these reports, which is not good.

I wrote above as if the difference is the OFFICE's version difference, but I don't know if that is it.

I need someone to get back to me and say "here is a sas syntax, as well as the VB macros embedded in the word document (see the contents of the zip file). Try it, it works." I look forward to hearing from you. Many people have kindly suggested solutions. I tried them and feel like I am almost there, but I never made it to work.

SOLUTION 1 that failed:

Open the template word document. Go to TOOLS --> OPTIONS --> GENERAL --> Click off "Update Automatics Links OPEN"

Create this macro in a word template.

Sub Macro1() Selection. Fields. Update End Sub

options noxwait noxsync; filename cmds dde 'WinWord|System' ; data _null_ ; file cmds; put '[FileOpen. Name = "' "C:\temp\doc1.doc" '"]' ; put '[macro1]' ; /* call the macro to update the links */ run ;

So what this is doing is that first the word document's automatic updating is OFF, so the document just opens without asking a user whether he/she wants to update (which is good because otherwise, a user has to sit in front of the computer all day). Still, because we want SAS to update info from the linked excel sheet, it excecutes the macro "macro 1" through SAS DDE.

I thought this worked on the day I did this, but next day it stopped working.

SOLUTION 2 that failed:

In the word template create these two macros:

Sub SetOptions1() ' ' Macro5 Macro ' Macro recorded 7/13/2004 by kuekawa' With Options. UpdateLinksAtOpen = True End With End Sub

Sub SetOptions0() ' ' Macro5 Macro ' Macro recorded 7/13/2004 by kuekawa' With Options. UpdateLinksAtOpen = False End With End Sub

And in the same way as in SOLUTION 1, we control one or the other. This failed also. I could not automate the proess. In one situation, the reports stopped responding to the udpate in the excel sheet. In other situations, I open the result reports and they seem to contain the same results, while they have to be different.

SOLUTION 3 that I have not tried (suggested by SAS support) But it seems this is about Excel rather thatn WORD.

<=== Page: 1 === SAS Consultant === emailed w/answer === 24Sep2004 10:58:28 ===>

How to disable the Macro prompt in Excel when running DDE When an Excel spreadsheet that contains a macro is invoked, it will prompt you to enable the macro. Excel will stop the SAS DDE program from executing until the user responds to the prompt. To disable the prompt, do one of the following:

For Excel 2000 only. You cannot do this with earlier versions of Excel. Option 1 - Use medium security 1 Choose security level. a Select Tools>Options>Macro. b Select Security Level tab and select Medium. 2 Create macros that have a digital certificate. a Rerun the Microsoft Setup program. b In Select Features, expand Office tools. c Select Digital Signature for VBA projects and select My Computer>Run. d In Windows Explorer>Office, double-click SelfCert. exe. 3 Sign the macro. a Select Tools=>Macro and then select the Visual Basic Editor. b In the Project explorer, select the project you want to sign c Select Tools>Digital Signatures. d To use the current certificate, select OK. 4 Add the source. a Select Tools>Macro>Security Panel. b Select Trusted Sources tab.

I could give up and just create a report one by one. But I cannot stand the fact that I am almost there to a perfect automation. I hope you can help me with this. Email me at inquiry (at) estat. us

Thread: Two very useful expert advisors

2013-Mar-09 My experience with forex robots

—I started forex trading about. — I was fortunate to find a mql4 programmer from one popular forum. — I spent about $9000 and 2 years, before I have received my own fully automated trading strategy. _http://www. scribd. com/doc/127495979/Best-Forex-Robot — Next step for any forex trader - launch forex money management service or forex signal service. _http://www. scribd. com/doc/121977141/Home-Business-Launch-Guide _http://www. scribd. com/doc/127946190/Copy-Trades-From-3d-Party-Account-Risk-Control — First one is describing how to launch forex signal selling and money management business.

Expert Advisor MT Indicator Forex Software MQL4 Coding